[Home] [Help]
219: ,P_CAGR_ID_FLEX_NUM_USER_KEY in varchar2 default null) is
220: blid number := p_data_pump_batch_line_id;
221: begin
222: if blid is not null then
223: delete from hr_pump_batch_lines where batch_line_id = blid;
224: delete from hr_pump_batch_exceptions
225: where source_type = 'BATCH_LINE' and source_id = blid;
226: end if;
227: insert into hr_pump_batch_lines
223: delete from hr_pump_batch_lines where batch_line_id = blid;
224: delete from hr_pump_batch_exceptions
225: where source_type = 'BATCH_LINE' and source_id = blid;
226: end if;
227: insert into hr_pump_batch_lines
228: (batch_id
229: ,batch_line_id
230: ,business_group_name
231: ,api_module_id
371: ,pval147
372: ,pval148)
373: values
374: (p_batch_id
375: ,nvl(blid,hr_pump_batch_lines_s.nextval)
376: ,p_data_pump_business_grp_name
377: ,2904
378: ,'U'
379: ,p_user_sequence
811: decode(l.pval147,cn,vn,vn,vn,l.pval147) p147,
812: l.pval147 d147,
813: decode(l.pval148,cn,vn,vn,vn,l.pval148) p148,
814: l.pval148 d148
815: from hr_pump_batch_lines l
816: where l.batch_line_id = p_batch_line_id;
817: --
818: c cr%rowtype;
819: l_validate boolean := false;
844: open cr;
845: fetch cr into c;
846: if cr%notfound then
847: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
848: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
849: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
850: hr_utility.set_message_token('VALUE',p_batch_line_id);
851: hr_utility.raise_error;
852: end if;
1193: else
1194: c.p129 := 'FALSE';
1195: end if;
1196: --
1197: update hr_pump_batch_lines l set
1198: l.pval002 = decode(c.p2,null,cn,c.p2),
1199: l.pval116 = decode(c.p116,null,cn,c.p116),
1200: l.pval117 = decode(c.p117,null,cn,c.p117),
1201: l.pval118 = decode(c.p118,null,cn,c.p118),