DELETE Data into HCM Fusion using parameterized BI Publisher Report

Summary:

We want to delete time cards via parameter through flow pattern.

1. QUERY:

SELECT HTRG.TM REC GRP ID TIMERECORDGROUPID,

substr(replace (HTRG.START_TIME, '-','/'), 1,19) TCSTARTTIME,

substr(replace(HTRG.STOP_TIME, '-','/'), 1,19) TCSTOPTIME,

HTRG.RESOURCE ID RESOURCEID, 'RPTD TIME' GroupType, 'PERSON' ResourceType

FROM HWM_TM_REC_GRP HTRG, PER_ALL_PEOPLE_ PEOPLE_F PAPF

WHERE 1=1

AND HTRG.RESOURCE_ID = PAPF.PERSON_ID

AND PAPF.PERSON NUMBER :P_PERSON_NUMBER

AND TRUNC (HTRG.START TIME) = :P_START_TIME

AND TRUNC (HTRG.STOP TIME) =:P_STOP_TIME

2. Parameters in flow pattern: P_PERSON_NUMBER, P_START_TIME & P_STOP_TIME