APPS.HRDPP_UPDATE_PTNL_LER_FOR_PER dependencies on HR_PUMP_BATCH_LINES

Line 112: delete from hr_pump_batch_lines where batch_line_id = blid;

108: ,P_PERSON_USER_KEY in varchar2 default null) 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 144: ,nvl(blid,hr_pump_batch_lines_s.nextval)

140: ,pval017
141: ,pval018)
142: values
143: (p_batch_id
144: ,nvl(blid,hr_pump_batch_lines_s.nextval)
145: ,p_data_pump_business_grp_name
146: ,662
147: ,'U'
148: ,p_user_sequence

Line 211: from hr_pump_batch_lines l

207: decode(l.pval017,cn,vn,vn,vh,l.pval017) p17,
208: l.pval017 d17,
209: decode(l.pval018,cn,vn,vn,vn,l.pval018) p18,
210: l.pval018 d18
211: from hr_pump_batch_lines l
212: where l.batch_line_id = p_batch_line_id;
213: --
214: c cr%rowtype;
215: l_validate boolean := false;

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

229: open cr;
230: fetch cr into c;
231: if cr%notfound then
232: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
233: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
234: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
235: hr_utility.set_message_token('VALUE',p_batch_line_id);
236: hr_utility.raise_error;
237: end if;