[Home] [Help]
91: ,P_LANGUAGE_CODE in varchar2 default null) is
92: blid number := p_data_pump_batch_line_id;
93: begin
94: if blid is not null then
95: delete from hr_pump_batch_lines where batch_line_id = blid;
96: delete from hr_pump_batch_exceptions
97: where source_type = 'BATCH_LINE' and source_id = blid;
98: end if;
99: insert into hr_pump_batch_lines
95: delete from hr_pump_batch_lines where batch_line_id = blid;
96: delete from hr_pump_batch_exceptions
97: where source_type = 'BATCH_LINE' and source_id = blid;
98: end if;
99: insert into hr_pump_batch_lines
100: (batch_id
101: ,batch_line_id
102: ,business_group_name
103: ,api_module_id
115: ,pval013
116: ,pval014)
117: values
118: (p_batch_id
119: ,nvl(blid,hr_pump_batch_lines_s.nextval)
120: ,p_data_pump_business_grp_name
121: ,1205
122: ,'U'
123: ,p_user_sequence
157: decode(l.pval013,cn,vn,vn,vh,l.pval013) p13,
158: l.pval013 d13,
159: decode(l.pval014,cn,vn,vn,vh,l.pval014) p14,
160: l.pval014 d14
161: from hr_pump_batch_lines l
162: where l.batch_line_id = p_batch_line_id;
163: --
164: c cr%rowtype;
165: l_validate boolean := false;
174: open cr;
175: fetch cr into c;
176: if cr%notfound then
177: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
178: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
179: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
180: hr_utility.set_message_token('VALUE',p_batch_line_id);
181: hr_utility.raise_error;
182: end if;
234: else
235: c.p11 := 'FALSE';
236: end if;
237: --
238: update hr_pump_batch_lines l set
239: l.pval002 = decode(c.p2,null,cn,c.p2),
240: l.pval003 = decode(c.p3,null,cn,c.p3),
241: l.pval007 = decode(c.p7,null,cn,c.p7),
242: l.pval008 = decode(c.p8,null,cn,dc(c.p8)),