1 PACKAGE PAY_MX_SOC_SEC_ARCHIVE AUTHID CURRENT_USER as
2 /* $Header: paymxsocsecarch.pkh 120.11.12020000.2 2012/11/09 17:09:31 sjawid 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 sjawid 09-Nov-2012 115.9 Added function validate_person_id
38 ===========================================================================*/
39
40
41 FUNCTION get_start_date( p_gre_id IN VARCHAR2)
42 RETURN VARCHAR2;
43
44 FUNCTION validate_person_id (p_person_id IN NUMBER,
45 p_assignment_id IN NUMBER,
46 p_start_date IN DATE,
47 p_end_date IN DATE,
48 p_periodic_start_date IN DATE,
49 p_periodic_end_date IN DATE,
50 p_payroll_action_id IN NUMBER,
51 p_gre_id IN NUMBER,
52 p_business_group_id IN NUMBER,
53 p_vidw_check IN VARCHAR2)
54 RETURN VARCHAR2;
55
56 PROCEDURE range_cursor( p_payroll_action_id IN NUMBER
57 ,p_sqlstr OUT NOCOPY VARCHAR2);
58
59 PROCEDURE action_creation( p_payroll_action_id IN NUMBER
60 ,p_start_person_id IN NUMBER
61 ,p_end_person_id IN NUMBER
62 ,p_chunk IN NUMBER);
63
64 PROCEDURE archive_data(p_asg_action_id IN NUMBER,
65 p_effective_date IN DATE);
66
67 PROCEDURE archinit(p_payroll_action_id IN NUMBER);
68
69 FUNCTION get_dates_for_valueset(p_date IN VARCHAR2)
70 RETURN varchar2;
71
72 FUNCTION seniority_changed(p_person_id IN NUMBER
73 ,p_curr_date IN DATE
74 ,p_prev_date IN DATE) RETURN VARCHAR2;
75
76 FUNCTION arch_exists_without_upgrade
77 (
78 p_business_group_id NUMBER
79 ) RETURN VARCHAR2;
80
81 TYPE perasg IS RECORD ( person_id NUMBER(15)
82 ,assignment_id NUMBER(15));
83
84 TYPE person_assignment IS TABLE OF perasg INDEX BY BINARY_INTEGER;
85
86 per_asg person_assignment;
87
88 lrr_act_tab pay_emp_action_arch.action_info_table;
89
90 TYPE datedtbls IS RECORD ( table_name VARCHAR2(150) );
91
92 TYPE dated_tables IS TABLE OF datedtbls INDEX BY BINARY_INTEGER;
93
94 dated_tbls dated_tables;
95
96 TYPE fix_var_idw_rec IS RECORD ( idw_type VARCHAR2(15)
97 ,idw_date DATE );
98
99 TYPE fixed_variable_idw IS TABLE OF fix_var_idw_rec INDEX BY BINARY_INTEGER;
100
101 TYPE hire_sep_rec IS RECORD ( trn_type VARCHAR2(15)
102 ,trn_date DATE );
103
104 TYPE hire_separation IS TABLE OF hire_sep_rec INDEX BY BINARY_INTEGER;
105
106 TYPE transaction_rec IS RECORD ( type VARCHAR2(15)
107 ,date VARCHAR2(50)
108 ,dis_num VARCHAR2(50)
109 ,abs_days NUMBER
110 ,idw_vol_contr NUMBER
111 ,salary_type VARCHAR2(50)
112 ,abs_start_date VARCHAR2(20)
113 ,abs_end_date VARCHAR2(20)
114 ,subsidized_days per_disabilities_f.dis_information2%type
115 ,disability_percent NUMBER
116 ,dis_insurance_type per_disabilities_f.dis_information3%type
117 ,risk_type per_work_incidents.inc_information1%type
118 ,consequence per_disabilities_f.dis_information4%type
119 ,disability_control per_disabilities_f.dis_information5%type
120 ,credit_number pay_element_entry_values_f.screen_entry_value%type
121 ,discount_type pay_element_entry_values_f.screen_entry_value%type
122 ,discount_value pay_element_entry_values_f.screen_entry_value%type
123 ,redxn_table_applies pay_element_entry_values_f.screen_entry_value%type);
124
125 TYPE transaction IS TABLE OF transaction_rec INDEX BY BINARY_INTEGER;
126
127 gv_mode VARCHAR2(10);
128 gv_periodic_start_date VARCHAR2(22);
129 gv_periodic_end_date VARCHAR2(22);
130
131 END PAY_MX_SOC_SEC_ARCHIVE;