PACKAGE: APPS.PAY_FI_ARCHIVE_PSTA

Source

1 PACKAGE PAY_FI_ARCHIVE_PSTA  AUTHID CURRENT_USER 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;