1 PACKAGE PAY_NO_ARC_RSEA_07 AUTHID CURRENT_USER AS
2 /* $Header: pynorse7.pkh 120.1.12020000.2 2013/02/27 05:50:08 smeduri ship $ */
3 --
4 -- -----------------------------------------------------------------------------
5 -- GET PARAMETER
6 -- -----------------------------------------------------------------------------
7 FUNCTION GET_PARAMETER(
8 p_parameter_string IN VARCHAR2
9 ,p_token IN VARCHAR2
10 ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2;
11 -- -----------------------------------------------------------------------------
12 -- GET ALL PARAMETERS
13 -- -----------------------------------------------------------------------------
14 PROCEDURE GET_ALL_PARAMETERS(p_payroll_action_id IN NUMBER
15 ,p_business_group_id OUT NOCOPY NUMBER
16 ,p_legal_employer_id OUT NOCOPY NUMBER
17 ,p_local_unit_id OUT NOCOPY NUMBER
18 ,p_effective_date OUT NOCOPY DATE
19 ,p_archive OUT NOCOPY VARCHAR2
20 ,p_report_type out NOCOPY VARCHAR2 -- Bug#9579261 fix
21 ,p_employee_id out NOCOPY NUMBER); -- 14260836
22 -- -----------------------------------------------------------------------------
23 -- RANGE CODE
24 -- -----------------------------------------------------------------------------
25 PROCEDURE RANGE_CODE(p_payroll_action_id IN NUMBER
26 ,p_sql OUT NOCOPY VARCHAR2);
27 -- -----------------------------------------------------------------------------
28 -- ASSIGNMENT ACTION CODE
29 -- -----------------------------------------------------------------------------
30 PROCEDURE ASSG_ACTION_CODE
31 (p_payroll_action_id IN NUMBER
32 ,p_start_person IN NUMBER
33 ,p_end_person IN NUMBER
34 ,p_chunk IN NUMBER);
35 -- -----------------------------------------------------------------------------
36 -- INITIALIZATION CODE
37 -- -----------------------------------------------------------------------------
38 PROCEDURE INIT_CODE(p_payroll_action_id IN NUMBER);
39 -- -----------------------------------------------------------------------------
40 -- ARCHIVE CODE
41 -- -----------------------------------------------------------------------------
42 PROCEDURE ARCHIVE_CODE(p_assignment_action_id IN NUMBER
43 ,p_effective_date IN DATE);
44 -- ------------------------------------------------------ --
45 -- GET_PDF_REP to generate the xml for pdf report (audit) --
46 -- ------------------------------------------------------ --
47 PROCEDURE get_pdf_rep
48 (p_business_group_id IN NUMBER
49 ,p_payroll_action_id IN VARCHAR2
50 ,p_template_name IN VARCHAR2
51 ,p_xml OUT NOCOPY CLOB);
52 -- ------------------------------------------------- --
53 -- GET_XML_REP to generate the standard xml extract --
54 -- ------------------------------------------------- --
55 PROCEDURE get_xml_rep
56 (p_business_group_id IN NUMBER
57 ,p_payroll_action_id IN VARCHAR2
58 ,p_template_name IN VARCHAR2
59 ,p_xml OUT NOCOPY CLOB);
60 --
61 END PAY_NO_ARC_RSEA_07;