1 PACKAGE PAY_SA_ARCHIVE AUTHID CURRENT_USER AS
2 /* $Header: pysaparc.pkh 120.1.12020000.1 2012/06/28 18:58:05 appldev ship $ */
3
4
5
6 /* TYPE element_rec IS RECORD (
7 classification_name VARCHAR2(60)
8 ,element_name VARCHAR2(60)
9 ,element_type_id NUMBER
10 ,input_value_id NUMBER
11 ,element_type VARCHAR2(1)
12 ,uom VARCHAR2(1)
13 ,archive_flag VARCHAR2(1));
14
15 TYPE balance_rec IS RECORD (
16 balance_name VARCHAR2(60),
17 defined_balance_id NUMBER,
18 balance_type_id NUMBER);
19
20 TYPE lock_rec IS RECORD (
21 archive_assact_id NUMBER);
22
23
24 TYPE element_table IS TABLE OF element_rec INDEX BY BINARY_INTEGER;
25 TYPE balance_table IS TABLE OF balance_rec INDEX BY BINARY_INTEGER;
26 TYPE lock_table IS TABLE OF lock_rec INDEX BY BINARY_INTEGER;
27
28 g_element_table element_table;
29 g_user_balance_table balance_table;
30 g_lock_table lock_table;
31
32 g_index NUMBER := -1;
33 g_index_assact NUMBER := -1;
34 g_index_bal NUMBER := -1; */
35
36
37 FUNCTION GET_PARAMETER(p_parameter_string IN VARCHAR2
38 ,p_token IN VARCHAR2
39 ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2;
40
41 PROCEDURE GET_ALL_PARAMETERS(p_payroll_action_id IN NUMBER
42 ,p_business_group_id OUT NOCOPY NUMBER
43 ,p_start_date OUT NOCOPY VARCHAR2
44 ,p_end_date OUT NOCOPY VARCHAR2
45 ,p_effective_date OUT NOCOPY DATE
46 ,p_payroll_id OUT NOCOPY VARCHAR2
47 ,p_consolidation_set OUT NOCOPY VARCHAR2);
48
49 PROCEDURE RANGE_CODE (p_payroll_action_id IN NUMBER
50 ,p_sql OUT NOCOPY VARCHAR2) ;
51
52 PROCEDURE ASSIGNMENT_ACTION_CODE (p_payroll_action_id IN NUMBER
53 ,p_start_person IN NUMBER
54 ,p_end_person IN NUMBER
55 ,p_chunk IN NUMBER);
56
57 PROCEDURE INITIALIZATION_CODE(p_payroll_action_id IN NUMBER);
58
59 PROCEDURE SETUP_ELEMENT_DEFINITIONS( p_classification_name IN VARCHAR2
60 ,p_element_name IN VARCHAR2
61 ,p_element_type_id IN NUMBER
62 ,p_input_value_id IN NUMBER
63 ,p_element_type IN VARCHAR2
64 ,p_uom IN VARCHAR2
65 ,p_archive_flag IN VARCHAR2);
66
67 PROCEDURE SETUP_BALANCE_DEFINITIONS(p_balance_name IN VARCHAR2
68 ,p_defined_balance_id IN NUMBER
69 ,p_balance_type_id IN NUMBER);
70
71 FUNCTION GET_COUNTRY_NAME(p_territory_code VARCHAR2) RETURN VARCHAR2;
72
73 PROCEDURE ARCHIVE_EMPLOYEE_DETAILS (p_archive_assact_id IN NUMBER
74 ,p_assignment_id IN NUMBER
75 ,p_assignment_action_id IN NUMBER
76 ,p_payroll_action_id IN NUMBER
77 ,p_time_period_id IN NUMBER
78 ,p_date_earned IN DATE
79 ,p_pay_date_earned IN DATE
80 ,p_effective_date IN DATE);
81
82 PROCEDURE ARCHIVE_ELEMENT_INFO( p_payroll_action_id IN NUMBER
83 ,p_effective_date IN DATE
84 ,p_date_earned IN DATE
85 ,p_pre_payact_id IN NUMBER);
86
87 /* Bug No : 7648285 */
88 PROCEDURE ARCHIVE_MAIN_ELEMENTS(p_archive_assact_id IN NUMBER,
89 p_run_assact_id IN NUMBER,
90 p_assignment_id IN NUMBER,
91 p_payroll_action_id IN NUMBER,
92 p_effective_date IN DATE );
93
94 FUNCTION GET_DEFINED_BALANCE_ID(p_user_name IN VARCHAR2) RETURN NUMBER;
95
96 PROCEDURE ARCHIVE_PAYMENT_INFO(p_archive_assact_id IN NUMBER,
97 p_prepay_assact_id IN NUMBER,
98 p_assignment_id IN NUMBER,
99 p_date_earned IN DATE,
100 p_effective_date IN DATE);
101
102 PROCEDURE ARCHIVE_ACCRUAL_PLAN ( p_assignment_id IN NUMBER
103 ,p_date_earned IN DATE
104 ,p_effective_date IN DATE
105 ,p_archive_assact_id IN NUMBER
106 ,p_run_assignment_action_id IN NUMBER
107 ,p_period_end_date IN DATE
108 ,p_period_start_date IN DATE
109 );
110
111 PROCEDURE ARCHIVE_ADD_ELEMENT(p_archive_assact_id IN NUMBER,
112 p_assignment_action_id IN NUMBER,
113 p_assignment_id IN NUMBER,
114 p_payroll_action_id IN NUMBER,
115 p_date_earned IN DATE,
116 p_effective_date IN DATE,
117 p_pre_payact_id IN NUMBER,
118 p_archive_flag IN VARCHAR2);
119
120 PROCEDURE ARCHIVE_OTH_BALANCE(p_archive_assact_id IN NUMBER,
121 p_assignment_action_id IN NUMBER,
122 p_assignment_id IN NUMBER,
123 p_payroll_action_id IN NUMBER,
124 p_record_count IN NUMBER,
125 p_pre_payact_id IN NUMBER,
126 p_effective_date IN DATE,
127 p_date_earned IN DATE,
128 p_archive_flag IN VARCHAR2);
129
130
131 PROCEDURE ARCHIVE_CODE(p_assignment_action_id IN NUMBER
132 ,p_effective_date IN DATE);
133
134
135 END PAY_SA_ARCHIVE;