236: l_resp_appl_id,
237: p_eff_from_date,
238: p_eff_to_date,
239: sysdate,
240: fnd_global.user_id,
241: sysdate,
242: fnd_global.user_id,
243: fnd_global.user_id;
244:
238: p_eff_to_date,
239: sysdate,
240: fnd_global.user_id,
241: sysdate,
242: fnd_global.user_id,
243: fnd_global.user_id;
244:
245: EXCEPTION
246: when others then
239: sysdate,
240: fnd_global.user_id,
241: sysdate,
242: fnd_global.user_id,
243: fnd_global.user_id;
244:
245: EXCEPTION
246: when others then
247: raise_application_error(-20000,sqlerrm||':'||v_statement ||
298: EXECUTE IMMEDIATE v_statement USING
299: p_eff_from_date,
300: p_eff_to_date,
301: sysdate,
302: fnd_global.user_id,
303: fnd_global.user_id,
304: p_responsibility_id,
305: p_organization_id,
306: p_sr_instance_id,
299: p_eff_from_date,
300: p_eff_to_date,
301: sysdate,
302: fnd_global.user_id,
303: fnd_global.user_id,
304: p_responsibility_id,
305: p_organization_id,
306: p_sr_instance_id,
307: l_resp_appl_id;
308: else
309: EXECUTE IMMEDIATE v_statement USING
310: p_eff_to_date,
311: sysdate,
312: fnd_global.user_id,
313: fnd_global.user_id,
314: p_responsibility_id,
315: p_organization_id,
316: p_sr_instance_id,
309: EXECUTE IMMEDIATE v_statement USING
310: p_eff_to_date,
311: sysdate,
312: fnd_global.user_id,
313: fnd_global.user_id,
314: p_responsibility_id,
315: p_organization_id,
316: p_sr_instance_id,
317: l_resp_appl_id;