DBA Data[Home] [Help]

APPS.ZX_ON_FLY_TRX_UPGRADE_AR_PKG dependencies on FND_PRODUCT_GROUPS

Line 40: SELECT NVL(multi_org_flag, 'N') INTO l_multi_org_flag FROM FND_PRODUCT_GROUPS;

36: 'ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly_ar(+)');
37: END IF;
38: x_return_status := FND_API.G_RET_STS_SUCCESS;
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

Line 1824: SELECT NVL(multi_org_flag, 'N') INTO l_multi_org_flag FROM FND_PRODUCT_GROUPS;

1820: 'ZX_ON_FLY_TRX_UPGRADE_AR_PKG.upgrade_trx_on_fly_blk_ar(+)');
1821: END IF;
1822:
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