APPS.HRDPP_UPDATE_ELIG_CVRD_DPNT 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 199: ,nvl(blid,hr_pump_batch_lines_s.nextval)

195: ,pval045
196: ,pval046)
197: values
198: (p_batch_id
199: ,nvl(blid,hr_pump_batch_lines_s.nextval)
200: ,p_data_pump_business_grp_name
201: ,607
202: ,'U'
203: ,p_user_sequence

Line 345: from hr_pump_batch_lines l

341: decode(l.pval045,cn,vn,vn,vn,l.pval045) p45,
342: l.pval045 d45,
343: decode(l.pval046,cn,vn,vn,vn,l.pval046) p46,
344: l.pval046 d46
345: from hr_pump_batch_lines l
346: where l.batch_line_id = p_batch_line_id;
347: --
348: c cr%rowtype;
349: l_validate boolean := false;

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

362: open cr;
363: fetch cr into c;
364: if cr%notfound then
365: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
366: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
367: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
368: hr_utility.set_message_token('VALUE',p_batch_line_id);
369: hr_utility.raise_error;
370: end if;

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

377: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
378: hr_utility.set_message_token('TYPE','BOOLEAN');
379: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
380: hr_utility.set_message_token('VALUE',c.p42);
381: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
382: hr_utility.raise_error;
383: end if;
384: --
385: if c.p43 is null then

Line 499: update hr_pump_batch_lines l set

495: ,P_MULTI_ROW_ACTN => L_MULTI_ROW_ACTN);
496: hr_data_pump.api_trc_off;
497:
498: --
499: update hr_pump_batch_lines l set
500: l.pval001 = decode(c.p1,null,cn,dc(c.p1)),
501: l.pval002 = decode(c.p2,null,cn,dc(c.p2))
502: where l.rowid = c.myrowid;
503: --