APPS.HRI_OPL_MULTI_THREAD dependencies on HRI_ADM_MTHD_ACTIONS

Line 516: INSERT into HRI_ADM_MTHD_ACTIONS

512: g_mthd_action_array.request_id := fnd_global.conc_request_id;
513: g_mthd_action_array.debug_flag := g_debug_flag;
514: g_mthd_action_array.process_name := l_process_name;
515: --
516: INSERT into HRI_ADM_MTHD_ACTIONS
517: ( MTHD_ACTION_ID,
518: PROGRAM,
519: REQUEST_ID,
520: COLLECT_FROM_DATE,

Line 554: (hri_adm_mthd_actions_s.nextval,

550: END_TIME ,
551: PROCESS_TYPE ,
552: PROCESS_NAME)
553: VALUES
554: (hri_adm_mthd_actions_s.nextval,
555: g_mthd_action_array.PROGRAM,
556: g_mthd_action_array.REQUEST_ID,
557: g_mthd_action_array.COLLECT_FROM_DATE,
558: g_mthd_action_array.COLLECT_TO_DATE,

Line 1280: UPDATE hri_adm_mthd_actions

1276: dbg('inside set_action_status');
1277: --
1278: -- Update the status of the mulithread action as processed
1279: --
1280: UPDATE hri_adm_mthd_actions
1281: SET end_time = SYSDATE,
1282: status = 'PROCESSED'
1283: WHERE mthd_action_id = g_mthd_action_id;
1284: --

Line 1605: UPDATE hri_adm_mthd_actions

1601: dbg(sql%rowcount||' range records marked as Error');
1602: --
1603: -- Change the status action record to ERROR
1604: --
1605: UPDATE hri_adm_mthd_actions
1606: SET status = 'ERROR'
1607: WHERE mthd_action_id = p_mthd_action_id;
1608: --
1609: commit;

Line 1688: RETURN hri_adm_mthd_actions%rowtype

1684: -- the multithreading action arrays
1685: -- ----------------------------------------------------------------------------
1686: --
1687: FUNCTION get_mthd_action_array(p_mthd_action_id IN NUMBER)
1688: RETURN hri_adm_mthd_actions%rowtype
1689: IS
1690: --
1691: CURSOR c_adm_mthd_action IS
1692: SELECT *

Line 1693: FROM HRI_ADM_MTHD_ACTIONS

1689: IS
1690: --
1691: CURSOR c_adm_mthd_action IS
1692: SELECT *
1693: FROM HRI_ADM_MTHD_ACTIONS
1694: WHERE mthd_action_id = p_mthd_action_id;
1695: --
1696: BEGIN
1697: --

Line 1736: -- A new record will be created in hri_adm_mthd_actions

1732: --
1733: END IF;
1734: --
1735: -- The mthd action id of the current process is not defined.
1736: -- A new record will be created in hri_adm_mthd_actions
1737: -- corresponding to this process
1738: --
1739: -- store the program name and start time of the process
1740: --

Line 1767: UPDATE hri_adm_mthd_actions

1763: -- If a full refresh then set the flag and update the
1764: -- collect from date
1765: IF (p_full_refresh = 'Y') THEN
1766:
1767: UPDATE hri_adm_mthd_actions
1768: SET full_refresh_flag = 'Y'
1769: ,collect_from_date = p_global_start_date
1770: WHERE mthd_action_id = p_mthd_action_id;
1771:

Line 1775: UPDATE hri_adm_mthd_actions

1771:
1772: -- Otherwise just set the full refresh flag
1773: ELSE
1774:
1775: UPDATE hri_adm_mthd_actions
1776: SET full_refresh_flag = 'N'
1777: WHERE mthd_action_id = p_mthd_action_id;
1778:
1779: END IF;