1 PACKAGE PAY_FI_ARCHIVE_PYSA AUTHID CURRENT_USER AS
2 /* $Header: pyfipysa.pkh 120.1.12000000.1 2007/01/17 19:29:16 appldev noship $ */
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_archive_flag IN VARCHAR2);
33
34 PROCEDURE SETUP_BALANCE_DEFINITIONS(p_balance_name IN VARCHAR2
35 ,p_defined_balance_id IN NUMBER
36 ,p_balance_type_id IN NUMBER);
37
38 FUNCTION GET_COUNTRY_NAME(p_territory_code VARCHAR2) RETURN VARCHAR2;
39
40 PROCEDURE ARCHIVE_EMPLOYEE_DETAILS (p_archive_assact_id IN NUMBER
41 ,p_assignment_id IN NUMBER
42 ,p_assignment_action_id IN NUMBER
43 ,p_payroll_action_id IN NUMBER
44 ,p_time_period_id IN NUMBER
45 ,p_date_earned IN DATE
46 ,p_pay_date_earned IN DATE
47 ,p_effective_date IN DATE);
48
49 PROCEDURE ARCHIVE_ELEMENT_INFO( p_payroll_action_id IN NUMBER
50 ,p_effective_date IN DATE
51 ,p_date_earned IN DATE
52 ,p_pre_payact_id IN NUMBER);
53
54 FUNCTION GET_DEFINED_BALANCE_ID(p_user_name IN VARCHAR2) RETURN NUMBER;
55
56 PROCEDURE ARCHIVE_PAYMENT_INFO(p_archive_assact_id IN NUMBER,
57 p_prepay_assact_id IN NUMBER,
58 p_assignment_id IN NUMBER,
59 p_date_earned IN DATE,
60 p_effective_date IN DATE);
61
62 /*PROCEDURE ARCHIVE_ACCRUAL_PLAN ( p_assignment_id IN NUMBER
63 ,p_date_earned IN DATE
64 ,p_effective_date IN DATE
65 ,p_archive_assact_id IN NUMBER
66 ,p_run_assignment_action_id IN NUMBER
67 ,p_period_end_date IN DATE
68 ,p_period_start_date IN DATE
69 );*/
70
71 PROCEDURE ARCHIVE_ADD_ELEMENT(p_archive_assact_id IN NUMBER,
72 p_assignment_action_id IN NUMBER,
73 p_assignment_id IN NUMBER,
74 p_payroll_action_id IN NUMBER,
75 p_date_earned IN DATE,
76 p_effective_date IN DATE,
77 p_pre_payact_id IN NUMBER,
78 p_archive_flag IN VARCHAR2);
79
80 PROCEDURE ARCHIVE_OTH_BALANCE(p_archive_assact_id IN NUMBER,
81 p_assignment_action_id IN NUMBER,
82 p_assignment_id IN NUMBER,
83 p_payroll_action_id IN NUMBER,
84 p_record_count IN NUMBER,
85 p_pre_payact_id IN NUMBER,
86 p_effective_date IN DATE,
87 p_date_earned IN DATE,
88 p_archive_flag IN VARCHAR2);
89
90
91 PROCEDURE ARCHIVE_CODE(p_assignment_action_id IN NUMBER
92 ,p_effective_date IN DATE);
93
94 PROCEDURE DEINITIALIZATION_CODE
95 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
96
97 END PAY_FI_ARCHIVE_PYSA;