APPS.ZX_ON_FLY_TRX_UPGRADE_AP_PKG dependencies on FND_PRODUCT_GROUPS

Line 25: l_multi_org_flag fnd_product_groups.multi_org_flag%TYPE;

21: p_upg_trx_info_rec IN ZX_ON_FLY_TRX_UPGRADE_PKG.zx_upg_trx_info_rec_type,
22: x_return_status OUT NOCOPY VARCHAR2
23: ) AS
24:
25: l_multi_org_flag fnd_product_groups.multi_org_flag%TYPE;
26: l_org_id NUMBER;
27: l_estb_id NUMBER;
28:
29: BEGIN

Line 39: SELECT multi_org_flag INTO l_multi_org_flag FROM fnd_product_groups;

35: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap(+)');
36: END IF;
37:
38: x_return_status := FND_API.G_RET_STS_SUCCESS;
39: SELECT multi_org_flag INTO l_multi_org_flag FROM fnd_product_groups;
40:
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);

Line 2216: l_multi_org_flag fnd_product_groups.multi_org_flag%TYPE;

2212: PROCEDURE upgrade_trx_on_fly_blk_ap(
2213: x_return_status OUT NOCOPY VARCHAR2
2214: ) AS
2215:
2216: l_multi_org_flag fnd_product_groups.multi_org_flag%TYPE;
2217: l_org_id NUMBER;
2218:
2219: BEGIN
2220: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 2229: SELECT multi_org_flag INTO l_multi_org_flag FROM fnd_product_groups;

2225: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap(+)');
2226: END IF;
2227:
2228: x_return_status := FND_API.G_RET_STS_SUCCESS;
2229: SELECT multi_org_flag INTO l_multi_org_flag FROM fnd_product_groups;
2230:
2231: -- for single org environment, get value of org_id from profile
2232: IF l_multi_org_flag = 'N' THEN
2233: FND_PROFILE.GET('ORG_ID',l_org_id);