[Home] [Help]
94: ,P_SECURITY_PROFILE_NAME in varchar2) is
95: blid number := p_data_pump_batch_line_id;
96: begin
97: if blid is not null then
98: delete from hr_pump_batch_lines where batch_line_id = blid;
99: delete from hr_pump_batch_exceptions
100: where source_type = 'BATCH_LINE' and source_id = blid;
101: end if;
102: insert into hr_pump_batch_lines
98: delete from hr_pump_batch_lines where batch_line_id = blid;
99: delete from hr_pump_batch_exceptions
100: where source_type = 'BATCH_LINE' and source_id = blid;
101: end if;
102: insert into hr_pump_batch_lines
103: (batch_id
104: ,batch_line_id
105: ,business_group_name
106: ,api_module_id
121: ,pval014
122: ,pval015)
123: values
124: (p_batch_id
125: ,nvl(blid,hr_pump_batch_lines_s.nextval)
126: ,p_data_pump_business_grp_name
127: ,1615
128: ,'U'
129: ,p_user_sequence
162: decode(l.pval012,cn,vn,l.pval012) p12,
163: decode(l.pval013,cn,vn,l.pval013) p13,
164: decode(l.pval014,cn,vn,l.pval014) p14,
165: decode(l.pval015,cn,vn,l.pval015) p15
166: from hr_pump_batch_lines l
167: where l.batch_line_id = p_batch_line_id;
168: --
169: c cr%rowtype;
170: l_validate boolean := false;
178: open cr;
179: fetch cr into c;
180: if cr%notfound then
181: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
182: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
183: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
184: hr_utility.set_message_token('VALUE',p_batch_line_id);
185: hr_utility.raise_error;
186: end if;
245: ,P_OBJECT_VERSION_NUMBER => c.p10);
246: hr_data_pump.api_trc_off;
247:
248: --
249: update hr_pump_batch_lines l set
250: l.pval008 = decode(c.p8,null,cn,c.p8),
251: l.pval009 = decode(c.p9,null,cn,c.p9),
252: l.pval010 = decode(c.p10,null,cn,c.p10)
253: where l.rowid = c.myrowid;