DBA Data[Home] [Help]

APPS.OE_EXTERNAL_CREDIT_PVT dependencies on FND_PRODUCT_GROUPS

Line 110: l_multi_org_flag fnd_product_groups.multi_org_flag%TYPE;

106: , x_org_id OUT NOCOPY NUMBER
107: , x_return_status OUT NOCOPY VARCHAR2
108: )
109: IS
110: l_multi_org_flag fnd_product_groups.multi_org_flag%TYPE;
111: l_org_id NUMBER;
112: BEGIN
113: OE_DEBUG_PUB.Add('OEXVCECB: In Get_Operating_Unit_ID');
114: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 119: FROM fnd_product_groups;

115: --If the set is multi-org, then get the operating unit information, else
116: --return NULL for the org_id.
117: SELECT NVL(multi_org_flag, 'N')
118: INTO l_multi_org_flag
119: FROM fnd_product_groups;
120: --
121: --If both the ou name and org ID are provided, the ou name will be ignored.
122: --
123: IF l_multi_org_flag = 'Y' THEN