DBA Data[Home] [Help]

APPS.HRDPP_CREATE_PLAN_TYPE 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 358: hr_data_pump.entry('call');

354: c cr%rowtype;
355: l_validate boolean := false;
356: --
357: begin
358: hr_data_pump.entry('call');
359: open cr;
360: fetch cr into c;
361: if cr%notfound then
362: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');

Line 369: hr_data_pump.api_trc_on;

365: hr_utility.set_message_token('VALUE',p_batch_line_id);
366: hr_utility.raise_error;
367: end if;
368: --
369: hr_data_pump.api_trc_on;
370: ben_plan_type_api.CREATE_PLAN_TYPE
371: (p_validate => l_validate
372: ,P_PL_TYP_ID => c.p1
373: ,P_EFFECTIVE_START_DATE => c.p2

Line 423: hr_data_pump.api_trc_off;

419: ,P_SHORT_NAME => c.p47
420: ,P_SHORT_CODE => c.p48
421: ,P_LEGISLATION_CODE => c.p49
422: ,P_LEGISLATION_SUBGROUP => c.p50);
423: hr_data_pump.api_trc_off;
424:
425: --
426: update hr_pump_batch_lines l set
427: l.pval001 = decode(c.p1,null,cn,c.p1),

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

431: where l.rowid = c.myrowid;
432: --
433: close cr;
434: --
435: hr_data_pump.exit('call');
436: exception
437: when hr_multi_message.error_message_exist then
438: if cr%isopen then
439: close cr;