APPS.HRDPP_CREATE_PLAN_BENEFICIARY dependencies on HR_PUMP_BATCH_LINES

Line 141: delete from hr_pump_batch_lines where batch_line_id = blid;

137: else
138: L_MULTI_ROW_ACTN := 'FALSE';
139: end if;
140: if blid is not null then
141: delete from hr_pump_batch_lines where batch_line_id = blid;
142: delete from hr_pump_batch_exceptions
143: where source_type = 'BATCH_LINE' and source_id = blid;
144: end if;
145: insert into hr_pump_batch_lines

Line 145: insert into hr_pump_batch_lines

141: delete from hr_pump_batch_lines where batch_line_id = blid;
142: delete from hr_pump_batch_exceptions
143: where source_type = 'BATCH_LINE' and source_id = blid;
144: end if;
145: insert into hr_pump_batch_lines
146: (batch_id
147: ,batch_line_id
148: ,business_group_name
149: ,api_module_id

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

199: ,pval050
200: ,pval051)
201: values
202: (p_batch_id
203: ,nvl(blid,hr_pump_batch_lines_s.nextval)
204: ,p_data_pump_business_grp_name
205: ,563
206: ,'U'
207: ,p_user_sequence

Line 362: from hr_pump_batch_lines l

358: decode(l.pval050,cn,vn,vn,vn,l.pval050) p50,
359: l.pval050 d50,
360: decode(l.pval051,cn,vn,vn,vn,l.pval051) p51,
361: l.pval051 d51
362: from hr_pump_batch_lines l
363: where l.batch_line_id = p_batch_line_id;
364: --
365: c cr%rowtype;
366: l_validate boolean := false;

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

381: open cr;
382: fetch cr into c;
383: if cr%notfound then
384: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
385: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
386: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
387: hr_utility.set_message_token('VALUE',p_batch_line_id);
388: hr_utility.raise_error;
389: end if;

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

396: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
397: hr_utility.set_message_token('TYPE','BOOLEAN');
398: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
399: hr_utility.set_message_token('VALUE',c.p44);
400: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
401: hr_utility.raise_error;
402: end if;
403: --
404: if c.p45 is null then

Line 529: update hr_pump_batch_lines l set

525: hr_data_pump.api_trc_off;
526: --
527: iuk(p_batch_line_id,c.p1,L_PL_BNF_ID);
528: --
529: update hr_pump_batch_lines l set
530: l.pval001 = decode(c.p1,null,cn,c.p1),
531: l.pval002 = decode(c.p2,null,cn,dc(c.p2)),
532: l.pval003 = decode(c.p3,null,cn,dc(c.p3)),
533: l.pval042 = decode(c.p42,null,cn,c.p42)