APPS.PAY_SLA_UPDATE_PKG dependencies on PAY_SLA_UPDATE_PKG

Line 1: PACKAGE BODY PAY_SLA_UPDATE_PKG AS

1: PACKAGE BODY PAY_SLA_UPDATE_PKG AS
2: /* $Header: payxlaupg.pkb 120.0.12010000.4 2009/01/28 10:00:51 priupadh noship $*/
3: g_pkg_name CONSTANT VARCHAR2(30) := 'PAY_SLA_UPDATE_PKG';
4: gv_process_name CONSTANT varchar2(10) := 'PAYSLAUPG';
5:

Line 3: g_pkg_name CONSTANT VARCHAR2(30) := 'PAY_SLA_UPDATE_PKG';

1: PACKAGE BODY PAY_SLA_UPDATE_PKG AS
2: /* $Header: payxlaupg.pkb 120.0.12010000.4 2009/01/28 10:00:51 priupadh noship $*/
3: g_pkg_name CONSTANT VARCHAR2(30) := 'PAY_SLA_UPDATE_PKG';
4: gv_process_name CONSTANT varchar2(10) := 'PAYSLAUPG';
5:
6: g_xla_tran_s xla_transaction_entities.entity_id%type;
7: g_xla_event_s xla_events.event_id%type;

Line 146: l_module CONSTANT VARCHAR2(90) := 'PAY_SLA_UPDATE_PKG.Update_Proc_MGR';

142: X_Argument9 in varchar2 default null,
143: X_Argument10 in varchar2 default null)
144: IS
145:
146: l_module CONSTANT VARCHAR2(90) := 'PAY_SLA_UPDATE_PKG.Update_Proc_MGR';
147:
148: l_stmt_num number;
149: l_api_name CONSTANT VARCHAR2(30) := 'Update_Proc_PAY_MGR';
150: l_api_version CONSTANT NUMBER := 1.0;

Line 412: l_module CONSTANT VARCHAR2(90) := 'PAY_SLA_UPDATE_PKG.Update_Proc_WKR';

408: X_Argument9 in varchar2 default null,
409: X_Argument10 in varchar2 default null)
410: IS
411:
412: l_module CONSTANT VARCHAR2(90) := 'PAY_SLA_UPDATE_PKG.Update_Proc_WKR';
413: l_worker_id number;
414: l_product varchar2(30);
415: l_table_name varchar2(30) := 'PAY_PATCH_STATUS';
416: l_id_column varchar2(30) := 'ID';

Line 482: PAY_SLA_UPDATE_PKG.Update_Payroll_Subledger(

478: fnd_file.put_line(fnd_file.log,'l_start_id :'||l_start_id);
479: fnd_file.put_line(fnd_file.log,'l_end_id :'||l_end_id);
480: End if;
481:
482: PAY_SLA_UPDATE_PKG.Update_Payroll_Subledger(
483: X_errbuf=>X_errbuf,
484: X_retcode=>X_retcode,
485: X_start_id=>l_start_id,
486: X_end_id=>l_end_id,

Line 653: l_module CONSTANT VARCHAR2(90) := 'PAY_SLA_UPDATE_PKG.Update_Payroll_Subledger';

649: p_debug_flag in varchar2
650: )
651: IS
652:
653: l_module CONSTANT VARCHAR2(90) := 'PAY_SLA_UPDATE_PKG.Update_Payroll_Subledger';
654: lv_application_id CONSTANT number := 801;
655: l_upg_batch_id number;
656: lv_Error_msg varchar2(1000);
657: lv_application_name CONSTANT varchar2(10) := 'Payroll';

Line 1167: END PAY_SLA_UPDATE_PKG;

1163: X_errbuf:=l_module||': '|| SQLERRM;
1164: fnd_file.put_line(FND_FILE.LOG,'Error Update_Payroll_Subledger '||SQLCODE||' '||SQLERRM);
1165: end Update_Payroll_Subledger;
1166:
1167: END PAY_SLA_UPDATE_PKG;