PACKAGE: APPS.PAY_GB_RTI_FPS

Source

1 PACKAGE PAY_GB_RTI_FPS AUTHID CURRENT_USER AS
2   /* $Header: pygbrtifps.pkh 120.1.12020000.1 2012/07/11 07:44:16 appldev noship $ */
3   /*===========================================================================+
4   |               Copyright (c) 1993 Oracle Corporation                       |
5   |                  Redwood Shores, California, USA                          |
6   |                       All rights reserved.                                |
7   +============================================================================
8   Name:
9   PAY_GB_RTI_FPS
10   Purpose:
11   It fetches the live data and archives it for RTI FPS Process.
12   This is a UK Specific payroll package.
13   History:
14   21-Oct-2011  krreddy     115.0  13076448  Created.
15    8-May-2012  krreddy     115.1  13076448  Corrected the GSCC Errors.
16   =============================================================================*/
17   --
18   --
19   -- This table will be used as a transit variable to pass information column values to
20   -- archive api
21 TYPE act_info_rec
22 IS
23   RECORD
24   (
25     assignment_id NUMBER(20) ,
26     person_id     NUMBER(20) ,
27     effective_date DATE ,
28     action_info_category VARCHAR2(50) ,
29     act_info1            VARCHAR2(300) ,
30     act_info2            VARCHAR2(300) ,
31     act_info3            VARCHAR2(300) ,
32     act_info4            VARCHAR2(300) ,
33     act_info5            VARCHAR2(300) ,
34     act_info6            VARCHAR2(300) ,
35     act_info7            VARCHAR2(300) ,
36     act_info8            VARCHAR2(300) ,
37     act_info9            VARCHAR2(300) ,
38     act_info10           VARCHAR2(300) ,
39     act_info11           VARCHAR2(300) ,
40     act_info12           VARCHAR2(300) ,
41     act_info13           VARCHAR2(300) ,
42     act_info14           VARCHAR2(300) ,
43     act_info15           VARCHAR2(300) ,
44     act_info16           VARCHAR2(300) ,
45     act_info17           VARCHAR2(300) ,
46     act_info18           VARCHAR2(300) ,
47     act_info19           VARCHAR2(300) ,
48     act_info20           VARCHAR2(300) ,
49     act_info21           VARCHAR2(300) ,
50     act_info22           VARCHAR2(300) ,
51     act_info23           VARCHAR2(300) ,
52     act_info24           VARCHAR2(300) ,
53     act_info25           VARCHAR2(300) ,
54     act_info26           VARCHAR2(300) ,
55     act_info27           VARCHAR2(300) ,
56     act_info28           VARCHAR2(300) ,
57     act_info29           VARCHAR2(300) ,
58     act_info30           VARCHAR2(300) );
59 
60 TYPE action_info_table
61 IS
62   TABLE OF act_info_rec INDEX BY BINARY_INTEGER;
63 
64 type t_fps_bal_det_rec
65 IS
66   record
67   (
68     balance_name         VARCHAR2(100),
69     balance_type_id      NUMBER,
70     database_item_suffix VARCHAR2(100),
71     balance_dimension_id NUMBER,
72     defined_balance_id pay_defined_balances.defined_balance_id%type,
73     balance_value NUMBER);
74 
75 type t_fps_bal_det_tab
76 IS
77   TABLE OF t_fps_bal_det_rec INDEX BY binary_integer;
78 
79 type t_fps_ni_rec
80 IS
81   record
82   (
83     balance_name         VARCHAR2(100),
84     database_item_suffix VARCHAR2(100),
85     balance_value        NUMBER);
86 
87 type t_fps_ni_rec_tab
88 IS
89   TABLE OF t_fps_ni_rec INDEX BY binary_integer;
90 
91 PROCEDURE range_cursor(
92     pactid IN NUMBER,
93     sqlstr OUT NOCOPY VARCHAR2);
94 
95 PROCEDURE rti_fps_action_creation(
96     pactid    IN NUMBER,
97     stperson  IN NUMBER,
98     endperson IN NUMBER,
99     chunk     IN NUMBER);
100 
101 PROCEDURE archinit(
102     p_payroll_action_id IN NUMBER);
103 
104 PROCEDURE archive_code(
105     p_assactid       IN NUMBER,
106     p_effective_date IN DATE);
107 
108 PROCEDURE deinitialization_code(
109     pactid IN NUMBER);
110 
111 END PAY_GB_RTI_FPS;