1 PACKAGE PAY_NO_K27_REIM_UPLD AUTHID CURRENT_USER AS
2 /* $Header: pynok27up.pkh 120.0.12020000.1 2012/07/24 06:23:15 appldev noship $ */
3
4 PROCEDURE create_k27_element ( p_effective_date IN DATE
5 , p_assignment_id IN NUMBER
6 , p_business_group_id IN NUMBER
7 , p_start_date IN DATE
8 , p_end_date IN DATE
9 , p_reimb_date IN DATE
10 , p_reimb_amt IN NUMBER
11 , p_municipality_number IN VARCHAR2
12 , p_code IN VARCHAR2
13 );
14
15 FUNCTION get_element_link_id
16 (
17 p_assignment_id IN NUMBER
18 ,p_business_group_id IN NUMBER
19 ,p_date IN per_all_assignments_f.effective_start_date%TYPE
20 ,p_element_name IN pay_element_types_f.ELEMENT_NAME%TYPE
21 ) RETURN NUMBER;
22
23
24 FUNCTION GET_PARAMETER
25 (p_parameter_string IN VARCHAR2
26 ,p_token IN VARCHAR2
27 ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2;
28
29 PROCEDURE GET_ALL_PARAMETERS
30 ( p_payroll_action_id IN NUMBER
31 ,p_business_group_id OUT NOCOPY NUMBER
32 ,p_legal_employer_no OUT NOCOPY VARCHAR2
33 ,p_effective_date OUT NOCOPY DATE
34 ,p_test_submission OUT NOCOPY VARCHAR2
35 ,p_filename OUT NOCOPY VARCHAR2
36 ,p_period_date OUT NOCOPY DATE);
37
38 PROCEDURE RANGE_CODE
39 (p_payroll_action_id IN NUMBER
40 ,p_sql OUT NOCOPY VARCHAR2) ;
41
42 PROCEDURE ASSIGNMENT_ACTION_CODE
43 (p_payroll_action_id IN NUMBER
44 ,p_start_person IN NUMBER
45 ,p_end_person IN NUMBER
46 ,p_chunk IN NUMBER);
47
48 PROCEDURE INITIALIZATION_CODE
49 (p_payroll_action_id IN NUMBER);
50
51 PROCEDURE ARCHIVE_CODE
52 (p_assignment_action_id IN NUMBER
53 ,p_effective_date IN DATE);
54
55 PROCEDURE DEINITIALIZATION_CODE
56 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
57
58 PROCEDURE K27_NOTIFICATION_REP
59 ( errbuf OUT NOCOPY VARCHAR2
60 , retcode OUT NOCOPY VARCHAR2
61 , p_legal_employer IN VARCHAR2
62 , p_Date_from IN VARCHAR2
63 , p_Date_to IN VARCHAR2);
64
65
66 END PAY_NO_K27_REIM_UPLD;