APPS.AHL_DI_SUBSCRIPTION_PVT dependencies on AHL_DI_DOC_INDEX_PVT

Line 187: SELECT AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER')

183: BEGIN
184: IF G_DEBUG='Y' THEN
185: AHL_DEBUG_PUB.debug( 'Fetching Installation Status of PER','+SUB+');
186: END IF;
187: SELECT AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER')
188: INTO l_prod_install_status
189: FROM DUAL;
190: END;
191:

Line 315: IF ahl_di_doc_index_pvt.get_product_install_status('PO') in ('I','S')THEN

311:
312: IF p_purchase_order_no IS NOT NULL
313: THEN
314:
315: IF ahl_di_doc_index_pvt.get_product_install_status('PO') in ('I','S')THEN
316: OPEN for_ponumber_id(p_purchase_order_no);
317: FETCH for_ponumber_id INTO l_purchase_order_no;
318: IF for_ponumber_id%NOTFOUND THEN
319: FND_MESSAGE.SET_NAME('AHL','AHL_DI_PO_NUM_NOT_EXISTS');

Line 1061: SELECT AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER')

1057: BEGIN
1058: IF G_DEBUG='Y' THEN
1059: AHL_DEBUG_PUB.debug( 'Fetching Installation Status of PER','+SUB+');
1060: END IF;
1061: SELECT AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER')
1062: INTO l_prod_install_status
1063: FROM DUAL;
1064: END;
1065: