[Home] [Help]
90: ,P_REPORTING_NAME in varchar2 default null) is
91: blid number := p_data_pump_batch_line_id;
92: begin
93: if blid is not null then
94: delete from hr_pump_batch_lines where batch_line_id = blid;
95: delete from hr_pump_batch_exceptions
96: where source_type = 'BATCH_LINE' and source_id = blid;
97: end if;
98: insert into hr_pump_batch_lines
94: delete from hr_pump_batch_lines where batch_line_id = blid;
95: delete from hr_pump_batch_exceptions
96: where source_type = 'BATCH_LINE' and source_id = blid;
97: end if;
98: insert into hr_pump_batch_lines
99: (batch_id
100: ,batch_line_id
101: ,business_group_name
102: ,api_module_id
113: ,pval010
114: ,pval011)
115: values
116: (p_batch_id
117: ,nvl(blid,hr_pump_batch_lines_s.nextval)
118: ,p_data_pump_business_grp_name
119: ,1625
120: ,'U'
121: ,p_user_sequence
152: l.pval009 d9,
153: decode(l.pval010,cn,dn,d(l.pval010)) p10,
154: decode(l.pval011,cn,vn,vn,vn,l.pval011) p11,
155: l.pval011 d11
156: from hr_pump_batch_lines l
157: where l.batch_line_id = p_batch_line_id;
158: --
159: c cr%rowtype;
160: l_validate boolean := false;
165: open cr;
166: fetch cr into c;
167: if cr%notfound then
168: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
169: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
170: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
171: hr_utility.set_message_token('VALUE',p_batch_line_id);
172: hr_utility.raise_error;
173: end if;
200: ,P_EFFECTIVE_DATE => c.p10);
201: hr_data_pump.api_trc_off;
202:
203: --
204: update hr_pump_batch_lines l set
205: l.pval001 = decode(c.p1,null,cn,c.p1),
206: l.pval002 = decode(c.p2,null,cn,c.p2)
207: where l.rowid = c.myrowid;
208: --