DBA Data[Home] [Help]

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

154: L_COMPANY_VALUESET_ID number;
155: L_COSTCENTER_VALUESET_ID number;
156: --
157: begin
158: hr_data_pump.entry('call');
159: open cr;
160: fetch cr into c;
161: if cr%notfound then
162: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');

Line 198: hr_data_pump.api_trc_on;

194: PER_ORG_DATA_PUMP.GET_COSTCENTER_VALUESET_ID
195: (P_COSTCENTER_VALUESET_NAME => c.p11);
196: end if;
197: --
198: hr_data_pump.api_trc_on;
199: HR_ORGANIZATION_API.CREATE_COMPANY_COST_CENTER
200: (p_validate => l_validate
201: ,P_EFFECTIVE_DATE => c.p1
202: ,P_ORGANIZATION_ID => L_ORGANIZATION_ID

Line 211: hr_data_pump.api_trc_off;

207: ,P_ORI_ORG_INFORMATION_ID => c.p4
208: ,P_ORI_OBJECT_VERSION_NUMBER => c.p5
209: ,P_ORG_INFORMATION_ID => c.p6
210: ,P_OBJECT_VERSION_NUMBER => c.p7);
211: hr_data_pump.api_trc_off;
212:
213: --
214: update hr_pump_batch_lines l set
215: l.pval004 = decode(c.p4,null,cn,c.p4),

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

219: where l.rowid = c.myrowid;
220: --
221: close cr;
222: --
223: hr_data_pump.exit('call');
224: exception
225: when hr_multi_message.error_message_exist then
226: if cr%isopen then
227: close cr;