[Home] [Help]
211: ,P_CON_SEG_USER_NAME in varchar2) is
212: blid number := p_data_pump_batch_line_id;
213: begin
214: if blid is not null then
215: delete from hr_pump_batch_lines where batch_line_id = blid;
216: delete from hr_pump_batch_exceptions
217: where source_type = 'BATCH_LINE' and source_id = blid;
218: end if;
219: insert into hr_pump_batch_lines
215: delete from hr_pump_batch_lines where batch_line_id = blid;
216: delete from hr_pump_batch_exceptions
217: where source_type = 'BATCH_LINE' and source_id = blid;
218: end if;
219: insert into hr_pump_batch_lines
220: (batch_id
221: ,batch_line_id
222: ,business_group_name
223: ,api_module_id
349: ,pval132
350: ,pval133)
351: values
352: (p_batch_id
353: ,nvl(blid,hr_pump_batch_lines_s.nextval)
354: ,p_data_pump_business_grp_name
355: ,1204
356: ,'U'
357: ,p_user_sequence
748: l.pval131 d131,
749: decode(l.pval132,cn,vn,vn,vn,l.pval132) p132,
750: l.pval132 d132,
751: decode(l.pval133,cn,vn,l.pval133) p133
752: from hr_pump_batch_lines l
753: where l.batch_line_id = p_batch_line_id;
754: --
755: c cr%rowtype;
756: l_validate boolean := false;
775: open cr;
776: fetch cr into c;
777: if cr%notfound then
778: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
779: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
780: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
781: hr_utility.set_message_token('VALUE',p_batch_line_id);
782: hr_utility.raise_error;
783: end if;
1068: else
1069: c.p120 := 'FALSE';
1070: end if;
1071: --
1072: update hr_pump_batch_lines l set
1073: l.pval112 = decode(c.p112,null,cn,c.p112),
1074: l.pval113 = decode(c.p113,null,cn,c.p113),
1075: l.pval114 = decode(c.p114,null,cn,c.p114),
1076: l.pval115 = decode(c.p115,null,cn,c.p115),