APPS.HRDPP_UPDATE_IN_LOCATION dependencies on HR_PUMP_BATCH_LINES

Line 155: delete from hr_pump_batch_lines where batch_line_id = blid;

151: ,I_SHIP_TO_LOCATION_ID in varchar2 default 'N') is
152: blid number := p_data_pump_batch_line_id;
153: begin
154: if blid is not null then
155: delete from hr_pump_batch_lines where batch_line_id = blid;
156: delete from hr_pump_batch_exceptions
157: where source_type = 'BATCH_LINE' and source_id = blid;
158: end if;
159: insert into hr_pump_batch_lines

Line 159: insert into hr_pump_batch_lines

155: delete from hr_pump_batch_lines where batch_line_id = blid;
156: delete from hr_pump_batch_exceptions
157: where source_type = 'BATCH_LINE' and source_id = blid;
158: end if;
159: insert into hr_pump_batch_lines
160: (batch_id
161: ,batch_line_id
162: ,business_group_name
163: ,api_module_id

Line 237: ,nvl(blid,hr_pump_batch_lines_s.nextval)

233: ,pval067
234: ,pval068)
235: values
236: (p_batch_id
237: ,nvl(blid,hr_pump_batch_lines_s.nextval)
238: ,p_data_pump_business_grp_name
239: ,3226
240: ,'U'
241: ,p_user_sequence

Line 456: from hr_pump_batch_lines l

452: decode(l.pval067,cn,vn,vn,vh,l.pval067) p67,
453: l.pval067 d67,
454: decode(l.pval068,cn,nn,vn,nh,n(l.pval068)) p68,
455: l.pval068 d68
456: from hr_pump_batch_lines l
457: where l.batch_line_id = p_batch_line_id;
458: --
459: c cr%rowtype;
460: l_validate boolean := false;

Line 476: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');

472: open cr;
473: fetch cr into c;
474: if cr%notfound then
475: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
476: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
477: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
478: hr_utility.set_message_token('VALUE',p_batch_line_id);
479: hr_utility.raise_error;
480: end if;