APPS.HRDPP_CREATE_ELIG_CVRD_DPNT dependencies on HR_PUMP_BATCH_LINES

Line 136: delete from hr_pump_batch_lines where batch_line_id = blid;

132: else
133: L_MULTI_ROW_ACTN := 'FALSE';
134: end if;
135: if blid is not null then
136: delete from hr_pump_batch_lines where batch_line_id = blid;
137: delete from hr_pump_batch_exceptions
138: where source_type = 'BATCH_LINE' and source_id = blid;
139: end if;
140: insert into hr_pump_batch_lines

Line 140: insert into hr_pump_batch_lines

136: delete from hr_pump_batch_lines where batch_line_id = blid;
137: delete from hr_pump_batch_exceptions
138: where source_type = 'BATCH_LINE' and source_id = blid;
139: end if;
140: insert into hr_pump_batch_lines
141: (batch_id
142: ,batch_line_id
143: ,business_group_name
144: ,api_module_id

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

189: ,pval045
190: ,pval046)
191: values
192: (p_batch_id
193: ,nvl(blid,hr_pump_batch_lines_s.nextval)
194: ,p_data_pump_business_grp_name
195: ,606
196: ,'U'
197: ,p_user_sequence

Line 338: from hr_pump_batch_lines l

334: decode(l.pval045,cn,vn,vn,vn,l.pval045) p45,
335: l.pval045 d45,
336: decode(l.pval046,cn,vn,vn,vn,l.pval046) p46,
337: l.pval046 d46
338: from hr_pump_batch_lines l
339: where l.batch_line_id = p_batch_line_id;
340: --
341: c cr%rowtype;
342: l_validate boolean := false;

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

354: open cr;
355: fetch cr into c;
356: if cr%notfound then
357: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
358: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
359: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
360: hr_utility.set_message_token('VALUE',p_batch_line_id);
361: hr_utility.raise_error;
362: end if;

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

369: hr_utility.set_message(800,'HR_50327_DP_TYPE_ERR');
370: hr_utility.set_message_token('TYPE','BOOLEAN');
371: hr_utility.set_message_token('PARAMETER','P_MULTI_ROW_ACTN');
372: hr_utility.set_message_token('VALUE',c.p43);
373: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
374: hr_utility.raise_error;
375: end if;
376: --
377: if c.p44 is null then

Line 467: update hr_pump_batch_lines l set

463: hr_data_pump.api_trc_off;
464: --
465: iuk(p_batch_line_id,c.p1,L_ELIG_CVRD_DPNT_ID);
466: --
467: update hr_pump_batch_lines l set
468: l.pval001 = decode(c.p1,null,cn,c.p1),
469: l.pval002 = decode(c.p2,null,cn,dc(c.p2)),
470: l.pval003 = decode(c.p3,null,cn,dc(c.p3)),
471: l.pval039 = decode(c.p39,null,cn,c.p39)