APPS.HRDPP_UPDATE_SUPPLEMENTARY_ROL dependencies on HR_PUMP_BATCH_LINES

Line 141: delete from hr_pump_batch_lines where batch_line_id = blid;

137: ,P_ROLE_USER_KEY in varchar2) is
138: blid number := p_data_pump_batch_line_id;
139: begin
140: if blid is not null then
141: delete from hr_pump_batch_lines where batch_line_id = blid;
142: delete from hr_pump_batch_exceptions
143: where source_type = 'BATCH_LINE' and source_id = blid;
144: end if;
145: insert into hr_pump_batch_lines

Line 145: insert into hr_pump_batch_lines

141: delete from hr_pump_batch_lines where batch_line_id = blid;
142: delete from hr_pump_batch_exceptions
143: where source_type = 'BATCH_LINE' and source_id = blid;
144: end if;
145: insert into hr_pump_batch_lines
146: (batch_id
147: ,batch_line_id
148: ,business_group_name
149: ,api_module_id

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

202: ,pval050
203: ,pval051)
204: values
205: (p_batch_id
206: ,nvl(blid,hr_pump_batch_lines_s.nextval)
207: ,p_data_pump_business_grp_name
208: ,1738
209: ,'U'
210: ,p_user_sequence

Line 372: from hr_pump_batch_lines l

368: l.pval049 d49,
369: decode(l.pval050,cn,dn,vn,dh,d(l.pval050)) p50,
370: l.pval050 d50,
371: decode(l.pval051,cn,vn,l.pval051) p51
372: from hr_pump_batch_lines l
373: where l.batch_line_id = p_batch_line_id;
374: --
375: c cr%rowtype;
376: l_validate boolean := false;

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

382: open cr;
383: fetch cr into c;
384: if cr%notfound then
385: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
386: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
387: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
388: hr_utility.set_message_token('VALUE',p_batch_line_id);
389: hr_utility.raise_error;
390: end if;