APPS.HRDPP_UPDATE_PLAN_BENEFICIARY dependencies on HR_PUMP_BATCH_LINES

Line 147: delete from hr_pump_batch_lines where batch_line_id = blid;

143: else
144: L_MULTI_ROW_ACTN := 'FALSE';
145: end if;
146: if blid is not null then
147: delete from hr_pump_batch_lines where batch_line_id = blid;
148: delete from hr_pump_batch_exceptions
149: where source_type = 'BATCH_LINE' and source_id = blid;
150: end if;
151: insert into hr_pump_batch_lines

Line 151: insert into hr_pump_batch_lines

147: delete from hr_pump_batch_lines where batch_line_id = blid;
148: delete from hr_pump_batch_exceptions
149: where source_type = 'BATCH_LINE' and source_id = blid;
150: end if;
151: insert into hr_pump_batch_lines
152: (batch_id
153: ,batch_line_id
154: ,business_group_name
155: ,api_module_id

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

206: ,pval050
207: ,pval051)
208: values
209: (p_batch_id
210: ,nvl(blid,hr_pump_batch_lines_s.nextval)
211: ,p_data_pump_business_grp_name
212: ,567
213: ,'U'
214: ,p_user_sequence

Line 370: from hr_pump_batch_lines l

366: decode(l.pval050,cn,vn,vn,vh,l.pval050) p50,
367: l.pval050 d50,
368: decode(l.pval051,cn,vn,vn,vn,l.pval051) p51,
369: l.pval051 d51
370: from hr_pump_batch_lines l
371: where l.batch_line_id = p_batch_line_id;
372: --
373: c cr%rowtype;
374: l_validate boolean := false;

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

390: open cr;
391: fetch cr into c;
392: if cr%notfound then
393: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
394: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
395: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
396: hr_utility.set_message_token('VALUE',p_batch_line_id);
397: hr_utility.raise_error;
398: end if;

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

405: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
406: hr_utility.set_message_token('TYPE','BOOLEAN');
407: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
408: hr_utility.set_message_token('VALUE',c.p43);
409: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
410: hr_utility.raise_error;
411: end if;
412: --
413: if c.p44 is null then

Line 569: update hr_pump_batch_lines l set

565: ,P_MULTI_ROW_ACTN => L_MULTI_ROW_ACTN);
566: hr_data_pump.api_trc_off;
567:
568: --
569: update hr_pump_batch_lines l set
570: l.pval001 = decode(c.p1,null,cn,dc(c.p1)),
571: l.pval002 = decode(c.p2,null,cn,dc(c.p2))
572: where l.rowid = c.myrowid;
573: --