DBA Data[Home] [Help]

APPS.OE_ADV_PRICE_PVT dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 1296: l_org ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;

1292: l_return_status varchar2(1);
1293: --
1294: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1295: --
1296: l_org ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;
1297: l_modifier QP_LIST_HEADERS_TL.NAME%TYPE;
1298: l_list_line_no QP_LIST_LINES.LIST_LINE_NO%TYPE;
1299: Begin
1300: IF l_debug_level > 0 THEN

Line 1445: FROM ORG_ORGANIZATION_DEFINITIONS

1441: FND_MESSAGE.SET_TOKEN('ITEM', l_line_rec.inventory_item_id);
1442: BEGIN
1443: SELECT ORGANIZATION_NAME
1444: INTO l_org
1445: FROM ORG_ORGANIZATION_DEFINITIONS
1446: WHERE ORGANIZATION_ID = l_org_id;
1447: EXCEPTION WHEN OTHERS THEN
1448: l_org := l_org_id;
1449: END;