1 PACKAGE PAY_BALANCES_UPLOAD_PKG AUTHID CURRENT_USER AS
2 /* $Header: pybaluld.pkh 115.4 2003/05/28 18:32:35 rthirlby noship $ */
3
4 --This procedure is used for loading data into PAY_BALANCE_CATEGORIES_F table.
5 --This procedure is called for pybalcat.lct configuration file
6 PROCEDURE PAY_BAL_CATF_LOAD_ROW
7 (p_CATEGORY_NAME IN VARCHAR2
8 ,p_EFFECTIVE_START_DATE IN VARCHAR2
9 ,p_EFFECTIVE_END_DATE IN VARCHAR2
10 ,p_LEGISLATION_CODE IN VARCHAR2
11 ,p_BUSINESS_GROUP_NAME IN VARCHAR2
12 ,p_SAVE_RUN_BALANCE_ENABLED IN VARCHAR2
13 ,p_USER_CATEGORY_NAME IN VARCHAR2
14 ,p_PBC_INFORMATION_CATEGORY IN VARCHAR2
15 ,p_PBC_INFORMATION1 IN VARCHAR2
16 ,p_PBC_INFORMATION2 IN VARCHAR2
17 ,p_PBC_INFORMATION3 IN VARCHAR2
18 ,p_PBC_INFORMATION4 IN VARCHAR2
19 ,p_PBC_INFORMATION5 IN VARCHAR2
20 ,p_PBC_INFORMATION6 IN VARCHAR2
21 ,p_PBC_INFORMATION7 IN VARCHAR2
22 ,p_PBC_INFORMATION8 IN VARCHAR2
23 ,p_PBC_INFORMATION9 IN VARCHAR2
24 ,p_PBC_INFORMATION10 IN VARCHAR2
25 ,p_PBC_INFORMATION11 IN VARCHAR2
26 ,p_PBC_INFORMATION12 IN VARCHAR2
27 ,p_PBC_INFORMATION13 IN VARCHAR2
28 ,p_PBC_INFORMATION14 IN VARCHAR2
29 ,p_PBC_INFORMATION15 IN VARCHAR2
30 ,p_PBC_INFORMATION16 IN VARCHAR2
31 ,p_PBC_INFORMATION17 IN VARCHAR2
32 ,p_PBC_INFORMATION18 IN VARCHAR2
33 ,p_PBC_INFORMATION19 IN VARCHAR2
34 ,p_PBC_INFORMATION20 IN VARCHAR2
35 ,p_PBC_INFORMATION21 IN VARCHAR2
36 ,p_PBC_INFORMATION22 IN VARCHAR2
37 ,p_PBC_INFORMATION23 IN VARCHAR2
38 ,p_PBC_INFORMATION24 IN VARCHAR2
39 ,p_PBC_INFORMATION25 IN VARCHAR2
40 ,p_PBC_INFORMATION26 IN VARCHAR2
41 ,p_PBC_INFORMATION27 IN VARCHAR2
42 ,p_PBC_INFORMATION28 IN VARCHAR2
43 ,p_PBC_INFORMATION29 IN VARCHAR2
44 ,p_PBC_INFORMATION30 IN VARCHAR2
45 ,p_OVN IN VARCHAR2
46 ,p_OWNER IN VARCHAR2
47 );
48
49 --This procedure is used for loading data into PAY_BALANCE_TYPES table.
50 --This procedure is called for pybalcat.lct configuration file
51 PROCEDURE PAY_BAL_TYPES_LOAD_ROW
52 (p_CATEGORY_NAME IN VARCHAR2
53 ,p_EFFECTIVE_START_DATE IN VARCHAR2
54 ,p_EFFECTIVE_END_DATE IN VARCHAR2
55 ,p_LEGISLATION_CODE IN VARCHAR2
56 ,p_BALANCE_NAME IN VARCHAR2
57 ,p_BUSINESS_GROUP_NAME IN VARCHAR2
58 ,p_OWNER IN VARCHAR2
59 );
60
61 --This procedure is used for loading data into PAY_BAL_ATTRIBUTE_DEFINITIONS table.
62 --This procedure is called for pybalade.lct configuration file
63 PROCEDURE PAY_BAL_ADE_LOAD_ROW
64 (p_ATTRIBUTE_NAME IN VARCHAR2
65 ,p_LEGISLATION_CODE IN VARCHAR2
66 ,p_BUSINESS_GROUP_NAME IN VARCHAR2
67 ,p_ALTERABLE IN VARCHAR2
68 ,p_user_attribute_name IN VARCHAR2
69 ,p_OWNER IN VARCHAR2
70 );
71
72 --This procedure is used for loading data into PAY_BALANCE_ATTRIBUTES table.
73 --This procedure is called for pybalatt.lct configuration file
74 PROCEDURE PAY_BAL_ATT_LOAD_ROW
75 (p_ATTRIBUTE_NAME IN VARCHAR2
76 ,p_ATTR_DEFN_LEG_CODE IN VARCHAR2
77 ,p_LEGISLATION_CODE IN VARCHAR2
78 ,p_BALANCE_NAME IN VARCHAR2
79 ,p_BAL_LEG_CODE IN VARCHAR2
80 ,p_DIMENSION_NAME IN VARCHAR2
81 ,p_DIM_LEG_CODE IN VARCHAR2
82 ,p_BUSINESS_GROUP_NAME IN VARCHAR2
83 ,p_ATTR_DEFN_BUS_GROUP_NAME IN VARCHAR2
84 ,p_BAL_BUS_GROUP_NAME IN VARCHAR2
85 ,p_DIM_BUS_GROUP_NAME IN VARCHAR2
86 ,p_OWNER IN VARCHAR2
87 );
88
89 --This procedure is used for loading data into PAY_BAL_ATTRIBUTE_DEFAULTS table.
90 --This procedure is called for pybaladf.lct configuration file
91 PROCEDURE PAY_BAL_ADF_LOAD_ROW
92 (p_CATEGORY_NAME IN VARCHAR2
93 ,p_EFFECTIVE_START_DATE IN VARCHAR2
94 ,p_EFFECTIVE_END_DATE IN VARCHAR2
95 ,p_CAT_LEG_CODE IN VARCHAR2
96 ,p_LEGISLATION_CODE IN VARCHAR2
97 ,p_DIMENSION_NAME IN VARCHAR2
98 ,p_DIM_LEG_CODE IN VARCHAR2
99 ,p_ATTRIBUTE_NAME IN VARCHAR2
100 ,p_ATTR_LEG_CODE IN VARCHAR2
101 ,p_BUSINESS_GROUP_NAME IN VARCHAR2
102 ,p_CAT_BUS_GROUP_NAME IN VARCHAR2
103 ,p_DIM_BUS_GROUP_NAME IN VARCHAR2
104 ,p_ATTR_BUS_GROUP_NAME IN VARCHAR2
105 ,p_OWNER IN VARCHAR2
106 );
107 --
108 -- This procedure provides NLS support for pay_balance_categories_f
109 --
110 procedure translate_row_cat
111 (p_category_name in varchar2
112 ,p_user_category_name in varchar2
113 ,p_legislation_code in varchar2
114 ,p_bg_name in varchar2
115 ,p_owner in varchar2
116 );
117 --
118 -- This procedure provides NLS support for pay_bal_attribute_definitions
119 --
120 procedure translate_row_attrib
121 (p_attribute_name in varchar2
122 ,p_user_attribute_name in varchar2
123 ,p_legislation_code in varchar2
124 ,p_bg_name in varchar2
125 ,p_owner in varchar2
126 );
127 --
128 END PAY_BALANCES_UPLOAD_PKG;