APPS.PO_CLM_COLS_SUB_CHECK dependencies on PO_HEADERS_ALL

Line 1458: FROM PO_HEADERS_ALL

1454: IF l_document_type_code = 'STANDARD' AND PO_CLM_CLO_UTIL.isCLMInstalled THEN
1455:
1456: SELECT NVL(clm_amount_released, 0), amount_limit
1457: INTO l_clm_amt_released, l_amount_limit
1458: FROM PO_HEADERS_ALL
1459: WHERE PO_HEADER_ID = l_idv_header_id;
1460:
1461: d_progress := 70;
1462: IF po_encumbrance_preprocessing.g_call_from_encumbrance <> 'Y' THEN

Line 1578: FROM PO_HEADERS_ALL

1574: );
1575:
1576: SELECT clm_max_order_amount, clm_min_order_amount
1577: INTO l_max_ord_amt, l_min_ord_amt
1578: FROM PO_HEADERS_ALL
1579: WHERE PO_HEADER_ID = l_idv_header_id;
1580:
1581: /*
1582: Bug 11676275:

Line 1711: FROM PO_HEADERS_ALL

1707: IF l_source_id IS NOT NULL THEN
1708:
1709: SELECT TYPE_LOOKUP_CODE
1710: INTO l_doc_type
1711: FROM PO_HEADERS_ALL
1712: WHERE PO_HEADER_ID = l_source_id;
1713:
1714: IF l_doc_type = 'BLANKET' THEN
1715:

Line 1852: FROM PO_HEADERS_ALL

1848: IF l_source_id IS NOT NULL THEN
1849:
1850: SELECT TYPE_LOOKUP_CODE
1851: INTO l_doc_type
1852: FROM PO_HEADERS_ALL
1853: WHERE PO_HEADER_ID = l_source_id;
1854:
1855: IF l_doc_type = 'BLANKET' THEN
1856: FOR c_get_po_lines_rec IN c_get_po_lines(p_document_id) LOOP

Line 2354: l_org_id PO_HEADERS_ALL.org_id%type;

2350: d_position NUMBER := 0;
2351: l_return_val NUMBER := 0;
2352: l_precision GL_CURRENCIES.precision%TYPE;
2353: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
2354: l_org_id PO_HEADERS_ALL.org_id%type;
2355: l_po_currency PO_HEADERS_ALL.currency_code%type;
2356: l_header_id NUMBER := NULL;
2357:
2358: BEGIN

Line 2355: l_po_currency PO_HEADERS_ALL.currency_code%type;

2351: l_return_val NUMBER := 0;
2352: l_precision GL_CURRENCIES.precision%TYPE;
2353: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
2354: l_org_id PO_HEADERS_ALL.org_id%type;
2355: l_po_currency PO_HEADERS_ALL.currency_code%type;
2356: l_header_id NUMBER := NULL;
2357:
2358: BEGIN
2359:

Line 2503: l_org_id PO_HEADERS_ALL.org_id%type;

2499: d_position NUMBER := 0;
2500: l_return_val NUMBER := 0;
2501: l_precision GL_CURRENCIES.precision%TYPE;
2502: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
2503: l_org_id PO_HEADERS_ALL.org_id%type;
2504: l_po_currency PO_HEADERS_ALL.currency_code%type;
2505: l_header_id NUMBER := NULL;
2506:
2507: BEGIN

Line 2504: l_po_currency PO_HEADERS_ALL.currency_code%type;

2500: l_return_val NUMBER := 0;
2501: l_precision GL_CURRENCIES.precision%TYPE;
2502: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
2503: l_org_id PO_HEADERS_ALL.org_id%type;
2504: l_po_currency PO_HEADERS_ALL.currency_code%type;
2505: l_header_id NUMBER := NULL;
2506:
2507: BEGIN
2508: