[Home] [Help]
93: ,P_USER_STATUS in varchar2 default null) is
94: blid number := p_data_pump_batch_line_id;
95: begin
96: if blid is not null then
97: delete from hr_pump_batch_lines where batch_line_id = blid;
98: delete from hr_pump_batch_exceptions
99: where source_type = 'BATCH_LINE' and source_id = blid;
100: end if;
101: insert into hr_pump_batch_lines
97: delete from hr_pump_batch_lines where batch_line_id = blid;
98: delete from hr_pump_batch_exceptions
99: where source_type = 'BATCH_LINE' and source_id = blid;
100: end if;
101: insert into hr_pump_batch_lines
102: (batch_id
103: ,batch_line_id
104: ,business_group_name
105: ,api_module_id
117: ,pval019
118: ,pval020)
119: values
120: (p_batch_id
121: ,nvl(blid,hr_pump_batch_lines_s.nextval)
122: ,p_data_pump_business_grp_name
123: ,1198
124: ,'U'
125: ,p_user_sequence
166: decode(l.pval019,cn,vn,vn,vh,l.pval019) p19,
167: l.pval019 d19,
168: decode(l.pval020,cn,vn,vn,vh,l.pval020) p20,
169: l.pval020 d20
170: from hr_pump_batch_lines l
171: where l.batch_line_id = p_batch_line_id;
172: --
173: c cr%rowtype;
174: l_validate boolean := false;
190: open cr;
191: fetch cr into c;
192: if cr%notfound then
193: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
194: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
195: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
196: hr_utility.set_message_token('VALUE',p_batch_line_id);
197: hr_utility.raise_error;
198: end if;
315: else
316: c.p15 := 'FALSE';
317: end if;
318: --
319: update hr_pump_batch_lines l set
320: l.pval003 = decode(c.p3,null,cn,dc(c.p3)),
321: l.pval007 = decode(c.p7,null,cn,c.p7),
322: l.pval008 = decode(c.p8,null,cn,c.p8),
323: l.pval009 = decode(c.p9,null,cn,c.p9),