1 PACKAGE PAY_KW_ARCHIVE AUTHID CURRENT_USER AS
2 /* $Header: pykwparc.pkh 120.0.12010000.1 2008/07/27 23:07:37 appldev ship $ */
3
4 FUNCTION GET_PARAMETER(p_parameter_string IN VARCHAR2
5 ,p_token IN VARCHAR2
6 ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2;
7
8 PROCEDURE GET_ALL_PARAMETERS(p_payroll_action_id IN NUMBER
9 ,p_business_group_id OUT NOCOPY NUMBER
10 ,p_start_date OUT NOCOPY VARCHAR2
11 ,p_end_date OUT NOCOPY VARCHAR2
12 ,p_effective_date OUT NOCOPY DATE
13 ,p_payroll_id OUT NOCOPY VARCHAR2
14 ,p_consolidation_set OUT NOCOPY VARCHAR2);
15
16 PROCEDURE RANGE_CODE (p_payroll_action_id IN NUMBER
17 ,p_sql OUT NOCOPY VARCHAR2) ;
18
19 PROCEDURE ASSIGNMENT_ACTION_CODE (p_payroll_action_id IN NUMBER
20 ,p_start_person IN NUMBER
21 ,p_end_person IN NUMBER
22 ,p_chunk IN NUMBER);
23
24 PROCEDURE INITIALIZATION_CODE(p_payroll_action_id IN NUMBER);
25
26 PROCEDURE SETUP_ELEMENT_DEFINITIONS( p_classification_name IN VARCHAR2
27 ,p_element_name IN VARCHAR2
28 ,p_element_type_id IN NUMBER
29 ,p_element_type IN VARCHAR2
30 ,p_input_value_id IN NUMBER
31 ,p_input_value IN VARCHAR2
32 ,p_uom IN VARCHAR2
33 ,p_archive_flag IN VARCHAR2);
34
35 PROCEDURE SETUP_BALANCE_DEFINITIONS(p_balance_name IN VARCHAR2
36 ,p_defined_balance_id IN NUMBER
37 ,p_balance_type_id IN NUMBER
38 ,p_uom IN VARCHAR2);
39
40 FUNCTION GET_COUNTRY_NAME(p_territory_code VARCHAR2) RETURN VARCHAR2;
41
42 PROCEDURE ARCHIVE_EMPLOYEE_DETAILS (p_archive_assact_id IN NUMBER
43 ,p_assignment_id IN NUMBER
44 ,p_assignment_action_id IN NUMBER
45 ,p_payroll_action_id IN NUMBER
46 ,p_time_period_id IN NUMBER
47 ,p_date_earned IN DATE
48 ,p_pay_date_earned IN DATE
49 ,p_effective_date IN DATE);
50
51 PROCEDURE ARCHIVE_ELEMENT_INFO( p_payroll_action_id IN NUMBER
52 ,p_effective_date IN DATE
53 ,p_date_earned IN DATE
54 ,p_pre_payact_id IN NUMBER);
55
56 FUNCTION GET_DEFINED_BALANCE_ID(p_user_name IN VARCHAR2) RETURN NUMBER;
57
58 PROCEDURE ARCHIVE_PAYMENT_INFO(p_archive_assact_id IN NUMBER,
59 p_prepay_assact_id IN NUMBER,
60 p_assignment_id IN NUMBER,
61 p_date_earned IN DATE,
62 p_effective_date IN DATE);
63
64 PROCEDURE ARCHIVE_ADD_ELEMENT(p_archive_assact_id IN NUMBER,
65 p_assignment_action_id IN NUMBER,
66 p_assignment_id IN NUMBER,
67 p_payroll_action_id IN NUMBER,
68 p_date_earned IN DATE,
69 p_effective_date IN DATE,
70 p_pre_payact_id IN NUMBER,
71 p_archive_flag IN VARCHAR2);
72
73 PROCEDURE ARCHIVE_OTH_BALANCE(p_archive_assact_id IN NUMBER,
74 p_assignment_action_id IN NUMBER,
75 p_assignment_id IN NUMBER,
76 p_payroll_action_id IN NUMBER,
77 p_record_count IN NUMBER,
78 p_pre_payact_id IN NUMBER,
79 p_effective_date IN DATE,
80 p_date_earned IN DATE,
81 p_archive_flag IN VARCHAR2);
82
83
84 PROCEDURE ARCHIVE_CODE(p_assignment_action_id IN NUMBER
85 ,p_effective_date IN DATE);
86
87
88 END PAY_KW_ARCHIVE;