1 PACKAGE pay_se_trna_archive AS
2 /* $Header: pysetrna.pkh 120.0.12000000.1 2007/07/22 06:07:37 psingla noship $ */
3 /* ############################################################# */
4 -- For Archive
5 FUNCTION get_parameter (
6 p_parameter_string IN VARCHAR2,
7 p_token IN VARCHAR2,
8 p_segment_number IN NUMBER DEFAULT NULL
9 )
10 RETURN VARCHAR2;
11
12 PROCEDURE get_all_parameters (
13 p_payroll_action_id IN NUMBER -- In parameter
14 ,
15 p_business_group_id OUT NOCOPY NUMBER -- Core parameter
16 ,
17 p_effective_date OUT NOCOPY DATE -- Core parameter
18 ,
19 p_legal_employer_id OUT NOCOPY NUMBER -- User parameter
20 ,
21 p_request_for_all_or_not OUT NOCOPY VARCHAR2, -- User parameter
22 p_div_code OUT NOCOPY VARCHAR2 -- User parameter
23 ,
24 p_request_for_div OUT NOCOPY VARCHAR2 -- User parameter
25 ,
26 p_agreement_area OUT NOCOPY VARCHAR2 -- User parameter
27 ,
28 p_request_for_agreement OUT NOCOPY VARCHAR2, -- User parameter
29 p_report_date out nocopy varchar2,
30 p_precedence_end_date OUT NOCOPY DATE,
31 p_start_date_of_birth OUT NOCOPY DATE,
32 p_end_date_of_birth OUT NOCOPY DATE,
33 p_emp_catg OUT NOCOPY VARCHAR2 -- User parameter
34 ,
35 p_asg_catg OUT NOCOPY VARCHAR2 -- User parameter
36 ,
37 p_emp_sec OUT NOCOPY VARCHAR2,
38 p_sort_order out nocopy varchar2,
39 p_start_date OUT NOCOPY DATE -- User parameter
40 ,
41 p_end_date OUT NOCOPY DATE
42 );
43
44 PROCEDURE range_code (
45 p_payroll_action_id IN NUMBER,
46 p_sql OUT NOCOPY VARCHAR2
47 );
48
49 PROCEDURE assignment_action_code (
50 p_payroll_action_id IN NUMBER,
51 p_start_person IN NUMBER,
52 p_end_person IN NUMBER,
53 p_chunk IN NUMBER
54 );
55
56 PROCEDURE initialization_code (
57 p_payroll_action_id IN NUMBER
58 );
59
60 PROCEDURE archive_code (
61 p_assignment_action_id IN NUMBER,
62 p_effective_date IN DATE
63 );
64 END pay_se_trna_archive;