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 1150: FROM DUAL;

1146: AHL_DEBUG_PUB.debug( 'Fetching Installation Status of PO','+SUP+');
1147: END IF;
1148: SELECT AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO')
1149: INTO l_prod_install_status
1150: FROM DUAL;
1151: END;
1152:
1153: --When the process is insert or update(FLAG <> 'YES')
1154: IF p_delete_flag <> 'Y'

Line 1348: FROM DUAL;

1344: AHL_DEBUG_PUB.debug( 'Fetching Installation Status of P0','+SUP+');
1345: END IF;
1346: SELECT AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO')
1347: INTO l_prod_install_status
1348: FROM DUAL;
1349: END;
1350:
1351: --Start API Body
1352: IF p_x_supplier_tbl.COUNT > 0

Line 1427: l_supplier_document_id from DUAL;

1423:
1424: ELSE
1425: --Retrieve the sequence number
1426: SELECT AHL_SUPPLIER_DOCUMENTS_S.Nextval INTO
1427: l_supplier_document_id from DUAL;
1428: --Insert the record into supplier documents table
1429: INSERT INTO AHL_SUPPLIER_DOCUMENTS
1430: (
1431: SUPPLIER_DOCUMENT_ID,

Line 1706: FROM DUAL;

1702: AHL_DEBUG_PUB.debug( 'Fetching Installation Status of PO','+SUP+');
1703: END IF;
1704: SELECT AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO')
1705: INTO l_prod_install_status
1706: FROM DUAL;
1707: END;
1708:
1709: IF p_supplier_tbl.COUNT > 0
1710: THEN

Line 2073: FROM DUAL;

2069: AHL_DEBUG_PUB.debug( 'Fetching Product Install Status for PO');
2070: END IF;
2071: SELECT AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO')
2072: INTO l_prod_install_status
2073: FROM DUAL;
2074: END;
2075:
2076: --IF p_supplier_tbl.COUNT > 0
2077: --THEN

Line 2474: l_recipient_document_id from DUAL;

2470: --ad CLOSE dup_rec;
2471: else --ad
2472: --Retrieves the sequence number
2473: SELECT AHL_RECIPIENT_DOCUMENTS_S.Nextval INTO
2474: l_recipient_document_id from DUAL;
2475: --Insert the record into recipient documents
2476: INSERT INTO AHL_RECIPIENT_DOCUMENTS
2477: (
2478: RECIPIENT_DOCUMENT_ID,