DBA Data[Home] [Help]

APPS.HR_USER_ACCT_EMP_EXTRACT dependencies on HR_USER_ACCT_EMP_EXTRACT

Line 1: PACKAGE BODY HR_USER_ACCT_EMP_EXTRACT AS

1: PACKAGE BODY HR_USER_ACCT_EMP_EXTRACT AS
2: /* $Header: hrempext.pkb 120.6.12020000.2 2012/08/07 08:50:04 sudedas ship $*/
3: --
4: --
5: -- |--------------------------------------------------------------------------|

Line 12: g_package constant varchar2(72) :='hr_user_acct_emp_extract';

8: g_data_pump_create_user constant varchar2(30) := 'hrdpp_create_user_acct';
9: g_data_pump_upd_user constant varchar2(30) := 'hrdpp_update_user_acct';
10: g_commit_limit constant number := 20;
11: l_commit_count number default 0;
12: g_package constant varchar2(72) :='hr_user_acct_emp_extract';
13: g_dp_str constant varchar2(15) :='~!@UAEEP@!~';
14: g_dp_ins_str constant varchar2(25) := 'SS_' || g_dp_str || '_INS';
15: g_dp_upd_str constant varchar2(25) := 'SS_' || g_dp_str || '_UPD';
16:

Line 126: l_proc varchar2(2000) := 'hr_user_acct_emp_extract.run_process';

122: AND ast.active_flag = 'Y'
123: AND ast.per_system_status = p_per_sys_status;
124:
125:
126: l_proc varchar2(2000) := 'hr_user_acct_emp_extract.run_process';
127: l_batch_name_found varchar2(1) default null;
128: l_data_pump_pkg_name1 varchar2(30) default null;
129: l_data_pump_pkg_name2 varchar2(30) default null;
130: l_date_from date default null;

Line 1038: END HR_USER_ACCT_EMP_EXTRACT;

1034: --
1035: END run_process;
1036: --
1037: --
1038: END HR_USER_ACCT_EMP_EXTRACT;