PACKAGE: APPS.PAY_GB_RTI_OUTPUT

Source

1 PACKAGE PAY_GB_RTI_OUTPUT AUTHID CURRENT_USER as
2 /* $Header: pygbrtio.pkh 120.2.12020000.1 2013/03/09 07:11:02 ssanjays noship $ */
3 /*===========================================================================+
4 |               Copyright (c) 1993 Oracle Corporation                       |
5 |                  Redwood Shores, California, USA                          |
6 |                       All rights reserved.                                |
7 +============================================================================
8  Name:
9     PAY_GB_RTI_OUTPUT
10   Purpose:
11     It fetches the archived data for RTI Processes, converts it into XML format
12     and merges it with the EText file to generate the output.
13     This is a UK Specific payroll package.
14 
15   History:
16   21-Oct-2011  krreddy     115.0  13076448  Created.
17   22-Oct-2011  krreddy     115.1  13076448  Modified not equals check to <> to
18                                             resolve GSCC Error.
19   28-Oct-2011  krreddy     115.2  13076448  Removed the incorrect code.
20 =============================================================================*/
21 --
22 --
23 CURSOR eas_header IS
24 
25 select 'PAYROLL_ACTION_ID=P',
26 pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
27 from dual;
28 
29 CURSOR eas_employee IS
30 select
31         'ASSIGNMENT_ACTION_ID=C',
32         paa.assignment_action_id,
33         'ASSIGNMENT_ID=C',
34         paa.assignment_id,
35         'TRANSFER_ACT_ID=P',
36         paa.assignment_action_id
37 from  pay_assignment_actions paa
38 where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
39 
40 CURSOR eas_asg_actions IS
41 select
42         'TRANSFER_ACT_ID=P',
43         pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
44 from dual;
45 --
46 CURSOR nino_header IS
47 
48 select 'PAYROLL_ACTION_ID=P',
49 pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
50 from dual;
51 
52 CURSOR nino_employee IS
53 select
54         'ASSIGNMENT_ACTION_ID=C',
55         paa.assignment_action_id,
56         'ASSIGNMENT_ID=C',
57         paa.assignment_id,
58         'TRANSFER_ACT_ID=P',
59         paa.assignment_action_id
60 from  pay_assignment_actions paa
61 where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
62 
63 CURSOR nino_asg_actions IS
64 select
65         'TRANSFER_ACT_ID=P',
66         pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
67 from dual;
68 --
69 level_cnt   number;
70 --
71 PROCEDURE range_cursor (pactid IN NUMBER,
72                         sqlstr OUT NOCOPY VARCHAR2);
73 --
74 
75 g_archive_type varchar2(20);
76 
77 PROCEDURE action_creation    (pactid      in number,
78                                     stperson    in number,
79                                     endperson   in number,
80                                     chunk       in number);
81 
82 PROCEDURE eas_header_proc;
83 
84 PROCEDURE eas_employee_proc;
85 PROCEDURE nino_header_proc;
86 
87 PROCEDURE nino_employee_proc;
88 
89 PROCEDURE end_of_file;
90 
91 END PAY_GB_RTI_OUTPUT;