DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on PJM_UNIT_EFF

Line 5685: IF (NVL(PJM_UNIT_EFF.ENABLED,'N') = 'Y') THEN

5681: BEGIN
5682:
5683: -- WHENEVER NOT FOUND CONTINUE;
5684:
5685: IF (NVL(PJM_UNIT_EFF.ENABLED,'N') = 'Y') THEN
5686: IF (PJM_UNIT_EFF.UNIT_EFFECTIVE_ITEM(p_itemid,p_orgid) = 'Y') THEN
5687: IF (p_srctype = 3 AND p_acttype in(3,21) AND p_unit_number IS NOT NULL) then
5688: l_unit_no_ok := 0;
5689: SELECT count(1) INTO l_unit_no_ok

Line 5686: IF (PJM_UNIT_EFF.UNIT_EFFECTIVE_ITEM(p_itemid,p_orgid) = 'Y') THEN

5682:
5683: -- WHENEVER NOT FOUND CONTINUE;
5684:
5685: IF (NVL(PJM_UNIT_EFF.ENABLED,'N') = 'Y') THEN
5686: IF (PJM_UNIT_EFF.UNIT_EFFECTIVE_ITEM(p_itemid,p_orgid) = 'Y') THEN
5687: IF (p_srctype = 3 AND p_acttype in(3,21) AND p_unit_number IS NOT NULL) then
5688: l_unit_no_ok := 0;
5689: SELECT count(1) INTO l_unit_no_ok
5690: FROM PJM_UNIT_NUMBERS_LOV_V