[Home] [Help]
90: ,P_ORG_STRUCTURE_USER_KEY in varchar2) 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: ,pval008
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: ,2255
120: ,'U'
121: ,p_user_sequence
150: l.pval008 p8,
151: l.pval009 p9,
152: l.pval010 p10,
153: decode(l.pval011,cn,vn,l.pval011) p11
154: from hr_pump_batch_lines l
155: where l.batch_line_id = p_batch_line_id;
156: --
157: c cr%rowtype;
158: l_validate boolean := false;
168: open cr;
169: fetch cr into c;
170: if cr%notfound then
171: hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
172: hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
173: hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
174: hr_utility.set_message_token('VALUE',p_batch_line_id);
175: hr_utility.raise_error;
176: end if;
218: else
219: c.p10 := 'FALSE';
220: end if;
221: --
222: update hr_pump_batch_lines l set
223: l.pval008 = decode(c.p8,null,cn,c.p8),
224: l.pval009 = decode(c.p9,null,cn,c.p9),
225: l.pval010 = decode(c.p10,null,cn,c.p10)
226: where l.rowid = c.myrowid;