1 PACKAGE PAY_SE_PAYSLIP_ARCHIVE AUTHID CURRENT_USER AS
2 /* $Header: pysepysa.pkh 120.0.12010000.1 2008/07/27 23:38:05 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_input_value_id IN NUMBER
30 ,p_element_type IN VARCHAR2
31 ,p_uom IN VARCHAR2
32 --,p_element_code 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
39 FUNCTION GET_COUNTRY_NAME(p_territory_code VARCHAR2) RETURN VARCHAR2;
40
41 PROCEDURE ARCHIVE_EMPLOYEE_DETAILS (p_archive_assact_id IN NUMBER
42 ,p_assignment_id IN NUMBER
43 ,p_assignment_action_id IN NUMBER
44 ,p_payroll_action_id IN NUMBER
45 ,p_time_period_id IN NUMBER
46 ,p_date_earned IN DATE
47 ,p_pay_date_earned IN DATE
48 ,p_effective_date IN DATE);
49
50 PROCEDURE ARCHIVE_ELEMENT_INFO( p_payroll_action_id IN NUMBER
51 ,p_effective_date IN DATE
52 ,p_date_earned IN DATE
53 ,p_pre_payact_id IN NUMBER);
54
55 FUNCTION GET_DEFINED_BALANCE_ID(p_user_name IN VARCHAR2) RETURN NUMBER;
56
57 PROCEDURE ARCHIVE_PAYMENT_INFO(p_archive_assact_id IN NUMBER,
58 p_prepay_assact_id IN NUMBER,
59 p_assignment_id IN NUMBER,
60 p_date_earned IN DATE,
61 p_effective_date IN DATE);
62
63 /*PROCEDURE ARCHIVE_ACCRUAL_PLAN ( p_assignment_id IN NUMBER
64 ,p_date_earned IN DATE
65 ,p_effective_date IN DATE
66 ,p_archive_assact_id IN NUMBER
67 ,p_run_assignment_action_id IN NUMBER
68 ,p_period_end_date IN DATE
69 ,p_period_start_date IN DATE
70 );*/
71
72 PROCEDURE ARCHIVE_ADD_ELEMENT(p_archive_assact_id IN NUMBER,
73 p_assignment_action_id IN NUMBER,
74 p_assignment_id IN NUMBER,
75 p_payroll_action_id IN NUMBER,
76 p_date_earned IN DATE,
77 p_effective_date IN DATE,
78 p_pre_payact_id IN NUMBER,
79 p_archive_flag IN VARCHAR2);
80
81 PROCEDURE ARCHIVE_OTH_BALANCE(p_archive_assact_id IN NUMBER,
82 p_assignment_action_id IN NUMBER,
83 p_assignment_id IN NUMBER,
84 p_payroll_action_id IN NUMBER,
85 p_record_count IN NUMBER,
86 p_pre_payact_id IN NUMBER,
87 p_effective_date IN DATE,
88 p_date_earned IN DATE,
89 p_archive_flag IN VARCHAR2);
90
91
92 PROCEDURE ARCHIVE_CODE(p_assignment_action_id IN NUMBER
93 ,p_effective_date IN DATE);
94
95 PROCEDURE DEINITIALIZATION_CODE
96 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
97
98 END PAY_SE_PAYSLIP_ARCHIVE;