[Home] [Help]
150: ,P_PRTT_REIMBMT_RQST_USER_KEY in varchar2 default null) is
151: blid number := p_data_pump_batch_line_id;
152: begin
153: if blid is not null then
154: delete from hr_pump_batch_lines where batch_line_id = blid;
155: delete from hr_pump_batch_exceptions
156: where source_type = 'BATCH_LINE' and source_id = blid;
157: end if;
158: insert into hr_pump_batch_lines
154: delete from hr_pump_batch_lines where batch_line_id = blid;
155: delete from hr_pump_batch_exceptions
156: where source_type = 'BATCH_LINE' and source_id = blid;
157: end if;
158: insert into hr_pump_batch_lines
159: (batch_id
160: ,batch_line_id
161: ,business_group_name
162: ,api_module_id
233: ,pval069
234: ,pval070)
235: values
236: (p_batch_id
237: ,nvl(blid,hr_pump_batch_lines_s.nextval)
238: ,p_data_pump_business_grp_name
239: ,697
240: ,'U'
241: ,p_user_sequence
459: decode(l.pval069,cn,vn,vn,vn,l.pval069) p69,
460: l.pval069 d69,
461: decode(l.pval070,cn,vn,vn,vn,l.pval070) p70,
462: l.pval070 d70
463: from hr_pump_batch_lines l
464: where l.batch_line_id = p_batch_line_id;
465: --
466: c cr%rowtype;
467: l_validate boolean := false;
484: open cr;
485: fetch cr into c;
486: if cr%notfound then
487: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
488: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
489: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
490: hr_utility.set_message_token('VALUE',p_batch_line_id);
491: hr_utility.raise_error;
492: end if;
683: hr_data_pump.api_trc_off;
684: --
685: iuk(p_batch_line_id,c.p1,L_PRTT_RT_VAL_ID);
686: --
687: update hr_pump_batch_lines l set
688: l.pval001 = decode(c.p1,null,cn,c.p1),
689: l.pval056 = decode(c.p56,null,cn,c.p56)
690: where l.rowid = c.myrowid;
691: --