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:
28: BEGIN
29: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 38: SELECT multi_org_flag INTO l_multi_org_flag FROM fnd_product_groups;

34: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_ap(+)');
35: END IF;
36:
37: x_return_status := FND_API.G_RET_STS_SUCCESS;
38: SELECT multi_org_flag INTO l_multi_org_flag FROM fnd_product_groups;
39:
40: -- for single org environment, get value of org_id from profile
41: IF l_multi_org_flag = 'N' THEN
42: FND_PROFILE.GET('ORG_ID',l_org_id);

Line 2167: l_multi_org_flag fnd_product_groups.multi_org_flag%TYPE;

2163: PROCEDURE upgrade_trx_on_fly_blk_ap(
2164: x_return_status OUT NOCOPY VARCHAR2
2165: ) AS
2166:
2167: l_multi_org_flag fnd_product_groups.multi_org_flag%TYPE;
2168: l_org_id NUMBER;
2169:
2170: BEGIN
2171: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 2180: SELECT multi_org_flag INTO l_multi_org_flag FROM fnd_product_groups;

2176: 'ZX_ON_FLY_TRX_UPGRADE_AP_PKG.upgrade_trx_on_fly_blk_ap(+)');
2177: END IF;
2178:
2179: x_return_status := FND_API.G_RET_STS_SUCCESS;
2180: SELECT multi_org_flag INTO l_multi_org_flag FROM fnd_product_groups;
2181:
2182: -- for single org environment, get value of org_id from profile
2183: IF l_multi_org_flag = 'N' THEN
2184: FND_PROFILE.GET('ORG_ID',l_org_id);