APPS.HRDPP_CREATE_PRTT_ENRT_RESULT dependencies on HR_PUMP_BATCH_LINES

Line 160: delete from hr_pump_batch_lines where batch_line_id = blid;

156: else
157: L_MULTI_ROW_VALIDATE := 'FALSE';
158: end if;
159: if blid is not null then
160: delete from hr_pump_batch_lines where batch_line_id = blid;
161: delete from hr_pump_batch_exceptions
162: where source_type = 'BATCH_LINE' and source_id = blid;
163: end if;
164: insert into hr_pump_batch_lines

Line 164: insert into hr_pump_batch_lines

160: delete from hr_pump_batch_lines where batch_line_id = blid;
161: delete from hr_pump_batch_exceptions
162: where source_type = 'BATCH_LINE' and source_id = blid;
163: end if;
164: insert into hr_pump_batch_lines
165: (batch_id
166: ,batch_line_id
167: ,business_group_name
168: ,api_module_id

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

237: ,pval069
238: ,pval070)
239: values
240: (p_batch_id
241: ,nvl(blid,hr_pump_batch_lines_s.nextval)
242: ,p_data_pump_business_grp_name
243: ,617
244: ,'U'
245: ,p_user_sequence

Line 466: from hr_pump_batch_lines l

462: decode(l.pval069,cn,vn,vn,vn,l.pval069) p69,
463: l.pval069 d69,
464: decode(l.pval070,cn,vn,vn,vn,l.pval070) p70,
465: l.pval070 d70
466: from hr_pump_batch_lines l
467: where l.batch_line_id = p_batch_line_id;
468: --
469: c cr%rowtype;
470: l_validate boolean := false;

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

490: open cr;
491: fetch cr into c;
492: if cr%notfound then
493: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
494: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
495: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
496: hr_utility.set_message_token('VALUE',p_batch_line_id);
497: hr_utility.raise_error;
498: end if;

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

505: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
506: hr_utility.set_message_token('TYPE','BOOLEAN');
507: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_VALIDATE');
508: hr_utility.set_message_token('VALUE',c.p59);
509: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
510: hr_utility.raise_error;
511: end if;
512: --
513: if c.p60 is null then

Line 705: update hr_pump_batch_lines l set

701: hr_data_pump.api_trc_off;
702: --
703: iuk(p_batch_line_id,c.p1,L_PRTT_ENRT_RSLT_ID);
704: --
705: update hr_pump_batch_lines l set
706: l.pval001 = decode(c.p1,null,cn,c.p1),
707: l.pval002 = decode(c.p2,null,cn,dc(c.p2)),
708: l.pval003 = decode(c.p3,null,cn,dc(c.p3)),
709: l.pval052 = decode(c.p52,null,cn,c.p52)