APPS.HRDPP_UPDATE_RATING_LEVEL dependencies on HR_PUMP_BATCH_LINES

Line 113: delete from hr_pump_batch_lines where batch_line_id = blid;

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

Line 117: insert into hr_pump_batch_lines

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

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

151: ,pval027
152: ,pval028)
153: values
154: (p_batch_id
155: ,nvl(blid,hr_pump_batch_lines_s.nextval)
156: ,p_data_pump_business_grp_name
157: ,1308
158: ,'U'
159: ,p_user_sequence

Line 248: from hr_pump_batch_lines l

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

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

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