APPS.HRDPP_UPDATE_ELEMENT_OUTCOME dependencies on HR_PUMP_BATCH_LINES

Line 137: delete from hr_pump_batch_lines where batch_line_id = blid;

133: ,P_OUTCOME_NAME 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 200: ,nvl(blid,hr_pump_batch_lines_s.nextval)

196: ,pval048
197: ,pval049)
198: values
199: (p_batch_id
200: ,nvl(blid,hr_pump_batch_lines_s.nextval)
201: ,p_data_pump_business_grp_name
202: ,3101
203: ,'U'
204: ,p_user_sequence

Line 357: from hr_pump_batch_lines l

353: l.pval047 d47,
354: decode(l.pval048,cn,vn,l.pval048) p48,
355: decode(l.pval049,cn,vn,vn,vh,l.pval049) p49,
356: l.pval049 d49
357: from hr_pump_batch_lines l
358: where l.batch_line_id = p_batch_line_id;
359: --
360: c cr%rowtype;
361: l_validate boolean := false;

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

367: open cr;
368: fetch cr into c;
369: if cr%notfound then
370: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
371: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
372: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
373: hr_utility.set_message_token('VALUE',p_batch_line_id);
374: hr_utility.raise_error;
375: end if;