APPS.ZX_ON_FLY_TRX_UPGRADE_PO_PKG dependencies on FND_PRODUCT_GROUPS

Line 25: l_multi_org_flag fnd_product_groups.multi_org_flag%TYPE;

21: x_return_status OUT NOCOPY VARCHAR2
22: ) AS
23:
24: l_org_id NUMBER;
25: l_multi_org_flag fnd_product_groups.multi_org_flag%TYPE;
26:
27: BEGIN
28:
29: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 39: SELECT multi_org_flag INTO l_multi_org_flag FROM fnd_product_groups;

35: END IF;
36:
37: x_return_status := FND_API.G_RET_STS_SUCCESS;
38:
39: SELECT multi_org_flag INTO l_multi_org_flag FROM fnd_product_groups;
40:
41: IF NVL(l_multi_org_flag,'N') = 'N' THEN -- non- multi org
42: FND_PROFILE.GET('ORG_ID',l_org_id);
43: IF l_org_id is NULL THEN

Line 4731: l_multi_org_flag fnd_product_groups.multi_org_flag%TYPE;

4727: x_return_status OUT NOCOPY VARCHAR2
4728: ) AS
4729:
4730: l_org_id NUMBER;
4731: l_multi_org_flag fnd_product_groups.multi_org_flag%TYPE;
4732:
4733: BEGIN
4734:
4735: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 4745: SELECT multi_org_flag INTO l_multi_org_flag FROM fnd_product_groups;

4741: END IF;
4742:
4743: x_return_status := FND_API.G_RET_STS_SUCCESS;
4744:
4745: SELECT multi_org_flag INTO l_multi_org_flag FROM fnd_product_groups;
4746:
4747: IF NVL(l_multi_org_flag,'N') = 'N' THEN -- non- multi org
4748: FND_PROFILE.GET('ORG_ID',l_org_id);
4749: IF l_org_id is NULL THEN