APPS.HRDPP_UPDATE_CBR_PER_IN_LER dependencies on HR_PUMP_BATCH_LINES

Line 125: delete from hr_pump_batch_lines where batch_line_id = blid;

121: ,P_CBR_QUALD_BNF_USER_KEY in varchar2 default null) is
122: blid number := p_data_pump_batch_line_id;
123: begin
124: if blid is not null then
125: delete from hr_pump_batch_lines where batch_line_id = blid;
126: delete from hr_pump_batch_exceptions
127: where source_type = 'BATCH_LINE' and source_id = blid;
128: end if;
129: insert into hr_pump_batch_lines

Line 129: insert into hr_pump_batch_lines

125: delete from hr_pump_batch_lines where batch_line_id = blid;
126: delete from hr_pump_batch_exceptions
127: where source_type = 'BATCH_LINE' and source_id = blid;
128: end if;
129: insert into hr_pump_batch_lines
130: (batch_id
131: ,batch_line_id
132: ,business_group_name
133: ,api_module_id

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

173: ,pval037
174: ,pval038)
175: values
176: (p_batch_id
177: ,nvl(blid,hr_pump_batch_lines_s.nextval)
178: ,p_data_pump_business_grp_name
179: ,30
180: ,'U'
181: ,p_user_sequence

Line 303: from hr_pump_batch_lines l

299: decode(l.pval037,cn,vn,vn,vn,l.pval037) p37,
300: l.pval037 d37,
301: decode(l.pval038,cn,vn,vn,vn,l.pval038) p38,
302: l.pval038 d38
303: from hr_pump_batch_lines l
304: where l.batch_line_id = p_batch_line_id;
305: --
306: c cr%rowtype;
307: l_validate boolean := false;

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

315: open cr;
316: fetch cr into c;
317: if cr%notfound then
318: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
319: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
320: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
321: hr_utility.set_message_token('VALUE',p_batch_line_id);
322: hr_utility.raise_error;
323: end if;