DBA Data[Home] [Help]

APPS.ZX_ON_FLY_TRX_UPGRADE_AR_PKG dependencies on FND_PROFILE

Line 43: FND_PROFILE.GET('ORG_ID',l_org_id);

39:
40: SELECT NVL(multi_org_flag, 'N') INTO l_multi_org_flag FROM FND_PRODUCT_GROUPS;
41: -- for single org environment, get value of org_id from profile
42: IF l_multi_org_flag = 'N' THEN
43: FND_PROFILE.GET('ORG_ID',l_org_id);
44: IF l_org_id is NULL THEN
45: l_org_id := -99;
46: END IF;
47: END IF;

Line 1827: FND_PROFILE.GET('ORG_ID',l_org_id);

1823: x_return_status := FND_API.G_RET_STS_SUCCESS;
1824: SELECT NVL(multi_org_flag, 'N') INTO l_multi_org_flag FROM FND_PRODUCT_GROUPS;
1825: -- for single org environment, get value of org_id from profile
1826: IF l_multi_org_flag = 'N' THEN
1827: FND_PROFILE.GET('ORG_ID',l_org_id);
1828: IF l_org_id is NULL THEN
1829: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1830: FND_LOG.STRING(g_level_unexpected,
1831: 'ZX.PLSQL.ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_blk_ar',