eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_DI_DOC_INDEX_PUB dependencies on AHL_DI_DOC_INDEX_PVT

Line 146: l_document_tbl AHL_DI_DOC_INDEX_PVT.document_tbl;

142: l_revision_status_code VARCHAR2(30);
143: l_copy_type_code VARCHAR2(30);
144: l_operator_code VARCHAR2(30);
145: l_product_type_code VARCHAR2(30);
146: l_document_tbl AHL_DI_DOC_INDEX_PVT.document_tbl;
147: -- l_revision_tbl AHL_DI_DOC_REVISION_PVT.revision_tbl;
148: -- l_revision_copy_tbl AHL_DI_DOC_REVISION_PVT.revision_copy_tbl;
149: -- l_subscription_tbl AHL_DI_SUBSCRIPTION_PVT.subscription_tbl;
150: l_supplier_tbl AHL_DI_DOC_INDEX_PVT.supplier_tbl;

Line 150: l_supplier_tbl AHL_DI_DOC_INDEX_PVT.supplier_tbl;

146: l_document_tbl AHL_DI_DOC_INDEX_PVT.document_tbl;
147: -- l_revision_tbl AHL_DI_DOC_REVISION_PVT.revision_tbl;
148: -- l_revision_copy_tbl AHL_DI_DOC_REVISION_PVT.revision_copy_tbl;
149: -- l_subscription_tbl AHL_DI_SUBSCRIPTION_PVT.subscription_tbl;
150: l_supplier_tbl AHL_DI_DOC_INDEX_PVT.supplier_tbl;
151: l_recipient_tbl AHL_DI_DOC_INDEX_PVT.recipient_tbl;
152: l_init_msg_list VARCHAR2(10) := FND_API.G_TRUE;
153:
154:

Line 151: l_recipient_tbl AHL_DI_DOC_INDEX_PVT.recipient_tbl;

147: -- l_revision_tbl AHL_DI_DOC_REVISION_PVT.revision_tbl;
148: -- l_revision_copy_tbl AHL_DI_DOC_REVISION_PVT.revision_copy_tbl;
149: -- l_subscription_tbl AHL_DI_SUBSCRIPTION_PVT.subscription_tbl;
150: l_supplier_tbl AHL_DI_DOC_INDEX_PVT.supplier_tbl;
151: l_recipient_tbl AHL_DI_DOC_INDEX_PVT.recipient_tbl;
152: l_init_msg_list VARCHAR2(10) := FND_API.G_TRUE;
153:
154:
155: BEGIN

Line 411: IF ahl_di_doc_index_pvt.get_product_install_status('PO') IN ('N','L')

407: -- If Supplier Name is available
408: IF (p_x_supplier_tbl(i).supplier_number IS NOT NULL) AND
409: (p_x_supplier_tbl(i).supplier_number <> FND_API.G_MISS_CHAR)
410: THEN
411: IF ahl_di_doc_index_pvt.get_product_install_status('PO') IN ('N','L')
412: THEN
413: OPEN for_party_name(p_x_supplier_tbl(i).supplier_number);
414: FETCH for_party_name INTO l_supplier_id;
415: IF for_party_name%FOUND

Line 424: ELSIF ahl_di_doc_index_pvt.get_product_install_status('PO') IN ('I','S')

420: FND_MESSAGE.SET_TOKEN('SUPNAME',p_x_supplier_tbl(i).supplier_number);
421: FND_MSG_PUB.ADD;
422: END IF;
423: CLOSE for_party_name;
424: ELSIF ahl_di_doc_index_pvt.get_product_install_status('PO') IN ('I','S')
425: THEN
426: OPEN for_vendor_id(p_x_supplier_tbl(i).supplier_number);
427: FETCH for_vendor_id INTO l_supplier_id;
428: IF for_vendor_id%FOUND

Line 1104: AHL_DI_DOC_INDEX_PVT.CREATE_DOCUMENT(

1100: END IF;
1101: END IF;
1102: --}}adharia
1103:
1104: AHL_DI_DOC_INDEX_PVT.CREATE_DOCUMENT(
1105: p_api_version => 1.0,
1106: p_init_msg_list => p_init_msg_list,
1107: p_commit => p_commit,
1108: p_validate_only => p_validate_only,

Line 1421: l_document_tbl AHL_DI_DOC_INDEX_PVT.document_tbl;

1417: l_revision_status_code VARCHAR2(30);
1418: l_copy_type_code VARCHAR2(30);
1419: l_operator_code VARCHAR2(30);
1420: l_product_type_code VARCHAR2(30);
1421: l_document_tbl AHL_DI_DOC_INDEX_PVT.document_tbl;
1422: -- l_revision_tbl AHL_DI_DOC_REVISION_PVT.revision_tbl;
1423: -- l_revision_copy_tbl AHL_DI_DOC_REVISION_PVT.revision_copy_tbl;
1424: -- l_subscription_tbl AHL_DI_SUBSCRIPTION_PVT.subscription_tbl;
1425: l_supplier_tbl AHL_DI_DOC_INDEX_PVT.supplier_tbl;

Line 1425: l_supplier_tbl AHL_DI_DOC_INDEX_PVT.supplier_tbl;

1421: l_document_tbl AHL_DI_DOC_INDEX_PVT.document_tbl;
1422: -- l_revision_tbl AHL_DI_DOC_REVISION_PVT.revision_tbl;
1423: -- l_revision_copy_tbl AHL_DI_DOC_REVISION_PVT.revision_copy_tbl;
1424: -- l_subscription_tbl AHL_DI_SUBSCRIPTION_PVT.subscription_tbl;
1425: l_supplier_tbl AHL_DI_DOC_INDEX_PVT.supplier_tbl;
1426: l_recipient_tbl AHL_DI_DOC_INDEX_PVT.recipient_tbl;
1427: l_init_msg_list VARCHAR2(10) := FND_API.G_TRUE;
1428: l_subscription_id NUMBER;
1429: l_supplier_name VARCHAR2(360);

Line 1426: l_recipient_tbl AHL_DI_DOC_INDEX_PVT.recipient_tbl;

1422: -- l_revision_tbl AHL_DI_DOC_REVISION_PVT.revision_tbl;
1423: -- l_revision_copy_tbl AHL_DI_DOC_REVISION_PVT.revision_copy_tbl;
1424: -- l_subscription_tbl AHL_DI_SUBSCRIPTION_PVT.subscription_tbl;
1425: l_supplier_tbl AHL_DI_DOC_INDEX_PVT.supplier_tbl;
1426: l_recipient_tbl AHL_DI_DOC_INDEX_PVT.recipient_tbl;
1427: l_init_msg_list VARCHAR2(10) := FND_API.G_TRUE;
1428: l_subscription_id NUMBER;
1429: l_supplier_name VARCHAR2(360);
1430: l_prod_install_status VARCHAR2(30);

Line 1464: Select AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO')

1460: BEGIN
1461: IF AHL_DEBUG_PUB.G_FILE_DEBUG THEN
1462: AHL_DEBUG_PUB.debug( 'Fetching Product Installation Status','+DI+');
1463: END IF;
1464: Select AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO')
1465: into l_prod_install_status
1466: from dual;
1467: END;
1468:

Line 1726: IF ahl_di_doc_index_pvt.get_product_install_status('PO') IN ('N','L')

1722: -- If Supplier Name is available
1723: IF (p_x_supplier_tbl(i).supplier_number IS NOT NULL) AND
1724: (p_x_supplier_tbl(i).supplier_number <> FND_API.G_MISS_CHAR)
1725: THEN
1726: IF ahl_di_doc_index_pvt.get_product_install_status('PO') IN ('N','L')
1727: THEN
1728: OPEN for_party_name(p_x_supplier_tbl(i).supplier_number);
1729: FETCH for_party_name INTO l_supplier_id;
1730: IF for_party_name%FOUND

Line 1739: ELSIF ahl_di_doc_index_pvt.get_product_install_status('PO') IN ('I','S')

1735: FND_MESSAGE.SET_TOKEN('SUPNAME',p_x_supplier_tbl(i).supplier_number);
1736: FND_MSG_PUB.ADD;
1737: END IF;
1738: CLOSE for_party_name;
1739: ELSIF ahl_di_doc_index_pvt.get_product_install_status('PO') IN ('I','S')
1740: THEN
1741: OPEN for_vendor_id(p_x_supplier_tbl(i).supplier_number);
1742: FETCH for_vendor_id INTO l_supplier_id;
1743: IF for_vendor_id%FOUND

Line 2044: AHL_DI_DOC_INDEX_PVT.MODIFY_DOCUMENT

2040: END IF;
2041: END IF;
2042: --{{adharia
2043:
2044: AHL_DI_DOC_INDEX_PVT.MODIFY_DOCUMENT
2045: (
2046: p_api_version => 1.0,
2047: p_init_msg_list => p_init_msg_list,
2048: p_commit => p_commit,