DBA Data[Home] [Help]

APPS.OE_ADV_PRICE_PVT dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 1009: l_org ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;

1005: l_return_status varchar2(1);
1006: --
1007: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1008: --
1009: l_org ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;
1010: l_modifier QP_LIST_HEADERS_TL.NAME%TYPE;
1011: l_list_line_no QP_LIST_LINES.LIST_LINE_NO%TYPE;
1012: Begin
1013: IF l_debug_level > 0 THEN

Line 1148: FROM ORG_ORGANIZATION_DEFINITIONS

1144: FND_MESSAGE.SET_TOKEN('ITEM', l_line_rec.inventory_item_id);
1145: BEGIN
1146: SELECT ORGANIZATION_NAME
1147: INTO l_org
1148: FROM ORG_ORGANIZATION_DEFINITIONS
1149: WHERE ORGANIZATION_ID = l_org_id;
1150: EXCEPTION WHEN OTHERS THEN
1151: l_org := l_org_id;
1152: END;