DBA Data[Home] [Help]

APPS.ZX_SBSCR_OPTIONS_MIGRATE_PKG dependencies on FND_PRODUCT_GROUPS

Line 15: L_MULTI_ORG_FLAG FND_PRODUCT_GROUPS.MULTI_ORG_FLAG%TYPE;

11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(250) := 'ZX.PLSQL.ZX_SBSCR_OPTIONS_MIGRATE_PKG.';
13:
14:
15: L_MULTI_ORG_FLAG FND_PRODUCT_GROUPS.MULTI_ORG_FLAG%TYPE;
16: L_ORG_ID NUMBER(15);
17:
18: PROCEDURE SBSCRPTN_OPTIONS_MIGRATE (x_return_status OUT NOCOPY VARCHAR2) IS
19:

Line 328: FND_PRODUCT_GROUPS;

324:
325: BEGIN
326:
327: SELECT NVL(MULTI_ORG_FLAG,'N') INTO L_MULTI_ORG_FLAG FROM
328: FND_PRODUCT_GROUPS;
329:
330: IF L_MULTI_ORG_FLAG = 'N' THEN
331:
332: FND_PROFILE.GET('ORG_ID',L_ORG_ID);