[Home] [Help]
184: ,P_CON_SEG_USER_NAME in varchar2) is
185: blid number := p_data_pump_batch_line_id;
186: begin
187: if blid is not null then
188: delete from hr_pump_batch_lines where batch_line_id = blid;
189: delete from hr_pump_batch_exceptions
190: where source_type = 'BATCH_LINE' and source_id = blid;
191: end if;
192: insert into hr_pump_batch_lines
188: delete from hr_pump_batch_lines where batch_line_id = blid;
189: delete from hr_pump_batch_exceptions
190: where source_type = 'BATCH_LINE' and source_id = blid;
191: end if;
192: insert into hr_pump_batch_lines
193: (batch_id
194: ,batch_line_id
195: ,business_group_name
196: ,api_module_id
295: ,pval104
296: ,pval105)
297: values
298: (p_batch_id
299: ,nvl(blid,hr_pump_batch_lines_s.nextval)
300: ,p_data_pump_business_grp_name
301: ,2905
302: ,'U'
303: ,p_user_sequence
616: l.pval103 d103,
617: decode(l.pval104,cn,vn,vn,vn,l.pval104) p104,
618: l.pval104 d104,
619: decode(l.pval105,cn,vn,l.pval105) p105
620: from hr_pump_batch_lines l
621: where l.batch_line_id = p_batch_line_id;
622: --
623: c cr%rowtype;
624: l_validate boolean := false;
643: open cr;
644: fetch cr into c;
645: if cr%notfound then
646: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
647: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
648: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
649: hr_utility.set_message_token('VALUE',p_batch_line_id);
650: hr_utility.raise_error;
651: end if;
909: else
910: c.p93 := 'FALSE';
911: end if;
912: --
913: update hr_pump_batch_lines l set
914: l.pval085 = decode(c.p85,null,cn,c.p85),
915: l.pval086 = decode(c.p86,null,cn,c.p86),
916: l.pval087 = decode(c.p87,null,cn,c.p87),
917: l.pval088 = decode(c.p88,null,cn,c.p88),