1 PACKAGE PAY_NL_PAYSLIP_ARCHIVE AUTHID CURRENT_USER as
2 /* $Header: pynlparc.pkh 120.0.12000000.1 2007/01/17 22:59:29 appldev noship $ */
3
4 /*-------------------------------------------------------------------------------
5 |Name : RANGE_CODE |
6 |Type : Procedure |
7 |Description : This procedure returns a sql string to select a range of |
8 | assignments eligible for archival |
9 -------------------------------------------------------------------------------*/
10
11 Procedure RANGE_CODE (pactid IN NUMBER
12 ,sqlstr OUT NOCOPY VARCHAR2);
13
14
15 /*-------------------------------------------------------------------------------
16 |Name : ASSIGNMENT_ACTION_CODE |
17 |Type : Procedure |
18 |Description : This procedure further restricts the assignment id's returned |
19 | by the range code. It locks all the completed Prepayments/ |
20 | Quickpay Prepayments in the specified period |
21 -------------------------------------------------------------------------------*/
22
23 Procedure ASSIGNMENT_ACTION_CODE (p_payroll_action_id in number
24 ,p_start_person_id in number
25 ,p_end_person_id in number
26 ,p_chunk in number);
27
28
29 /*-------------------------------------------------------------------------------
30 |Name : ARCHIVE_INIT |
31 |Type : Procedure |
32 |Description : Procedure sets the global tables g_statutory_balance_table, |
33 | g_stat_element_table,g_user_balance_table,g_element_table. |
34 -------------------------------------------------------------------------------*/
35
36 Procedure ARCHIVE_INIT(p_payroll_action_id IN NUMBER);
37
38 /*-------------------------------------------------------------------------------
39 |Name : ARCHIVE_CODE |
40 |Type : Procedure |
41 |Description : This is the main procedure which calls the several procedures |
42 | to archive the data. |
43 -------------------------------------------------------------------------------*/
44
45 Procedure ARCHIVE_CODE (p_assignment_action_id IN NUMBER
46 ,p_effective_date IN DATE);
47
48
49
50 /*-------------------------------------------------------------------------------
51 |Name : GET_PARAMETER |
52 |Type : Function |
53 |Description : Funtion to get the parameters of the archive process |
54 -------------------------------------------------------------------------------*/
55
56 Function get_parameter(
57 p_parameter_string in varchar2
58 ,p_token in varchar2
59 ,p_segment_number in number default null )RETURN varchar2;
60
61 /*-------------------------------------------------------------------------------
62 |Name : GET_ALL_PARAMETERS |
63 |Type : Procedure |
64 |Description : Procedure which returns all the parameters of the archive |
65 | process |
66 -------------------------------------------------------------------------------*/
67 PROCEDURE get_all_parameters(
68 p_payroll_action_id IN NUMBER
69 ,p_business_group_id OUT NOCOPY NUMBER
70 ,p_start_date OUT NOCOPY VARCHAR2
71 ,p_end_date OUT NOCOPY VARCHAR2
72 ,p_effective_date OUT NOCOPY DATE
73 ,p_payroll_id OUT NOCOPY VARCHAR2
74 ,p_consolidation_set OUT NOCOPY VARCHAR2);
75 /*-------------------------------------------------------------------------------
76 |Name : get_country_name |
77 |Type : Function |
78 |Description : Function to get the country name from FND_TERRITORIES_VL |
79 -------------------------------------------------------------------------------*/
80
81 FUNCTION get_country_name(p_territory_code VARCHAR2) RETURN VARCHAR2;
82
83 END PAY_NL_PAYSLIP_ARCHIVE;