APPS.HRDPP_CREATE_AC_EMPTAXRULE dependencies on HR_PUMP_BATCH_LINES

Line 201: delete from hr_pump_batch_lines where batch_line_id = blid;

197: ,P_ADDITIONAL_INFO10 in number default null) is
198: blid number := p_data_pump_batch_line_id;
199: begin
200: if blid is not null then
201: delete from hr_pump_batch_lines where batch_line_id = blid;
202: delete from hr_pump_batch_exceptions
203: where source_type = 'BATCH_LINE' and source_id = blid;
204: end if;
205: insert into hr_pump_batch_lines

Line 205: insert into hr_pump_batch_lines

201: delete from hr_pump_batch_lines where batch_line_id = blid;
202: delete from hr_pump_batch_exceptions
203: where source_type = 'BATCH_LINE' and source_id = blid;
204: end if;
205: insert into hr_pump_batch_lines
206: (batch_id
207: ,batch_line_id
208: ,business_group_name
209: ,api_module_id

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

327: ,pval115
328: ,pval116)
329: values
330: (p_batch_id
331: ,nvl(blid,hr_pump_batch_lines_s.nextval)
332: ,p_data_pump_business_grp_name
333: ,3848
334: ,'U'
335: ,p_user_sequence

Line 702: from hr_pump_batch_lines l

698: decode(l.pval115,cn,nn,vn,nn,n(l.pval115)) p115,
699: l.pval115 d115,
700: decode(l.pval116,cn,nn,vn,nn,n(l.pval116)) p116,
701: l.pval116 d116
702: from hr_pump_batch_lines l
703: where l.batch_line_id = p_batch_line_id;
704: --
705: c cr%rowtype;
706: l_validate boolean := false;

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

710: open cr;
711: fetch cr into c;
712: if cr%notfound then
713: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
714: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
715: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
716: hr_utility.set_message_token('VALUE',p_batch_line_id);
717: hr_utility.raise_error;
718: end if;