PACKAGE: APPS.PAY_IE_CESS_REPORT

Source

1 PACKAGE PAY_IE_CESS_REPORT AUTHID CURRENT_USER as
2 /* $Header: pyiecess.pkh 120.1 2010/04/28 07:11:23 knadhan noship $ */
3 level_cnt number;
4 
5 g_payroll_id  VARCHAR2(100);
6 g_business_Group_id  VARCHAR2(100);
7 g_start_date  date;
8 g_end_date  date;
9 g_person_id  VARCHAR2(100);
10 g_employer_id VARCHAR2(100);
11 g_file_type varchar2(50);
12 g_rep_group varchar2(50);
13 g_pact_id NUMBER;
14 --g_file_type varchar2(10):='N';
15 g_where_clause VARCHAR2(1000);
16 g_where_clause1 VARCHAR2(1000);
17 g_where_clause2 VARCHAR2(1000);
18 g_where_clause3 VARCHAR2(1000);
19 g_submitted VARCHAR2(1000):='Already Submitted';
20 g_org_name varchar2(200);
21 --g_archive_effective_date date;
22 
23 PROCEDURE range_code(	pactid IN NUMBER,
24 			sqlstr OUT nocopy VARCHAR2);
25 
26 PROCEDURE assignment_action_code(pactid in number,
27 			          stperson in number,
28 				  endperson in number,
29 				  chunk in number);
30 
31 PROCEDURE archive_init(p_payroll_action_id IN NUMBER);
32 
33 PROCEDURE archive_data(p_assactid in number,
34                         p_effective_date in date);
35 /*
36 FUNCTION get_arc_bal_value(
37                      p_assignment_action_id  in number
38 		    ,p_payroll_action_id     in number     -- 5005788
39                     ,p_balance_name          in varchar2 ) return number;
40 
41 		    */
42 
43 PROCEDURE gen_body_xml;
44 
45 PROCEDURE gen_header_xml;
46 
47 PROCEDURE gen_footer_xml;
48 
49 /* 9544490 */
50 --
51 /*
52 CURSOR  c_body IS
53     SELECT 'TRANSFER_ACT_ID=P', paa.assignment_action_id
54     FROM    pay_assignment_actions paa
55     WHERE   paa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value
56 	     ('TRANSFER_PAYROLL_ACTION_ID'))
57     ORDER BY paa.assignment_action_id;
58 */
59 
60 CURSOR  c_body IS
61     SELECT 'TRANSFER_ACT_ID=P', paa.assignment_action_id
62     FROM    pay_assignment_actions paa,
63             pay_action_information pai
64     WHERE   paa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value
65 	     ('TRANSFER_PAYROLL_ACTION_ID'))
66 	    and paa.assignment_action_id=pai.action_context_id
67 	    and pai.ACTION_INFORMATION_CATEGORY='IE CESS INFORMATION'
68 	    and pai.ACTION_CONTEXT_TYPE='AAP'
69     ORDER BY paa.assignment_action_id;
70 --
71 
72 CURSOR c_hdr IS
73     SELECT  'PAYROLL_ACTION_ID=P'
74       ,pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
75     FROM  dual;
76 
77 CURSOR c_asg_actions IS
78     SELECT  'TRANSFER_ACT_ID=P'
79       ,pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
80     FROM  dual;
81 
82 
83 END PAY_IE_CESS_REPORT;