[Home] [Help]
190: ,P_CON_SEG_USER_NAME in varchar2) is
191: blid number := p_data_pump_batch_line_id;
192: begin
193: if blid is not null then
194: delete from hr_pump_batch_lines where batch_line_id = blid;
195: delete from hr_pump_batch_exceptions
196: where source_type = 'BATCH_LINE' and source_id = blid;
197: end if;
198: insert into hr_pump_batch_lines
194: delete from hr_pump_batch_lines where batch_line_id = blid;
195: delete from hr_pump_batch_exceptions
196: where source_type = 'BATCH_LINE' and source_id = blid;
197: end if;
198: insert into hr_pump_batch_lines
199: (batch_id
200: ,batch_line_id
201: ,business_group_name
202: ,api_module_id
307: ,pval111
308: ,pval112)
309: values
310: (p_batch_id
311: ,nvl(blid,hr_pump_batch_lines_s.nextval)
312: ,p_data_pump_business_grp_name
313: ,3214
314: ,'U'
315: ,p_user_sequence
647: l.pval110 d110,
648: decode(l.pval111,cn,vn,vn,vn,l.pval111) p111,
649: l.pval111 d111,
650: decode(l.pval112,cn,vn,l.pval112) p112
651: from hr_pump_batch_lines l
652: where l.batch_line_id = p_batch_line_id;
653: --
654: c cr%rowtype;
655: l_validate boolean := false;
680: open cr;
681: fetch cr into c;
682: if cr%notfound then
683: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
684: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
685: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
686: hr_utility.set_message_token('VALUE',p_batch_line_id);
687: hr_utility.raise_error;
688: end if;
1012: else
1013: c.p93 := 'FALSE';
1014: end if;
1015: --
1016: update hr_pump_batch_lines l set
1017: l.pval085 = decode(c.p85,null,cn,c.p85),
1018: l.pval086 = decode(c.p86,null,cn,c.p86),
1019: l.pval087 = decode(c.p87,null,cn,c.p87),
1020: l.pval088 = decode(c.p88,null,cn,c.p88),