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: l_estb_id NUMBER;
27:
28: BEGIN
29:

Line 40: SELECT multi_org_flag INTO l_multi_org_flag FROM fnd_product_groups;

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

Line 4821: l_multi_org_flag fnd_product_groups.multi_org_flag%TYPE;

4817: x_return_status OUT NOCOPY VARCHAR2
4818: ) AS
4819:
4820: l_org_id NUMBER;
4821: l_multi_org_flag fnd_product_groups.multi_org_flag%TYPE;
4822:
4823: BEGIN
4824:
4825: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 4835: SELECT multi_org_flag INTO l_multi_org_flag FROM fnd_product_groups;

4831: END IF;
4832:
4833: x_return_status := FND_API.G_RET_STS_SUCCESS;
4834:
4835: SELECT multi_org_flag INTO l_multi_org_flag FROM fnd_product_groups;
4836:
4837: IF NVL(l_multi_org_flag,'N') = 'N' THEN -- non- multi org
4838: FND_PROFILE.GET('ORG_ID',l_org_id);
4839: IF l_org_id is NULL THEN