[Home] [Help]
226: ,P_SVR_ASSIGNMENT_USER_KEY in varchar2 default null) is
227: blid number := p_data_pump_batch_line_id;
228: begin
229: if blid is not null then
230: delete from hr_pump_batch_lines where batch_line_id = blid;
231: delete from hr_pump_batch_exceptions
232: where source_type = 'BATCH_LINE' and source_id = blid;
233: end if;
234: insert into hr_pump_batch_lines
230: delete from hr_pump_batch_lines where batch_line_id = blid;
231: delete from hr_pump_batch_exceptions
232: where source_type = 'BATCH_LINE' and source_id = blid;
233: end if;
234: insert into hr_pump_batch_lines
235: (batch_id
236: ,batch_line_id
237: ,business_group_name
238: ,api_module_id
385: ,pval155
386: ,pval156)
387: values
388: (p_batch_id
389: ,nvl(blid,hr_pump_batch_lines_s.nextval)
390: ,p_data_pump_business_grp_name
391: ,3213
392: ,'U'
393: ,p_user_sequence
849: decode(l.pval155,cn,vn,vn,vn,l.pval155) p155,
850: l.pval155 d155,
851: decode(l.pval156,cn,vn,vn,vn,l.pval156) p156,
852: l.pval156 d156
853: from hr_pump_batch_lines l
854: where l.batch_line_id = p_batch_line_id;
855: --
856: c cr%rowtype;
857: l_validate boolean := false;
889: open cr;
890: fetch cr into c;
891: if cr%notfound then
892: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
893: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
894: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
895: hr_utility.set_message_token('VALUE',p_batch_line_id);
896: hr_utility.raise_error;
897: end if;
1304: else
1305: c.p129 := 'FALSE';
1306: end if;
1307: --
1308: update hr_pump_batch_lines l set
1309: l.pval002 = decode(c.p2,null,cn,c.p2),
1310: l.pval116 = decode(c.p116,null,cn,c.p116),
1311: l.pval117 = decode(c.p117,null,cn,c.p117),
1312: l.pval118 = decode(c.p118,null,cn,c.p118),