DBA Data[Home] [Help]

APPS.HRDPP_UPDATE_US_PERSON dependencies on HR_PUMP_BATCH_LINES

Line 213: delete from hr_pump_batch_lines where batch_line_id = blid;

209: ,P_BENEFIT_GROUP in varchar2 default null) is
210: blid number := p_data_pump_batch_line_id;
211: begin
212: if blid is not null then
213: delete from hr_pump_batch_lines where batch_line_id = blid;
214: delete from hr_pump_batch_exceptions
215: where source_type = 'BATCH_LINE' and source_id = blid;
216: end if;
217: insert into hr_pump_batch_lines

Line 217: insert into hr_pump_batch_lines

213: delete from hr_pump_batch_lines where batch_line_id = blid;
214: delete from hr_pump_batch_exceptions
215: where source_type = 'BATCH_LINE' and source_id = blid;
216: end if;
217: insert into hr_pump_batch_lines
218: (batch_id
219: ,batch_line_id
220: ,business_group_name
221: ,api_module_id

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

335: ,pval118
336: ,pval119)
337: values
338: (p_batch_id
339: ,nvl(blid,hr_pump_batch_lines_s.nextval)
340: ,p_data_pump_business_grp_name
341: ,1393
342: ,'U'
343: ,p_user_sequence

Line 710: from hr_pump_batch_lines l

706: decode(l.pval118,cn,vn,vn,vh,l.pval118) p118,
707: l.pval118 d118,
708: decode(l.pval119,cn,vn,vn,vh,l.pval119) p119,
709: l.pval119 d119
710: from hr_pump_batch_lines l
711: where l.batch_line_id = p_batch_line_id;
712: --
713: c cr%rowtype;
714: l_validate boolean := false;

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

727: open cr;
728: fetch cr into c;
729: if cr%notfound then
730: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
731: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
732: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
733: hr_utility.set_message_token('VALUE',p_batch_line_id);
734: hr_utility.raise_error;
735: end if;

Line 942: update hr_pump_batch_lines l set

938: else
939: c.p113 := 'FALSE';
940: end if;
941: --
942: update hr_pump_batch_lines l set
943: l.pval009 = decode(c.p9,null,cn,c.p9),
944: l.pval107 = decode(c.p107,null,cn,dc(c.p107)),
945: l.pval108 = decode(c.p108,null,cn,dc(c.p108)),
946: l.pval109 = decode(c.p109,null,cn,c.p109),