APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_RDB_PROCESS_TIMECARDS

Line 691: ' INSERT INTO hxc_rdb_process_timecards

687:
688: -- Bug 12700547
689: -- Added hints
690: l_rdb_process_sql VARCHAR2(32000) :=
691: ' INSERT INTO hxc_rdb_process_timecards
692: (timecard_id,
693: resource_id,
694: start_time,
695: stop_time,

Line 2832: UPDATE hxc_rdb_process_timecards

2828: RETURNING timecard_id
2829: BULK COLLECT INTO g_temp_tc_list ;
2830:
2831: FORALL i IN g_temp_tc_list.FIRST..g_temp_tc_list.LAST
2832: UPDATE hxc_rdb_process_timecards
2833: SET stage = 'ERRORED'
2834: WHERE timecard_id = g_temp_tc_list(i)
2835: AND request_id = FND_GLOBAL.CONC_REQUEST_ID
2836: AND process = g_params.p_process;

Line 4497: UPDATE hxc_rdb_process_timecards

4493: PRAGMA AUTONOMOUS_TRANSACTION;
4494:
4495: BEGIN
4496:
4497: UPDATE hxc_rdb_process_timecards
4498: SET stage = 'SKIPPED'
4499: WHERE ret_user_id = FND_GLOBAL.user_id
4500: AND request_id = FND_GLOBAL.conc_request_id
4501: AND process = g_params.p_process

Line 10278: UPDATE hxc_rdb_process_timecards

10274:
10275: l_tctab := SET(l_tctab);
10276:
10277: FORALL i IN l_tctab.FIRST..l_tctab.LAST
10278: UPDATE hxc_rdb_process_timecards
10279: SET stage = p_to_status
10280: WHERE timecard_id = l_tctab(i)
10281: AND stage = p_from_status
10282: AND process = g_params.p_process;

Line 10309: UPDATE hxc_rdb_process_timecards

10305: RETURN;
10306: END IF;
10307:
10308: FORALL i IN p_tc_list.FIRST..p_tc_list.LAST
10309: UPDATE hxc_rdb_process_timecards
10310: SET stage = p_to_status
10311: WHERE timecard_id = p_tc_list(i)
10312: AND stage = p_from_status
10313: AND process = g_params.p_process;