APPS.HRDPP_UPDATE_ORGANIZATION_STRU dependencies on HR_PUMP_BATCH_LINES

Line 113: delete from hr_pump_batch_lines where batch_line_id = blid;

109: ,P_POSITION_CONTROL_STRUCTURE_F in varchar2 default null) is
110: blid number := p_data_pump_batch_line_id;
111: begin
112: if blid is not null then
113: delete from hr_pump_batch_lines where batch_line_id = blid;
114: delete from hr_pump_batch_exceptions
115: where source_type = 'BATCH_LINE' and source_id = blid;
116: end if;
117: insert into hr_pump_batch_lines

Line 117: insert into hr_pump_batch_lines

113: delete from hr_pump_batch_lines where batch_line_id = blid;
114: delete from hr_pump_batch_exceptions
115: where source_type = 'BATCH_LINE' and source_id = blid;
116: end if;
117: insert into hr_pump_batch_lines
118: (batch_id
119: ,batch_line_id
120: ,business_group_name
121: ,api_module_id

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

150: ,pval026
151: ,pval027)
152: values
153: (p_batch_id
154: ,nvl(blid,hr_pump_batch_lines_s.nextval)
155: ,p_data_pump_business_grp_name
156: ,2252
157: ,'U'
158: ,p_user_sequence

Line 246: from hr_pump_batch_lines l

242: decode(l.pval026,cn,vn,vn,vh,l.pval026) p26,
243: l.pval026 d26,
244: decode(l.pval027,cn,vn,vn,vh,l.pval027) p27,
245: l.pval027 d27
246: from hr_pump_batch_lines l
247: where l.batch_line_id = p_batch_line_id;
248: --
249: c cr%rowtype;
250: l_validate boolean := false;

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

259: open cr;
260: fetch cr into c;
261: if cr%notfound then
262: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
263: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
264: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
265: hr_utility.set_message_token('VALUE',p_batch_line_id);
266: hr_utility.raise_error;
267: end if;