APPS.HRDPP_CREATE_ENROLLMENT dependencies on HR_PUMP_BATCH_LINES

Line 134: delete from hr_pump_batch_lines where batch_line_id = blid;

130: ,P_ACTY_BASE_RATE_NUM4 in number default null) is
131: blid number := p_data_pump_batch_line_id;
132: begin
133: if blid is not null then
134: delete from hr_pump_batch_lines where batch_line_id = blid;
135: delete from hr_pump_batch_exceptions
136: where source_type = 'BATCH_LINE' and source_id = blid;
137: end if;
138: insert into hr_pump_batch_lines

Line 138: insert into hr_pump_batch_lines

134: delete from hr_pump_batch_lines where batch_line_id = blid;
135: delete from hr_pump_batch_exceptions
136: where source_type = 'BATCH_LINE' and source_id = blid;
137: end if;
138: insert into hr_pump_batch_lines
139: (batch_id
140: ,batch_line_id
141: ,business_group_name
142: ,api_module_id

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

193: ,pval048
194: ,pval049)
195: values
196: (p_batch_id
197: ,nvl(blid,hr_pump_batch_lines_s.nextval)
198: ,p_data_pump_business_grp_name
199: ,3845
200: ,'U'
201: ,p_user_sequence

Line 348: from hr_pump_batch_lines l

344: decode(l.pval048,cn,vn,vn,vn,l.pval048) p48,
345: l.pval048 d48,
346: decode(l.pval049,cn,nn,vn,nn,n(l.pval049)) p49,
347: l.pval049 d49
348: from hr_pump_batch_lines l
349: where l.batch_line_id = p_batch_line_id;
350: --
351: c cr%rowtype;
352: l_validate boolean := false;

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

367: open cr;
368: fetch cr into c;
369: if cr%notfound then
370: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
371: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
372: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
373: hr_utility.set_message_token('VALUE',p_batch_line_id);
374: hr_utility.raise_error;
375: end if;