1 PACKAGE PAY_SLA_UPDATE_PKG AS
2 /* $Header: payxlaupg.pkh 120.0.12010000.1 2008/11/20 10:14:29 priupadh noship $ */
3
4 -------------------------------------------------------------------------------------
5 -- Name : Update_Proc_MGR
6 -- Function : This is the Manager Process called by Conc Program
7 -- Upgrade Historical Payroll Data to SLA.
8 -------------------------------------------------------------------------------------
9 PROCEDURE Update_Proc_PAY_MGR (
10 X_errbuf out NOCOPY varchar2,
11 X_retcode out NOCOPY varchar2,
12 P_LEDGER_ID IN VARCHAR2,
13 P_START_PERIOD IN VARCHAR2,
14 P_END_PERIOD IN VARCHAR2,
15 P_DEBUG_FLAG IN VARCHAR2,
16 X_batch_size in number default 1,
17 X_Num_Workers in number default 5,
18 X_Argument4 in varchar2 default null,
19 X_Argument5 in varchar2 default null,
20 X_Argument6 in varchar2 default null,
21 X_Argument7 in varchar2 default null,
22 X_Argument8 in varchar2 default null,
23 X_Argument9 in varchar2 default null,
24 X_Argument10 in varchar2 default null);
25
26 ----------------------------------------------------------------------------------------
27 -- Name : Update_Proc_PAY_WKR
28 -- Function : Worker process to update Payroll Sub Ledger to SLA data model.
29 -- This is called by Manager Procewss Update_Proc_PAY_MGR
30
31 ----------------------------------------------------------------------------------------
32 PROCEDURE Update_Proc_PAY_WKR (
33 X_errbuf out NOCOPY varchar2,
34 X_retcode out NOCOPY varchar2,
35 X_batch_size in number,
36 X_Worker_Id in number,
37 X_Num_Workers in number,
38 X_Argument4 in varchar2 default null,
39 X_Argument5 in varchar2 default null,
40 X_Argument6 in varchar2 default null,
41 X_Argument7 in varchar2 default null,
42 X_Argument8 in varchar2 default null,
43 X_Argument9 in varchar2 default null,
44 X_Argument10 in varchar2 default null);
45
46 ----------------------------------------------------------------------------------------
47 -- Name : GET_SEQUENCE_VALUE
48 -- Function : TO get the sequence values for XLA Sequences .
49 ----------------------------------------------------------------------------------------
50 FUNCTION GET_SEQUENCE_VALUE(p_row_number in number,p_tab_name varchar2)
51 RETURN number ;
52
53 ----------------------------------------------------------------------------------------
54 -- Name : GET_FULL_NAME
55 -- Function : TO get the Full Name from Assignment_Action_Id
56 ----------------------------------------------------------------------------------------
57
58 FUNCTION get_full_name(p_assignment_act_id in pay_assignment_actions.assignment_action_id%type,
59 p_eff_date in date)
60 RETURN varchar2;
61
62 -------------------------------------------------------------------------------------
63 -- Name : Update_Payroll_Subledger
64 -- Type : Private
65 -- Function : To update Payroll Sub Ledger to SLA data model from Start ID
66 -- to End ID for Ledger (P_LEDGER_ID).
67 -- Pre-reqs :
68 -- Parameters :
69 -- IN : X_start_id in number
70 -- X_end_id in number
71 -- P_LEDGER_ID in varchar2
72 -- P_MGR_REQ_ID in varchar2
73 --
74 -- OUT : X_errbuf out NOCOPY varchar2,
75 -- X_retcode out NOCOPY varchar2
76 --
77 -- Notes : The Procedure is called from Update_Proc_PAY_WKR.
78 --
79 -- End of comments
80 -------------------------------------------------------------------------------------
81 PROCEDURE Update_PAYROLL_Subledger (
82 X_errbuf out NOCOPY varchar2,
83 X_retcode out NOCOPY varchar2,
84 X_start_id in number,
85 X_end_id in number,
86 P_LEDGER_ID in varchar2,
87 P_MGR_REQ_ID in varchar2,
88 P_DEBUG_FLAG in varchar2);
89
90
91 END;