1 PACKAGE PAY_SA_ARCHIVE AS
2 /* $Header: pysaparc.pkh 120.0.12000000.1 2007/01/18 01:14:40 appldev noship $ */
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 FUNCTION GET_DEFINED_BALANCE_ID(p_user_name IN VARCHAR2) RETURN NUMBER;
88
89 PROCEDURE ARCHIVE_PAYMENT_INFO(p_archive_assact_id IN NUMBER,
90 p_prepay_assact_id IN NUMBER,
91 p_assignment_id IN NUMBER,
92 p_date_earned IN DATE,
93 p_effective_date IN DATE);
94
95 PROCEDURE ARCHIVE_ACCRUAL_PLAN ( p_assignment_id IN NUMBER
96 ,p_date_earned IN DATE
97 ,p_effective_date IN DATE
98 ,p_archive_assact_id IN NUMBER
99 ,p_run_assignment_action_id IN NUMBER
100 ,p_period_end_date IN DATE
101 ,p_period_start_date IN DATE
102 );
103
104 PROCEDURE ARCHIVE_ADD_ELEMENT(p_archive_assact_id IN NUMBER,
105 p_assignment_action_id IN NUMBER,
106 p_assignment_id IN NUMBER,
107 p_payroll_action_id IN NUMBER,
108 p_date_earned IN DATE,
109 p_effective_date IN DATE,
110 p_pre_payact_id IN NUMBER,
111 p_archive_flag IN VARCHAR2);
112
113 PROCEDURE ARCHIVE_OTH_BALANCE(p_archive_assact_id IN NUMBER,
114 p_assignment_action_id IN NUMBER,
115 p_assignment_id IN NUMBER,
116 p_payroll_action_id IN NUMBER,
117 p_record_count IN NUMBER,
118 p_pre_payact_id IN NUMBER,
119 p_effective_date IN DATE,
120 p_date_earned IN DATE,
121 p_archive_flag IN VARCHAR2);
122
123
124 PROCEDURE ARCHIVE_CODE(p_assignment_action_id IN NUMBER
125 ,p_effective_date IN DATE);
126
127
128 END PAY_SA_ARCHIVE;