DBA Data[Home] [Help]

APPS.INV_FLEX_LOT_ALLOCATION_PUB dependencies on FND_PRODUCT_GROUPS

Line 38: SELECT RELEASE_NAME INTO L_RELEASE_NAME FROM FND_PRODUCT_GROUPS WHERE ROWNUM = 1;

34:
35: --If apps version is 12.1.x,12.2.0,12.2.1, Then keep original logic(Always Allocate Lot),Return Y
36: --Else(version = 12.2.2 or higher),return actual parameter value
37: BEGIN
38: SELECT RELEASE_NAME INTO L_RELEASE_NAME FROM FND_PRODUCT_GROUPS WHERE ROWNUM = 1;
39: print_debug('RELEASE_NAME:'||L_RELEASE_NAME);
40: EXCEPTION
41: WHEN OTHERS THEN
42: L_RELEASE_NAME := '12.1';