416: RAISE e_objtype;
417: END;
418:
419: /* Get the profile option start/end dates */
420: v_profile_start_value := fnd_profile.value_specific (
421: 'FEM_EFFECTIVE_START_DATE'
422: ,fnd_global.user_id
423: ,fnd_global.resp_id
424: ,fnd_global.prog_appl_id);
423: ,fnd_global.resp_id
424: ,fnd_global.prog_appl_id);
425:
426:
427: v_profile_end_value := fnd_profile.value_specific (
428: 'FEM_EFFECTIVE_END_DATE'
429: ,fnd_global.user_id
430: ,fnd_global.resp_id
431: ,fnd_global.prog_appl_id);
1528: FROM fem_object_definition_vl
1529: WHERE object_definition_id = v_seeded_dflt_obj_def_id;
1530:
1531: /* Get the profile option start/end dates */
1532: v_profile_start_value := fnd_profile.value_specific (
1533: 'FEM_EFFECTIVE_START_DATE'
1534: ,fnd_global.user_id
1535: ,fnd_global.resp_id
1536: ,fnd_global.prog_appl_id);
1535: ,fnd_global.resp_id
1536: ,fnd_global.prog_appl_id);
1537:
1538:
1539: v_profile_end_value := fnd_profile.value_specific (
1540: 'FEM_EFFECTIVE_END_DATE'
1541: ,fnd_global.user_id
1542: ,fnd_global.resp_id
1543: ,fnd_global.prog_appl_id);