[Home] [Help]
PACKAGE: APPS.PAY_GB_RTI_FPS_ARCHIVE
Source
1 PACKAGE PAY_GB_RTI_FPS_ARCHIVE AUTHID CURRENT_USER AS
2 /* $Header: pygbrtifps13.pkh 120.0.12020000.1 2013/01/03 11:57:24 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 19-Dec-2012 rajganga 115.0 15890022 Created.
15 =============================================================================*/
16 --
17 --
18 -- This table will be used as a transit variable to pass information column values to
19 -- archive api
20 TYPE act_info_rec
21 IS
22 RECORD
23 (
24 assignment_id NUMBER(20) ,
25 person_id NUMBER(20) ,
26 effective_date DATE ,
27 action_info_category VARCHAR2(50) ,
28 act_info1 VARCHAR2(300) ,
29 act_info2 VARCHAR2(300) ,
30 act_info3 VARCHAR2(300) ,
31 act_info4 VARCHAR2(300) ,
32 act_info5 VARCHAR2(300) ,
33 act_info6 VARCHAR2(300) ,
34 act_info7 VARCHAR2(300) ,
35 act_info8 VARCHAR2(300) ,
36 act_info9 VARCHAR2(300) ,
37 act_info10 VARCHAR2(300) ,
38 act_info11 VARCHAR2(300) ,
39 act_info12 VARCHAR2(300) ,
40 act_info13 VARCHAR2(300) ,
41 act_info14 VARCHAR2(300) ,
42 act_info15 VARCHAR2(300) ,
43 act_info16 VARCHAR2(300) ,
44 act_info17 VARCHAR2(300) ,
45 act_info18 VARCHAR2(300) ,
46 act_info19 VARCHAR2(300) ,
47 act_info20 VARCHAR2(300) ,
48 act_info21 VARCHAR2(300) ,
49 act_info22 VARCHAR2(300) ,
50 act_info23 VARCHAR2(300) ,
51 act_info24 VARCHAR2(300) ,
52 act_info25 VARCHAR2(300) ,
53 act_info26 VARCHAR2(300) ,
54 act_info27 VARCHAR2(300) ,
55 act_info28 VARCHAR2(300) ,
56 act_info29 VARCHAR2(300) ,
57 act_info30 VARCHAR2(300) );
58
59 TYPE action_info_table
60 IS
61 TABLE OF act_info_rec INDEX BY BINARY_INTEGER;
62
63 type t_fps_bal_det_rec
64 IS
65 record
66 (
67 balance_name VARCHAR2(100),
68 balance_type_id NUMBER,
69 database_item_suffix VARCHAR2(100),
70 balance_dimension_id NUMBER,
71 defined_balance_id pay_defined_balances.defined_balance_id%type,
72 balance_value NUMBER);
73
74 type t_fps_bal_det_tab
75 IS
76 TABLE OF t_fps_bal_det_rec INDEX BY binary_integer;
77
78 type t_fps_ni_rec
79 IS
80 record
81 (
82 balance_name VARCHAR2(100),
83 database_item_suffix VARCHAR2(100),
84 balance_value NUMBER);
85
86 type t_fps_ni_rec_tab
87 IS
88 TABLE OF t_fps_ni_rec INDEX BY binary_integer;
89
90 PROCEDURE range_cursor(
91 pactid IN NUMBER,
92 sqlstr OUT NOCOPY VARCHAR2);
93
94 PROCEDURE rti_fps_action_creation(
95 pactid IN NUMBER,
96 stperson IN NUMBER,
97 endperson IN NUMBER,
98 chunk IN NUMBER);
99
100 PROCEDURE archinit(
101 p_payroll_action_id IN NUMBER);
102
103 PROCEDURE archive_code(
104 p_assactid IN NUMBER,
105 p_effective_date IN DATE);
106
107 PROCEDURE deinitialization_code(
108 pactid IN NUMBER);
109
110 END PAY_GB_RTI_FPS_ARCHIVE;