1 PACKAGE PAY_MX_SOC_SEC_ARCHIVE AUTHID CURRENT_USER as
2 /* $Header: paymxsocsecarch.pkh 120.9.12010000.2 2008/09/01 14:29:31 swamukhe ship $ */
3 /*
4 +=========================================================================+
5 | Copyright (c) 2003 Oracle Corporation |
6 | Redwood Shores, California, USA |
7 | All rights reserved. |
8 +=========================================================================+
9 Package Header Name : pay_mx_soc_sec_archive
10 Package File Name : paymxsocsecarch.pkh
11
12 Description : Used for Social Security Archiver.
13
14
15 Change List:
16 ------------
17
18 Name Date Version Bug Text
19 ------------- ----------- ------- ------- --------------------------------
20 vpandya 28-Apr-2005 115.0 Initial Version
21 vpandya 02-May-2005 115.1 4409303 Added PL/SQL tables.
22 vpandya 18-Jul-2005 115.2 Added a few global variables.
23 vpandya 28-Jul-2005 115.3 Added a global variables
24 gv_periodic_end_date.
25 sdahiya 28-Dec-2005 115.4 Added function seniority_changed
26 to support salary change
27 transaction due to implicit
28 changes in seniority of EEs.
29 sdahiya 23-Mar-2006 115.5 Added segments to transaction_rec
30 sdahiya 28-Jun-2006 115.6 5355325 Increased widths of abs_start_date
31 and abs_end_date in transaction_rec
32 sdahiya 24-Jan-2007 115.7 Function arch_exists_without_upgrade
33 added.
34 vpandya 20-Mar-2007 115.8 5944540 Leapfrog ver 115.6 to resolve R12
35 Branch Line issue.
36 vpandya 20-Mar-2007 115.9 This is the same as 115.7.
37 ===========================================================================*/
38
39
40 FUNCTION get_start_date( p_gre_id IN VARCHAR2)
41 RETURN VARCHAR2;
42
43 PROCEDURE range_cursor( p_payroll_action_id IN NUMBER
44 ,p_sqlstr OUT NOCOPY VARCHAR2);
45
46 PROCEDURE action_creation( p_payroll_action_id IN NUMBER
47 ,p_start_person_id IN NUMBER
48 ,p_end_person_id IN NUMBER
49 ,p_chunk IN NUMBER);
50
51 PROCEDURE archive_data(p_asg_action_id IN NUMBER,
52 p_effective_date IN DATE);
53
54 PROCEDURE archinit(p_payroll_action_id IN NUMBER);
55
56 FUNCTION get_dates_for_valueset(p_date IN VARCHAR2)
57 RETURN varchar2;
58
59 FUNCTION seniority_changed(p_person_id IN NUMBER
60 ,p_curr_date IN DATE
61 ,p_prev_date IN DATE) RETURN VARCHAR2;
62
63 FUNCTION arch_exists_without_upgrade
64 (
65 p_business_group_id NUMBER
66 ) RETURN VARCHAR2;
67
68 TYPE perasg IS RECORD ( person_id NUMBER(15)
69 ,assignment_id NUMBER(15));
70
71 TYPE person_assignment IS TABLE OF perasg INDEX BY BINARY_INTEGER;
72
73 per_asg person_assignment;
74
75 lrr_act_tab pay_emp_action_arch.action_info_table;
76
77 TYPE datedtbls IS RECORD ( table_name VARCHAR2(150) );
78
79 TYPE dated_tables IS TABLE OF datedtbls INDEX BY BINARY_INTEGER;
80
81 dated_tbls dated_tables;
82
83 TYPE fix_var_idw_rec IS RECORD ( idw_type VARCHAR2(15)
84 ,idw_date DATE );
85
86 TYPE fixed_variable_idw IS TABLE OF fix_var_idw_rec INDEX BY BINARY_INTEGER;
87
88 TYPE hire_sep_rec IS RECORD ( trn_type VARCHAR2(15)
89 ,trn_date DATE );
90
91 TYPE hire_separation IS TABLE OF hire_sep_rec INDEX BY BINARY_INTEGER;
92
93 TYPE transaction_rec IS RECORD ( type VARCHAR2(15)
94 ,date VARCHAR2(50)
95 ,dis_num VARCHAR2(50)
96 ,abs_days NUMBER
97 ,idw_vol_contr NUMBER
98 ,salary_type VARCHAR2(50)
99 ,abs_start_date VARCHAR2(20)
100 ,abs_end_date VARCHAR2(20)
101 ,subsidized_days per_disabilities_f.dis_information2%type
102 ,disability_percent NUMBER
103 ,dis_insurance_type per_disabilities_f.dis_information3%type
104 ,risk_type per_work_incidents.inc_information1%type
105 ,consequence per_disabilities_f.dis_information4%type
106 ,disability_control per_disabilities_f.dis_information5%type
107 ,credit_number pay_element_entry_values_f.screen_entry_value%type
108 ,discount_type pay_element_entry_values_f.screen_entry_value%type
109 ,discount_value pay_element_entry_values_f.screen_entry_value%type
110 ,redxn_table_applies pay_element_entry_values_f.screen_entry_value%type);
111
112 TYPE transaction IS TABLE OF transaction_rec INDEX BY BINARY_INTEGER;
113
114 gv_mode VARCHAR2(10);
115 gv_periodic_start_date VARCHAR2(22);
116 gv_periodic_end_date VARCHAR2(22);
117
118 END PAY_MX_SOC_SEC_ARCHIVE;