[Home] [Help]
192: ,P_SVR_ASSIGNMENT_USER_KEY in varchar2 default null) is
193: blid number := p_data_pump_batch_line_id;
194: begin
195: if blid is not null then
196: delete from hr_pump_batch_lines where batch_line_id = blid;
197: delete from hr_pump_batch_exceptions
198: where source_type = 'BATCH_LINE' and source_id = blid;
199: end if;
200: insert into hr_pump_batch_lines
196: delete from hr_pump_batch_lines where batch_line_id = blid;
197: delete from hr_pump_batch_exceptions
198: where source_type = 'BATCH_LINE' and source_id = blid;
199: end if;
200: insert into hr_pump_batch_lines
201: (batch_id
202: ,batch_line_id
203: ,business_group_name
204: ,api_module_id
317: ,pval123
318: ,pval124)
319: values
320: (p_batch_id
321: ,nvl(blid,hr_pump_batch_lines_s.nextval)
322: ,p_data_pump_business_grp_name
323: ,1375
324: ,'U'
325: ,p_user_sequence
684: decode(l.pval123,cn,vn,vn,vn,l.pval123) p123,
685: l.pval123 d123,
686: decode(l.pval124,cn,vn,vn,vn,l.pval124) p124,
687: l.pval124 d124
688: from hr_pump_batch_lines l
689: where l.batch_line_id = p_batch_line_id;
690: --
691: c cr%rowtype;
692: l_validate boolean := false;
717: open cr;
718: fetch cr into c;
719: if cr%notfound then
720: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
721: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
722: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
723: hr_utility.set_message_token('VALUE',p_batch_line_id);
724: hr_utility.raise_error;
725: end if;
1045: else
1046: c.p103 := 'FALSE';
1047: end if;
1048: --
1049: update hr_pump_batch_lines l set
1050: l.pval002 = decode(c.p2,null,cn,c.p2),
1051: l.pval091 = decode(c.p91,null,cn,c.p91),
1052: l.pval092 = decode(c.p92,null,cn,c.p92),
1053: l.pval093 = decode(c.p93,null,cn,c.p93),