[Home] [Help]
232: ,P_SVR_ASSIGNMENT_USER_KEY in varchar2 default null) is
233: blid number := p_data_pump_batch_line_id;
234: begin
235: if blid is not null then
236: delete from hr_pump_batch_lines where batch_line_id = blid;
237: delete from hr_pump_batch_exceptions
238: where source_type = 'BATCH_LINE' and source_id = blid;
239: end if;
240: insert into hr_pump_batch_lines
236: delete from hr_pump_batch_lines where batch_line_id = blid;
237: delete from hr_pump_batch_exceptions
238: where source_type = 'BATCH_LINE' and source_id = blid;
239: end if;
240: insert into hr_pump_batch_lines
241: (batch_id
242: ,batch_line_id
243: ,business_group_name
244: ,api_module_id
397: ,pval163
398: ,pval164)
399: values
400: (p_batch_id
401: ,nvl(blid,hr_pump_batch_lines_s.nextval)
402: ,p_data_pump_business_grp_name
403: ,3869
404: ,'U'
405: ,p_user_sequence
888: decode(l.pval163,cn,vn,vn,vn,l.pval163) p163,
889: l.pval163 d163,
890: decode(l.pval164,cn,vn,vn,vn,l.pval164) p164,
891: l.pval164 d164
892: from hr_pump_batch_lines l
893: where l.batch_line_id = p_batch_line_id;
894: --
895: c cr%rowtype;
896: l_validate boolean := false;
923: open cr;
924: fetch cr into c;
925: if cr%notfound then
926: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
927: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
928: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
929: hr_utility.set_message_token('VALUE',p_batch_line_id);
930: hr_utility.raise_error;
931: end if;
1311: else
1312: c.p142 := 'FALSE';
1313: end if;
1314: --
1315: update hr_pump_batch_lines l set
1316: l.pval002 = decode(c.p2,null,cn,c.p2),
1317: l.pval129 = decode(c.p129,null,cn,c.p129),
1318: l.pval130 = decode(c.p130,null,cn,c.p130),
1319: l.pval131 = decode(c.p131,null,cn,c.p131),