DBA Data[Home] [Help]

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

466: L_QUALIFICATION_TYPE_ID number;
467: L_OBJECT_VERSION_NUMBER number;
468: --
469: begin
470: hr_data_pump.entry('call');
471: open cr;
472: fetch cr into c;
473: if cr%notfound then
474: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');

Line 491: hr_data_pump.api_trc_on;

487: hr_pump_get.GET_EQT_OVN
488: (P_DATA_PUMP_ALWAYS_CALL => null
489: ,P_QUALIFICATION_TYPE_NAME => c.p68);
490: --
491: hr_data_pump.api_trc_on;
492: HR_QUALIFICATION_TYPE_API.UPDATE_QUALIFICATION_TYPE
493: (p_validate => l_validate
494: ,P_QUALIFICATION_TYPE_ID => L_QUALIFICATION_TYPE_ID
495: ,P_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER

Line 563: hr_data_pump.api_trc_off;

559: ,P_FIELD => c.p64
560: ,P_SUB_FIELD => c.p65
561: ,P_PROVIDER => c.p66
562: ,P_QA_ORGANIZATION => c.p67);
563: hr_data_pump.api_trc_off;
564:
565: --
566:
567: --

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

566:
567: --
568: close cr;
569: --
570: hr_data_pump.exit('call');
571: exception
572: when hr_multi_message.error_message_exist then
573: if cr%isopen then
574: close cr;