PACKAGE: APPS.PAY_GB_RTI_FPS_OUTPUT

Source

1 PACKAGE PAY_GB_RTI_FPS_OUTPUT AUTHID CURRENT_USER as
2 /* $Header: pygbrtifpsop.pkh 120.0.12020000.1 2013/03/09 07:09:49 ssanjays noship $ */
3 /*===========================================================================+
4 |               Copyright (c) 2012 Oracle Corporation                       |
5 |                  Redwood Shores, California, USA                          |
6 |                       All rights reserved.                                |
7 +============================================================================
8  Name:
9     PAY_GB_RTI_FPS_OUTPUT
10   Purpose:
11     It fetches the archived data for RTI FPS 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   05-Apr-2012  rajganga     115.0     13918120     Created.
17 =============================================================================*/
18 --
19 --
20 CURSOR fps_header IS
21 
22 select 'PAYROLL_ACTION_ID=P',
23 pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
24 from dual;
25 
26 CURSOR fps_employee IS
27 select
28         'ASSIGNMENT_ACTION_ID=C',
29         paa.assignment_action_id,
30         'ASSIGNMENT_ID=C',
31         paa.assignment_id,
32         'TRANSFER_ACT_ID=P',
33         paa.assignment_action_id
34 from  pay_assignment_actions paa
35 where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
36 
37 CURSOR fps_asg_actions IS
38 select
39         'TRANSFER_ACT_ID=P',
40         pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
41 from dual;
42 --
43 
44 level_cnt   number;
45 --
46 PROCEDURE range_cursor (pactid IN NUMBER,
47                         sqlstr OUT NOCOPY VARCHAR2);
48 --
49 
50 g_archive_type varchar2(20);
51 
52 PROCEDURE action_creation    (pactid      in number,
53                                     stperson    in number,
54                                     endperson   in number,
55                                     chunk       in number);
56 
57 PROCEDURE fps_header_proc;
58 
59 PROCEDURE fps_employee_proc;
60 
61 PROCEDURE end_of_file;
62 
63 END PAY_GB_RTI_FPS_OUTPUT;