APPS.HRDPP_CREATE_ELIG_PERSON_OPTIO dependencies on HR_PUMP_BATCH_LINES

Line 176: delete from hr_pump_batch_lines where batch_line_id = blid;

172: else
173: L_OVERRIDE_VALIDATION := 'FALSE';
174: end if;
175: if blid is not null then
176: delete from hr_pump_batch_lines where batch_line_id = blid;
177: delete from hr_pump_batch_exceptions
178: where source_type = 'BATCH_LINE' and source_id = blid;
179: end if;
180: insert into hr_pump_batch_lines

Line 180: insert into hr_pump_batch_lines

176: delete from hr_pump_batch_lines where batch_line_id = blid;
177: delete from hr_pump_batch_exceptions
178: where source_type = 'BATCH_LINE' and source_id = blid;
179: end if;
180: insert into hr_pump_batch_lines
181: (batch_id
182: ,batch_line_id
183: ,business_group_name
184: ,api_module_id

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

269: ,pval085
270: ,pval086)
271: values
272: (p_batch_id
273: ,nvl(blid,hr_pump_batch_lines_s.nextval)
274: ,p_data_pump_business_grp_name
275: ,381
276: ,'U'
277: ,p_user_sequence

Line 560: from hr_pump_batch_lines l

556: decode(l.pval085,cn,vn,vn,vn,l.pval085) p85,
557: l.pval085 d85,
558: decode(l.pval086,cn,vn,vn,vn,l.pval086) p86,
559: l.pval086 d86
560: from hr_pump_batch_lines l
561: where l.batch_line_id = p_batch_line_id;
562: --
563: c cr%rowtype;
564: l_validate boolean := false;

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

578: open cr;
579: fetch cr into c;
580: if cr%notfound then
581: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
582: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
583: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
584: hr_utility.set_message_token('VALUE',p_batch_line_id);
585: hr_utility.raise_error;
586: end if;

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

593: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
594: hr_utility.set_message_token('TYPE','BOOLEAN');
595: hr_utility.set_message_token('PARAMETER','P_OVERRIDE_VALIDATION');
596: hr_utility.set_message_token('VALUE',c.p81);
597: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
598: hr_utility.raise_error;
599: end if;
600: --
601: if c.p82 is null then

Line 754: update hr_pump_batch_lines l set

750: hr_data_pump.api_trc_off;
751: --
752: iuk(p_batch_line_id,c.p1,L_ELIG_PER_OPT_ID);
753: --
754: update hr_pump_batch_lines l set
755: l.pval001 = decode(c.p1,null,cn,c.p1),
756: l.pval002 = decode(c.p2,null,cn,dc(c.p2)),
757: l.pval003 = decode(c.p3,null,cn,dc(c.p3)),
758: l.pval079 = decode(c.p79,null,cn,c.p79)