65:
66: -----------------------
67: -- Package Constants --
68: -----------------------
69: c_resp_app_id CONSTANT NUMBER := FND_GLOBAL.RESP_APPL_ID;
70:
71: c_user_id CONSTANT NUMBER := FND_GLOBAL.USER_ID;
72: c_login_id NUMBER := FND_GLOBAL.Login_Id;
73:
67: -- Package Constants --
68: -----------------------
69: c_resp_app_id CONSTANT NUMBER := FND_GLOBAL.RESP_APPL_ID;
70:
71: c_user_id CONSTANT NUMBER := FND_GLOBAL.USER_ID;
72: c_login_id NUMBER := FND_GLOBAL.Login_Id;
73:
74: c_module_pkg CONSTANT VARCHAR2(80) := 'fem.plsql.fem_alloc_br_util_pkg';
75: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FEM_ALLOC_BR_UTIL_PKG';
68: -----------------------
69: c_resp_app_id CONSTANT NUMBER := FND_GLOBAL.RESP_APPL_ID;
70:
71: c_user_id CONSTANT NUMBER := FND_GLOBAL.USER_ID;
72: c_login_id NUMBER := FND_GLOBAL.Login_Id;
73:
74: c_module_pkg CONSTANT VARCHAR2(80) := 'fem.plsql.fem_alloc_br_util_pkg';
75: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FEM_ALLOC_BR_UTIL_PKG';
76:
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);
425:
426:
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);
425:
426:
427: v_profile_end_value := fnd_profile.value_specific (
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);
425:
426:
427: v_profile_end_value := fnd_profile.value_specific (
428: 'FEM_EFFECTIVE_END_DATE'
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);
432:
433: /* Try to get the date value from the profile option
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);
432:
433: /* Try to get the date value from the profile option
434: if date value no good, just use the sysdate for start
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);
432:
433: /* Try to get the date value from the profile option
434: if date value no good, just use the sysdate for start
435: and maxdate for end*/
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);
1537:
1538:
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);
1537:
1538:
1539: v_profile_end_value := fnd_profile.value_specific (
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);
1537:
1538:
1539: v_profile_end_value := fnd_profile.value_specific (
1540: 'FEM_EFFECTIVE_END_DATE'
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);
1544:
1545: /* Try to get the date value from the profile option
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);
1544:
1545: /* Try to get the date value from the profile option
1546: if date value no good, just use the sysdate for start
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);
1544:
1545: /* Try to get the date value from the profile option
1546: if date value no good, just use the sysdate for start
1547: and maxdate for end*/