APPS.HRDPP_UPDATE_CBR_QUALD_BNF dependencies on HR_PUMP_BATCH_LINES

Line 129: delete from hr_pump_batch_lines where batch_line_id = blid;

125: ,P_CVRD_EMP_PERSON_USER_KEY in varchar2 default null) is
126: blid number := p_data_pump_batch_line_id;
127: begin
128: if blid is not null then
129: delete from hr_pump_batch_lines where batch_line_id = blid;
130: delete from hr_pump_batch_exceptions
131: where source_type = 'BATCH_LINE' and source_id = blid;
132: end if;
133: insert into hr_pump_batch_lines

Line 133: insert into hr_pump_batch_lines

129: delete from hr_pump_batch_lines where batch_line_id = blid;
130: delete from hr_pump_batch_exceptions
131: where source_type = 'BATCH_LINE' and source_id = blid;
132: end if;
133: insert into hr_pump_batch_lines
134: (batch_id
135: ,batch_line_id
136: ,business_group_name
137: ,api_module_id

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

181: ,pval041
182: ,pval042)
183: values
184: (p_batch_id
185: ,nvl(blid,hr_pump_batch_lines_s.nextval)
186: ,p_data_pump_business_grp_name
187: ,26
188: ,'U'
189: ,p_user_sequence

Line 324: from hr_pump_batch_lines l

320: decode(l.pval041,cn,vn,vn,vh,l.pval041) p41,
321: l.pval041 d41,
322: decode(l.pval042,cn,vn,vn,vn,l.pval042) p42,
323: l.pval042 d42
324: from hr_pump_batch_lines l
325: where l.batch_line_id = p_batch_line_id;
326: --
327: c cr%rowtype;
328: l_validate boolean := false;

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

339: open cr;
340: fetch cr into c;
341: if cr%notfound then
342: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
343: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
344: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
345: hr_utility.set_message_token('VALUE',p_batch_line_id);
346: hr_utility.raise_error;
347: end if;