1 PACKAGE PAY_NO_PAYSLIP_ARCHIVE AS
2 /* $Header: pynoparc.pkh 120.1.12000000.1 2007/05/20 09:52:32 rlingama noship $ */
3
4
5 --------------------- FUNCTION GET_PARAMETER ------------------------------------------
6
7 FUNCTION GET_PARAMETER(p_parameter_string IN VARCHAR2
8 ,p_token IN VARCHAR2
9 ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2;
10
11
12 --------------------- PROCEDURE GET_ALL_PARAMETERS ------------------------------------
13
14 PROCEDURE GET_ALL_PARAMETERS(p_payroll_action_id IN NUMBER
15 ,p_business_group_id OUT NOCOPY NUMBER
16 ,p_start_date OUT NOCOPY VARCHAR2
17 ,p_end_date OUT NOCOPY VARCHAR2
18 ,p_effective_date OUT NOCOPY DATE
19 ,p_payroll_id OUT NOCOPY VARCHAR2
20 ,p_consolidation_set OUT NOCOPY VARCHAR2);
21
22 --------------------- PROCEDURE RANGE_CODE --------------------------------------------
23
24 PROCEDURE RANGE_CODE (p_payroll_action_id IN NUMBER
25 ,p_sql OUT NOCOPY VARCHAR2) ;
26
27 --------------------- PROCEDURE ASSIGNMENT_ACTION_CODE --------------------------------
28
29 PROCEDURE ASSIGNMENT_ACTION_CODE (p_payroll_action_id IN NUMBER
30 ,p_start_person IN NUMBER
31 ,p_end_person IN NUMBER
32 ,p_chunk IN NUMBER);
33
34 --------------------- PROCEDURE INITIALIZATION_CODE ----------------------------------
35
36 PROCEDURE INITIALIZATION_CODE(p_payroll_action_id IN NUMBER);
37
38 --------------------- PROCEDURE SETUP_ELEMENT_DEFINITIONS ----------------------------
39
40 PROCEDURE SETUP_ELEMENT_DEFINITIONS( p_classification_name IN VARCHAR2
41 ,p_element_name IN VARCHAR2
42 ,p_element_type_id IN NUMBER
43 ,p_input_value_id IN NUMBER
44 ,p_element_type IN VARCHAR2
45 ,p_uom IN VARCHAR2
46 ,p_archive_flag IN VARCHAR2
47 ,p_prim_bal_def_bal_id IN NUMBER
48 ,p_lookup_type IN VARCHAR2
49 ,p_value_set_id IN NUMBER );
50
51 --------------------- PROCEDURE SETUP_BALANCE_DEFINITIONS -----------------------------
52
53 PROCEDURE SETUP_BALANCE_DEFINITIONS(p_balance_name IN VARCHAR2
54 ,p_defined_balance_id IN NUMBER
55 ,p_balance_type_id IN NUMBER);
56
57 --------------------- FUNCTION GET_COUNTRY_NAME ---------------------------------------
58
59 FUNCTION GET_COUNTRY_NAME(p_territory_code VARCHAR2) RETURN VARCHAR2;
60
61 --------------------- PROCEDURE ARCHIVE_EMPLOYEE_DETAILS -----------------------------
62
63 PROCEDURE ARCHIVE_EMPLOYEE_DETAILS (p_archive_assact_id IN NUMBER
64 ,p_assignment_id IN NUMBER
65 ,p_assignment_action_id IN NUMBER
66 ,p_payroll_action_id IN NUMBER
67 ,p_time_period_id IN NUMBER
68 ,p_date_earned IN DATE
69 ,p_pay_date_earned IN DATE
70 ,p_effective_date IN DATE);
71
72 ---------------------- PROCEDURE ARCHIVE_ELEMENT_INFO ---------------------------------
73
74 PROCEDURE ARCHIVE_ELEMENT_INFO( p_payroll_action_id IN NUMBER
75 ,p_effective_date IN DATE
76 ,p_date_earned IN DATE
77 ,p_pre_payact_id IN NUMBER);
78
79 ----------------------- FUNCTION GET_DEFINED_BALANCE_ID -------------------------------
80
81 FUNCTION GET_DEFINED_BALANCE_ID(p_user_name IN VARCHAR2) RETURN NUMBER;
82
83 ----------------------- PROCEDURE ARCHIVE_PAYMENT_INFO -------------------------------
84
85 PROCEDURE ARCHIVE_PAYMENT_INFO(p_archive_assact_id IN NUMBER,
86 p_prepay_assact_id IN NUMBER,
87 p_assignment_id IN NUMBER,
88 p_date_earned IN DATE,
89 p_effective_date IN DATE);
90
91 ------------------------ PROCEDURE ARCHIVE_ADD_ELEMENT ------------------------------
92
93 PROCEDURE ARCHIVE_ADD_ELEMENT(p_archive_assact_id IN NUMBER,
94 p_assignment_action_id IN NUMBER,
95 p_assignment_id IN NUMBER,
96 p_payroll_action_id IN NUMBER,
97 p_date_earned IN DATE,
98 p_effective_date IN DATE,
99 p_pre_payact_id IN NUMBER,
100 p_archive_flag IN VARCHAR2);
101
102 -------------------------- PROCEDURE ARCHIVE_OTH_BALANCE -----------------------------
103
104 PROCEDURE ARCHIVE_OTH_BALANCE(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_record_count IN NUMBER,
109 p_pre_payact_id IN NUMBER,
110 p_effective_date IN DATE,
111 p_date_earned IN DATE,
112 p_archive_flag IN VARCHAR2);
113
114
115 ----------------------------- PROCEDURE ARCHIVE_CODE --------------------------------
116
117 PROCEDURE ARCHIVE_CODE(p_assignment_action_id IN NUMBER
118 ,p_effective_date IN DATE);
119
120
121 ------------------------------ PROCEDURE ARCHIVE_ADDL_EMP_DETAILS ------------------
122
123 PROCEDURE ARCHIVE_ADDL_EMP_DETAILS(p_archive_assact_id IN NUMBER
124 ,p_assignment_id IN NUMBER
125 ,p_assignment_action_id IN NUMBER
126 ,p_effective_date IN DATE
127 ,p_date_earned IN DATE
128 ,p_payroll_action_id IN NUMBER ) ;
129
130
131 ------------------------------ PROCEDURE ARCHIVE_MAIN_ELEMENTS ------------------------
132
133 PROCEDURE ARCHIVE_MAIN_ELEMENTS
134 (p_archive_assact_id IN NUMBER,
135 p_assignment_action_id IN NUMBER,
136 p_assignment_id IN NUMBER,
137 p_date_earned IN DATE,
138 p_effective_date IN DATE,
139 p_payroll_action_id IN NUMBER ) ;
140
141
142 ------------------------------ End of package ---------------------------------------------
143
144 END PAY_NO_PAYSLIP_ARCHIVE ;