1 PACKAGE PSP_ENC_CREATE_LINES AUTHID CURRENT_USER AS
2 /*$Header: PSPENLNS.pls 120.2.12020000.3 2012/08/10 11:35:22 lkodaman ship $*/
3
4 /***** Commented the following procedure for create and update multi thread enh.
5 Procedure Create_Enc_Lines(
6 errbuf OUT NOCOPY varchar2,
7 retCode OUT NOCOPY varchar2,
8 p_Payroll_ID IN Number,
9 p_Enc_Line_Type IN varchar2,
10 p_business_group_id IN Number,
11 p_set_of_books_id IN Number);
12 End of comment for Create and Update multi thread enh. *****/
13
14 g_payroll_mode VARCHAR2(15); --13566809
15
16 --13566809 -- Introduced the below 2 functions for CUEL performance
17
18 FUNCTION get_asg_pay_end_date(p_payroll_mode IN VARCHAR,
19 p_payroll_action_id IN NUMBER,
20 p_assignmnet_id IN NUMBER,
21 p_business_group_id IN NUMBER,
22 p_payroll_id IN NUMBER) RETURN DATE;
23
24 FUNCTION get_payroll_pay_end_date(p_payroll_id IN NUMBER
25 ) return date ;
26
27
28 PROCEDURE cel_init(p_payroll_action_id IN NUMBER);
29 PROCEDURE cel_range_code (pactid IN NUMBER,
30 sqlstr OUT NOCOPY VARCHAR2);
31 PROCEDURE cel_asg_action_code (p_pactid IN NUMBER,
32 start_asg IN NUMBER,
33 end_asg IN NUMBER,
34 p_chunk_num IN NUMBER);
35 PROCEDURE cel_archive (p_payroll_action_id IN NUMBER,
36 p_chunk_number IN NUMBER);
37 procedure cel_deinit(p_payroll_action_id in number);
38 PROCEDURE rollback_cel (errbuf OUT NOCOPY VARCHAR2,
39 retcode OUT NOCOPY VARCHAR2,
40 p_payroll_action_id IN NUMBER,
41 p_person_id1 IN NUMBER,
42 p_assignment_id1 IN NUMBER,
43 p_person_id2 IN NUMBER,
44 p_assignment_id2 IN NUMBER,
45 p_person_id3 IN NUMBER,
46 p_assignment_id3 IN NUMBER,
47 p_person_id4 IN NUMBER,
48 p_assignment_id4 IN NUMBER,
49 p_person_id5 IN NUMBER,
50 p_assignment_id5 IN NUMBER);
51 END;