DBA Data[Home] [Help]

APPS.AHL_OSP_PO_REQ_PVT dependencies on PO_LINE_TYPES

Line 41: -- PO Line Types

37: G_DEFAULT_PRICE CONSTANT NUMBER := 0;
38: G_DEFAULT_CATEGORY_SEG1 CONSTANT VARCHAR2(40) := 'MISC';
39: G_DEFAULT_CATEGORY_SEG2 CONSTANT VARCHAR2(40) := 'MISC';
40:
41: -- PO Line Types
42: G_PO_LINE_TYPE_QUANTITY CONSTANT VARCHAR2(30) := 'QUANTITY';
43:
44: -------------------------------------------------
45: -- Declare Locally used Record and Table Types --

Line 1266: SELECT 'x' FROM PO_LINE_TYPES

1262: AND ORGANIZATION_ID = p_org_id
1263: AND NVL(OUTSIDE_OPERATION_FLAG, G_NO_FLAG) = G_NO_FLAG;
1264:
1265: CURSOR l_validate_line_type_csr(p_line_type_id IN NUMBER) IS
1266: SELECT 'x' FROM PO_LINE_TYPES
1267: WHERE ORDER_TYPE_LOOKUP_CODE = G_PO_LINE_TYPE_QUANTITY
1268: AND NVL(OUTSIDE_OPERATION_FLAG, G_NO_FLAG) = G_NO_FLAG
1269: AND LINE_TYPE_ID = p_line_type_id;
1270: