DBA Data[Home] [Help]

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

392: L_PERSON_ID number;
393: L_ORGANIZATION_ID number;
394: --
395: begin
396: hr_data_pump.entry('call');
397: open cr;
398: fetch cr into c;
399: if cr%notfound then
400: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');

Line 447: hr_data_pump.api_trc_on;

443: ,P_EFFECTIVE_DATE => c.p1
444: ,P_LANGUAGE_CODE => c.p56);
445: end if;
446: --
447: hr_data_pump.api_trc_on;
448: PER_SUPPLEMENTARY_ROLE_API.CREATE_SUPPLEMENTARY_ROLE
449: (p_validate => l_validate
450: ,P_EFFECTIVE_DATE => c.p1
451: ,P_JOB_ID => L_JOB_ID

Line 505: hr_data_pump.api_trc_off;

501: ,P_ROLE_INFORMATION19 => c.p48
502: ,P_ROLE_INFORMATION20 => c.p49
503: ,P_ROLE_ID => L_ROLE_ID
504: ,P_OBJECT_VERSION_NUMBER => c.p51);
505: hr_data_pump.api_trc_off;
506: --
507: iuk(p_batch_line_id,c.p50,L_ROLE_ID);
508: --
509: update hr_pump_batch_lines l set

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

512: where l.rowid = c.myrowid;
513: --
514: close cr;
515: --
516: hr_data_pump.exit('call');
517: exception
518: when hr_multi_message.error_message_exist then
519: if cr%isopen then
520: close cr;