APPS.HRDPP_CREATE_ELIGIBLE_PERSON dependencies on HR_PUMP_BATCH_LINES

Line 189: delete from hr_pump_batch_lines where batch_line_id = blid;

185: else
186: L_OVERRIDE_VALIDATION := 'FALSE';
187: end if;
188: if blid is not null then
189: delete from hr_pump_batch_lines where batch_line_id = blid;
190: delete from hr_pump_batch_exceptions
191: where source_type = 'BATCH_LINE' and source_id = blid;
192: end if;
193: insert into hr_pump_batch_lines

Line 193: insert into hr_pump_batch_lines

189: delete from hr_pump_batch_lines where batch_line_id = blid;
190: delete from hr_pump_batch_exceptions
191: where source_type = 'BATCH_LINE' and source_id = blid;
192: end if;
193: insert into hr_pump_batch_lines
194: (batch_id
195: ,batch_line_id
196: ,business_group_name
197: ,api_module_id

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

295: ,pval098
296: ,pval099)
297: values
298: (p_batch_id
299: ,nvl(blid,hr_pump_batch_lines_s.nextval)
300: ,p_data_pump_business_grp_name
301: ,625
302: ,'U'
303: ,p_user_sequence

Line 632: from hr_pump_batch_lines l

628: decode(l.pval098,cn,vn,vn,vn,l.pval098) p98,
629: l.pval098 d98,
630: decode(l.pval099,cn,vn,vn,vn,l.pval099) p99,
631: l.pval099 d99
632: from hr_pump_batch_lines l
633: where l.batch_line_id = p_batch_line_id;
634: --
635: c cr%rowtype;
636: l_validate boolean := false;

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

653: open cr;
654: fetch cr into c;
655: if cr%notfound then
656: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
657: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
658: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
659: hr_utility.set_message_token('VALUE',p_batch_line_id);
660: hr_utility.raise_error;
661: end if;

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

668: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
669: hr_utility.set_message_token('TYPE','BOOLEAN');
670: hr_utility.set_message_token('PARAMETER','P_OVERRIDE_VALIDATION');
671: hr_utility.set_message_token('VALUE',c.p91);
672: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
673: hr_utility.raise_error;
674: end if;
675: --
676: if c.p92 is null or

Line 872: update hr_pump_batch_lines l set

868: hr_data_pump.api_trc_off;
869: --
870: iuk(p_batch_line_id,c.p1,L_ELIG_PER_ID);
871: --
872: update hr_pump_batch_lines l set
873: l.pval001 = decode(c.p1,null,cn,c.p1),
874: l.pval002 = decode(c.p2,null,cn,dc(c.p2)),
875: l.pval003 = decode(c.p3,null,cn,dc(c.p3)),
876: l.pval089 = decode(c.p89,null,cn,c.p89)