PACKAGE: APPS.PAY_IE_EHECS_REPORT_PKG

Source

1 PACKAGE PAY_IE_EHECS_REPORT_PKG AUTHID CURRENT_USER as
2 /* $Header: pyieehecs.pkh 120.1.12010000.1 2008/07/27 22:49:39 appldev ship $ */
3 level_cnt number;
4 
5 g_payroll_id  VARCHAR2(100);
6 g_business_Group_id  VARCHAR2(100);
7 g_employer_id VARCHAR2(100);
8 g_rep_group varchar2(50);
9 g_pact_id NUMBER;
10 g_ie_nat_min_wage_rate Number;
11 
12 g_where_clause VARCHAR2(1000);
13 g_where_clause1 VARCHAR2(1000);
14 g_where_clause_asg_set VARCHAR2(1000);
15 g_exc_inc VARCHAR2(10);
16 
17 g_year varchar2(50);
18 g_quarter varchar2(50);
19 g_assignment_set_id varchar2(50);
20 g_occupational_category varchar2(50);
21 g_occupational_category_M_C_P varchar2(50);
22 g_report_type varchar2(50);
23 g_declare_date varchar2(50);
24 g_change_indicator varchar2(50);
25 g_comments varchar2(300);
26 
27 g_qtr_start_date date;
28 g_qtr_end_date date;
29 
30 g_org_name varchar2(200);
31 g_archive_effective_date date;
32 
33 TYPE balance_name_rec IS RECORD (
34   balance_name VARCHAR2(100));
35 
36 TYPE balance_id_rec IS RECORD (
37   defined_balance_id NUMBER,
38   balance_name VARCHAR2(100));
39 
40 TYPE balance_name_tab IS TABLE OF balance_name_rec INDEX BY BINARY_INTEGER;
41 TYPE balance_id_tab   IS TABLE OF balance_id_rec   INDEX BY BINARY_INTEGER;
42 
43 g_balance_name balance_name_tab;
44 g_def_bal_id  balance_id_tab;
45 
46 
47 PROCEDURE range_code(	pactid IN NUMBER,
48 			sqlstr OUT nocopy VARCHAR2);
49 
50 PROCEDURE assignment_action_code(pactid in number,
51 			          stperson in number,
52 				  endperson in number,
53 				  chunk in number);
54 
55 PROCEDURE archive_init(p_payroll_action_id IN NUMBER);
56 
57 PROCEDURE archive_data(p_assactid in number,
58                         p_effective_date in date);
59 procedure archive_deinit(pactid IN NUMBER);
60 
61 PROCEDURE gen_body_xml;
62 
63 PROCEDURE gen_header_xml;
64 
65 PROCEDURE gen_footer_xml;
66 
67 CURSOR  c_body IS
68 SELECT 'TRANSFER_ACT_ID=P', ptoa.Object_Action_id
69 FROM    pay_temp_object_actions ptoa
70 WHERE   ptoa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value
71 	     ('TRANSFER_PAYROLL_ACTION_ID'))
72 ORDER BY ptoa.Object_Action_id;
73 
74 CURSOR c_hdr IS
75     SELECT  'PAYROLL_ACTION_ID=P'
76       ,pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
77     FROM  dual;
78 
79 CURSOR c_asg_actions IS
80     SELECT  'TRANSFER_ACT_ID=P'
81       ,pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
82     FROM  dual;
83 END PAY_IE_EHECS_REPORT_PKG;