PACKAGE: APPS.PAY_GB_RTI_EYU

Source

1 PACKAGE PAY_GB_RTI_EYU AUTHID CURRENT_USER as
2   /* $Header: pygbrtieyu.pkh 120.0.12020000.3 2013/03/09 06:48:49 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_EYU
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   4-Feb-2013  rajganga     115.0    Created.
15   4-Feb-2013  rajganga     115.1    Created.
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 PROCEDURE range_cursor(
80     pactid IN NUMBER,
81     sqlstr OUT NOCOPY VARCHAR2);
82 
83 PROCEDURE rti_eyu_action_creation(
84     pactid    IN NUMBER,
85     stperson  IN NUMBER,
86     endperson IN NUMBER,
87     chunk     IN NUMBER);
88 
89 PROCEDURE archinit(
90     p_payroll_action_id IN NUMBER);
91 
92 PROCEDURE archive_code(
93     p_assactid       IN NUMBER,
94     p_effective_date IN DATE);
95 
96 PROCEDURE deinitialization_code(
97     pactid IN NUMBER);
98 
99 function validate_input(p_input_value    varchar2,
100                         p_validate_mode  varchar2)
101 return number;
102 
103 FUNCTION date_validate (c_assignment_action_id  NUMBER,
104                         p_mode                  VARCHAR2,
105                         p_validate_date         DATE)
106 RETURN NUMBER;
107 
108 function econ_validate(econ varchar2)
109 return number;
110 
111 END PAY_GB_RTI_EYU;