APPS.HRDPP_UPDATE_ELIG_DPNT dependencies on HR_PUMP_BATCH_LINES

Line 137: delete from hr_pump_batch_lines where batch_line_id = blid;

133: ,P_DPNT_PERSON_USER_KEY in varchar2 default null) is
134: blid number := p_data_pump_batch_line_id;
135: begin
136: if blid is not null then
137: delete from hr_pump_batch_lines where batch_line_id = blid;
138: delete from hr_pump_batch_exceptions
139: where source_type = 'BATCH_LINE' and source_id = blid;
140: end if;
141: insert into hr_pump_batch_lines

Line 141: insert into hr_pump_batch_lines

137: delete from hr_pump_batch_lines where batch_line_id = blid;
138: delete from hr_pump_batch_exceptions
139: where source_type = 'BATCH_LINE' and source_id = blid;
140: end if;
141: insert into hr_pump_batch_lines
142: (batch_id
143: ,batch_line_id
144: ,business_group_name
145: ,api_module_id

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

194: ,pval046
195: ,pval047)
196: values
197: (p_batch_id
198: ,nvl(blid,hr_pump_batch_lines_s.nextval)
199: ,p_data_pump_business_grp_name
200: ,1078
201: ,'U'
202: ,p_user_sequence

Line 353: from hr_pump_batch_lines l

349: decode(l.pval046,cn,vn,vn,vn,l.pval046) p46,
350: l.pval046 d46,
351: decode(l.pval047,cn,vn,vn,vn,l.pval047) p47,
352: l.pval047 d47
353: from hr_pump_batch_lines l
354: where l.batch_line_id = p_batch_line_id;
355: --
356: c cr%rowtype;
357: l_validate boolean := false;

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

372: open cr;
373: fetch cr into c;
374: if cr%notfound then
375: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
376: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
377: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
378: hr_utility.set_message_token('VALUE',p_batch_line_id);
379: hr_utility.raise_error;
380: end if;