[Home] [Help]
PACKAGE: APPS.PAY_FI_ARCHIVE_PSTA
Source
1 PACKAGE PAY_FI_ARCHIVE_PSTA AS
2 /* $Header: pyfipsta.pkh 120.0.12000000.1 2007/04/26 12:12:47 dbehera noship $ */
3
4 FUNCTION get_parameter (
5 p_parameter_string IN VARCHAR2,
6 p_token IN VARCHAR2,
7 p_segment_number IN NUMBER DEFAULT NULL
8 )
9 RETURN VARCHAR2;
10 procedure get_all_parameters (
11 p_payroll_action_id in number,
12 p_business_group_id out nocopy number,
13 p_legal_employer_id out nocopy number,
14 p_local_unit_id out nocopy number,
15 p_year out nocopy varchar2,
16 p_payroll_type_code out nocopy varchar2,
17 p_payroll_id out nocopy varchar2,
18 p_archive out nocopy varchar2,
19 p_effective_date out nocopy date
20 ) ;
21
22 PROCEDURE range_code (
23 p_payroll_action_id IN NUMBER,
24 p_sql OUT NOCOPY VARCHAR2
25 );
26
27 PROCEDURE assignment_action_code (
28 p_payroll_action_id IN NUMBER,
29 p_start_person IN NUMBER,
30 p_end_person IN NUMBER,
31 p_chunk IN NUMBER
32 );
33
34 PROCEDURE initialization_code (p_payroll_action_id IN NUMBER);
35
36 PROCEDURE archive_code (
37 p_assignment_action_id IN NUMBER,
38 p_effective_date IN DATE
39 );
40
41 procedure archive_data (
42 p_arch_assignment_action_id in number,
43 p_assignment_action_id in number,
44 p_assignment_id in number
45 ) ;
46 procedure archive_person_address_details (
47 p_person_id number,
48 p_assignment_action_id number,
49 p_assignment_id number
50 );
51 FUNCTION GET_COUNTRY_NAME(p_territory_code VARCHAR2) RETURN VARCHAR2;
52
53 function get_balance_value (
54 p_balance_name in varchar2,
55 p_assignment_id in number,
56 p_database_item_suffix in varchar2,
57 p_bal_date in date
58 )
59 RETURN NUMBER;
60 END PAY_FI_ARCHIVE_PSTA;