DBA Data[Home] [Help]

APPS.HRDPP_UPDATE_USER_ACCT dependencies on HR_DATA_PUMP

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

42: p_user_key_value in varchar2,
43: p_unique_key_id in number)
44: is
45: begin
46: hr_data_pump.entry('ins_user_key');
47: insert into hr_pump_batch_line_user_keys
48: (user_key_id, batch_line_id,user_key_value,unique_key_id)
49: values
50: (hr_pump_batch_line_user_keys_s.nextval,

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

50: (hr_pump_batch_line_user_keys_s.nextval,
51: p_batch_line_id,
52: p_user_key_value,
53: p_unique_key_id);
54: hr_data_pump.exit('ins_user_key');
55: end iuk;
56: --
57: procedure insert_batch_lines
58: (p_batch_id in number

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

177: l_validate boolean := false;
178: L_PERSON_ID number;
179: --
180: begin
181: hr_data_pump.entry('call');
182: open cr;
183: fetch cr into c;
184: if cr%notfound then
185: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');

Line 199: hr_data_pump.api_trc_on;

195: L_PERSON_ID :=
196: hr_pump_get.GET_PERSON_ID(c.p14);
197: end if;
198: --
199: hr_data_pump.api_trc_on;
200: HR_USER_ACCT_API.UPDATE_USER_ACCT
201: (l_validate
202: ,L_PERSON_ID
203: ,c.p1

Line 217: hr_data_pump.api_trc_off;

213: ,c.p10
214: ,c.p11
215: ,c.p12
216: ,c.p13);
217: hr_data_pump.api_trc_off;
218:
219: --
220:
221: --

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

220:
221: --
222: close cr;
223: --
224: hr_data_pump.exit('call');
225: exception
226: when hr_multi_message.error_message_exist then
227: if cr%isopen then
228: close cr;