APPS.HRDPP_UPDATE_RATING_SCALE dependencies on HR_PUMP_BATCH_LINES

Line 112: delete from hr_pump_batch_lines where batch_line_id = blid;

108: ,P_OLD_RATING_SCALE_NAME in varchar2) is
109: blid number := p_data_pump_batch_line_id;
110: begin
111: if blid is not null then
112: delete from hr_pump_batch_lines where batch_line_id = blid;
113: delete from hr_pump_batch_exceptions
114: where source_type = 'BATCH_LINE' and source_id = blid;
115: end if;
116: insert into hr_pump_batch_lines

Line 116: insert into hr_pump_batch_lines

112: delete from hr_pump_batch_lines where batch_line_id = blid;
113: delete from hr_pump_batch_exceptions
114: where source_type = 'BATCH_LINE' and source_id = blid;
115: end if;
116: insert into hr_pump_batch_lines
117: (batch_id
118: ,batch_line_id
119: ,business_group_name
120: ,api_module_id

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

149: ,pval026
150: ,pval027)
151: values
152: (p_batch_id
153: ,nvl(blid,hr_pump_batch_lines_s.nextval)
154: ,p_data_pump_business_grp_name
155: ,1321
156: ,'U'
157: ,p_user_sequence

Line 246: from hr_pump_batch_lines l

242: l.pval025 d25,
243: decode(l.pval026,cn,vn,vn,vh,l.pval026) p26,
244: l.pval026 d26,
245: decode(l.pval027,cn,vn,l.pval027) p27
246: from hr_pump_batch_lines l
247: where l.batch_line_id = p_batch_line_id;
248: --
249: c cr%rowtype;
250: l_validate boolean := false;

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

256: open cr;
257: fetch cr into c;
258: if cr%notfound then
259: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
260: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
261: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
262: hr_utility.set_message_token('VALUE',p_batch_line_id);
263: hr_utility.raise_error;
264: end if;