223: l_resp_appl_id,
224: p_eff_from_date,
225: p_eff_to_date,
226: sysdate,
227: fnd_global.user_id,
228: sysdate,
229: fnd_global.user_id,
230: fnd_global.user_id;
231:
225: p_eff_to_date,
226: sysdate,
227: fnd_global.user_id,
228: sysdate,
229: fnd_global.user_id,
230: fnd_global.user_id;
231:
232: EXCEPTION
233: when others then
226: sysdate,
227: fnd_global.user_id,
228: sysdate,
229: fnd_global.user_id,
230: fnd_global.user_id;
231:
232: EXCEPTION
233: when others then
234: raise_application_error(-20000,sqlerrm||':'||v_statement ||
285: EXECUTE IMMEDIATE v_statement USING
286: p_eff_from_date,
287: p_eff_to_date,
288: sysdate,
289: fnd_global.user_id,
290: fnd_global.user_id,
291: p_responsibility_id,
292: p_organization_id,
293: p_sr_instance_id,
286: p_eff_from_date,
287: p_eff_to_date,
288: sysdate,
289: fnd_global.user_id,
290: fnd_global.user_id,
291: p_responsibility_id,
292: p_organization_id,
293: p_sr_instance_id,
294: l_resp_appl_id;
295: else
296: EXECUTE IMMEDIATE v_statement USING
297: p_eff_to_date,
298: sysdate,
299: fnd_global.user_id,
300: fnd_global.user_id,
301: p_responsibility_id,
302: p_organization_id,
303: p_sr_instance_id,
296: EXECUTE IMMEDIATE v_statement USING
297: p_eff_to_date,
298: sysdate,
299: fnd_global.user_id,
300: fnd_global.user_id,
301: p_responsibility_id,
302: p_organization_id,
303: p_sr_instance_id,
304: l_resp_appl_id;