DBA Data[Home] [Help]

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.4 2011/09/26 09:45:27 kskoduri ship $*/
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.4 2011/09/26 09:45:27 kskoduri ship $*/
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 485: PAY_SLA_UPDATE_PKG.Update_Payroll_Subledger(

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

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

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

Line 1170: END PAY_SLA_UPDATE_PKG;

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