DBA Data[Home] [Help]

APPS.HRDPP_CREATE_USER_COLUMN dependencies on HR_DATA_PUMP

Line 65: hr_data_pump.entry('ins_user_key');

61: p_user_key_value in varchar2,
62: p_unique_key_id in number)
63: is
64: begin
65: hr_data_pump.entry('ins_user_key');
66: insert into hr_pump_batch_line_user_keys
67: (user_key_id, batch_line_id,user_key_value,unique_key_id)
68: values
69: (hr_pump_batch_line_user_keys_s.nextval,

Line 73: hr_data_pump.exit('ins_user_key');

69: (hr_pump_batch_line_user_keys_s.nextval,
70: p_batch_line_id,
71: p_user_key_value,
72: p_unique_key_id);
73: hr_data_pump.exit('ins_user_key');
74: end iuk;
75: --
76: procedure insert_batch_lines
77: (p_batch_id in number

Line 145: hr_data_pump.entry('call');

141: L_USER_TABLE_ID number;
142: L_FORMULA_ID number;
143: --
144: begin
145: hr_data_pump.entry('call');
146: open cr;
147: fetch cr into c;
148: if cr%notfound then
149: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');

Line 173: hr_data_pump.api_trc_on;

169: (P_FORMULA_NAME => c.p6
170: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
171: end if;
172: --
173: hr_data_pump.api_trc_on;
174: PAY_USER_COLUMN_API.CREATE_USER_COLUMN
175: (p_validate => l_validate
176: ,p_business_group_id => p_business_group_id
177: ,P_LEGISLATION_CODE => c.p1

Line 183: hr_data_pump.api_trc_off;

179: ,P_FORMULA_ID => L_FORMULA_ID
180: ,P_USER_COLUMN_NAME => c.p2
181: ,P_USER_COLUMN_ID => L_USER_COLUMN_ID
182: ,P_OBJECT_VERSION_NUMBER => c.p4);
183: hr_data_pump.api_trc_off;
184: --
185: iuk(p_batch_line_id,c.p3,L_USER_COLUMN_ID);
186: --
187: update hr_pump_batch_lines l set

Line 194: hr_data_pump.exit('call');

190: where l.rowid = c.myrowid;
191: --
192: close cr;
193: --
194: hr_data_pump.exit('call');
195: exception
196: when hr_multi_message.error_message_exist then
197: if cr%isopen then
198: close cr;