APPS.AHL_DI_DOC_INDEX_PVT dependencies on DUAL

Line 569: l_document_id from DUAL;

565: CLOSE unique_rec;
566: -- Get the sequence number
567:
568: SELECT AHL_DOCUMENTS_B_S.Nextval INTO
569: l_document_id from DUAL;
570: /*-------------------------------------------------------- */
571: /* procedure name: AHL_DI_DOCUMENTS_PKG.INSERT_ROW */
572: /* description : Added by Senthil to call Table Handler */
573: /* Date : Dec 07 2001 */

Line 1236: FROM DUAL;

1232: AHL_DEBUG_PUB.debug( 'Fetching Installation Status of PO','+SUP+');
1233: END IF;
1234: SELECT AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO')
1235: INTO l_prod_install_status
1236: FROM DUAL;
1237: END;
1238:
1239: --When the process is insert or update(FLAG <> 'YES')
1240: IF p_delete_flag <> 'Y'

Line 1434: FROM DUAL;

1430: AHL_DEBUG_PUB.debug( 'Fetching Installation Status of P0','+SUP+');
1431: END IF;
1432: SELECT AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO')
1433: INTO l_prod_install_status
1434: FROM DUAL;
1435: END;
1436:
1437: --Start API Body
1438: IF p_x_supplier_tbl.COUNT > 0

Line 1513: l_supplier_document_id from DUAL;

1509:
1510: ELSE
1511: --Retrieve the sequence number
1512: SELECT AHL_SUPPLIER_DOCUMENTS_S.Nextval INTO
1513: l_supplier_document_id from DUAL;
1514: --Insert the record into supplier documents table
1515: INSERT INTO AHL_SUPPLIER_DOCUMENTS
1516: (
1517: SUPPLIER_DOCUMENT_ID,

Line 1792: FROM DUAL;

1788: AHL_DEBUG_PUB.debug( 'Fetching Installation Status of PO','+SUP+');
1789: END IF;
1790: SELECT AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO')
1791: INTO l_prod_install_status
1792: FROM DUAL;
1793: END;
1794:
1795: IF p_supplier_tbl.COUNT > 0
1796: THEN

Line 2159: FROM DUAL;

2155: AHL_DEBUG_PUB.debug( 'Fetching Product Install Status for PO');
2156: END IF;
2157: SELECT AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO')
2158: INTO l_prod_install_status
2159: FROM DUAL;
2160: END;
2161:
2162: --IF p_supplier_tbl.COUNT > 0
2163: --THEN

Line 2560: l_recipient_document_id from DUAL;

2556: --ad CLOSE dup_rec;
2557: else --ad
2558: --Retrieves the sequence number
2559: SELECT AHL_RECIPIENT_DOCUMENTS_S.Nextval INTO
2560: l_recipient_document_id from DUAL;
2561: --Insert the record into recipient documents
2562: INSERT INTO AHL_RECIPIENT_DOCUMENTS
2563: (
2564: RECIPIENT_DOCUMENT_ID,