DBA Data[Home] [Help]

APPS.INV_MATERIAL_STATUS_PKG dependencies on FND_PROFILE

Line 6: g_eres_enabled VARCHAR2(3) := NVL(fnd_profile.VALUE('EDR_ERES_ENABLED'), 'N');

2: /* $Header: INVMSPVB.pls 120.18.12020000.3 2012/09/11 10:36:34 rkatoori ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_MATERIAL_STATUS_PKG';
5: -- BEGIN SCHANDRU INVERES
6: g_eres_enabled VARCHAR2(3) := NVL(fnd_profile.VALUE('EDR_ERES_ENABLED'), 'N');
7: -- END SCHANDRU INVERES
8: FUNCTION status_assigned(p_status_id IN NUMBER) return Boolean
9: IS
10: count_assigned number := 0;

Line 277: l_multiple_app := NVL(FND_PROFILE.VALUE('INV_ERES_MULTIPLE_SIGNATURE'),0);--ERES Deferred

273: l_status_group_id NUMBER := 0;
274:
275:
276: BEGIN
277: l_multiple_app := NVL(FND_PROFILE.VALUE('INV_ERES_MULTIPLE_SIGNATURE'),0);--ERES Deferred
278: --BEGIN SCHANDRU INVERES
279: Select MTL_MATERIAL_STATUS_HISTORY_S.nextval
280: Into l_status_update_id
281: From dual;