DBA Data[Home] [Help]

APPS.ZX_EVNT_OPTIONS_MIGRATE_PKG dependencies on FND_PRODUCT_GROUPS

Line 14: l_multi_org_flag fnd_product_groups.multi_org_flag%type;

10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(250):= 'ZX.PLSQL.ZX_EVNT_OPTIONS_MIGRATE_PKG.';
13:
14: l_multi_org_flag fnd_product_groups.multi_org_flag%type;
15: l_org_id NUMBER(15);
16:
17:
18: PROCEDURE AP_OPTIONS_MIGRATE (x_return_status OUT NOCOPY VARCHAR2) IS

Line 448: FROM FND_PRODUCT_GROUPS;

444: BEGIN
445:
446: SELECT NVL(MULTI_ORG_FLAG,'N')
447: INTO L_MULTI_ORG_FLAG
448: FROM FND_PRODUCT_GROUPS;
449:
450: IF L_MULTI_ORG_FLAG = 'N' THEN
451: FND_PROFILE.GET('ORG_ID',L_ORG_ID);
452: IF L_ORG_ID IS NULL THEN