DBA Data[Home] [Help]

PACKAGE: APPS.PAY_FI_ARCHIVE_UMFR

Source


1 PACKAGE PAY_FI_ARCHIVE_UMFR AUTHID CURRENT_USER AS
2 /* $Header: pyfiumfa.pkh 120.0 2006/01/24 03:55:49 atrivedi 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 
11    PROCEDURE get_all_parameters (
12       p_payroll_action_id   IN              NUMBER -- In parameter
13                                                   ,
14       p_business_group_id   OUT NOCOPY      NUMBER -- Core parameter
15                                                   ,
16       p_effective_date      OUT NOCOPY      DATE -- Core parameter
17                                                 ,
18       p_trade_union_id      OUT NOCOPY      NUMBER -- User parameter
19                                                   ,
20       p_legal_employer_id   OUT NOCOPY      NUMBER -- User parameter
21                                                   ,
22       p_local_unit_id       OUT NOCOPY      NUMBER -- User parameter
23                                                   ,
24       p_period              OUT NOCOPY      VARCHAR2,
25       p_period_end_date     OUT NOCOPY      DATE,
26       p_archive             OUT NOCOPY      VARCHAR2
27    );
28 
29    PROCEDURE range_code (
30       p_payroll_action_id   IN              NUMBER,
31       p_sql                 OUT NOCOPY      VARCHAR2
32    );
33 
34    PROCEDURE assignment_action_code (
35       p_payroll_action_id   IN   NUMBER,
36       p_start_person        IN   NUMBER,
37       p_end_person          IN   NUMBER,
38       p_chunk               IN   NUMBER
39    );
40 
41    PROCEDURE initialization_code (p_payroll_action_id IN NUMBER);
42 
43    FUNCTION get_country_name (p_territory_code VARCHAR2)
44       RETURN VARCHAR2;
45 
46    FUNCTION get_defined_balance_id (p_user_name IN VARCHAR2)
47       RETURN NUMBER;
48 
49    PROCEDURE archive_code (
50       p_assignment_action_id   IN   NUMBER,
51       p_effective_date         IN   DATE
52    );
53 END pay_fi_archive_umfr;