APPS.HRDPP_UPDATE_OUTCOME dependencies on HR_PUMP_BATCH_LINES

Line 139: delete from hr_pump_batch_lines where batch_line_id = blid;

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

Line 143: insert into hr_pump_batch_lines

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

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

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

Line 368: from hr_pump_batch_lines l

364: l.pval049 d49,
365: decode(l.pval050,cn,vn,l.pval050) p50,
366: decode(l.pval051,cn,vn,vn,vh,l.pval051) p51,
367: l.pval051 d51
368: from hr_pump_batch_lines l
369: where l.batch_line_id = p_batch_line_id;
370: --
371: c cr%rowtype;
372: l_validate boolean := false;

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

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