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_SUBSCRIPTION_PUB dependencies on AHL_DI_DOC_INDEX_PVT

Line 188: IF ahl_di_doc_index_pvt.get_product_install_status('PER') in ('N','L') THEN

184: -- Party Name is present
185: IF (p_x_subscription_tbl(i).requested_by_pty_name IS NOT NULL)
186: THEN
187:
188: IF ahl_di_doc_index_pvt.get_product_install_status('PER') in ('N','L') THEN
189: -- Use cursor to retrieve party id using party name: party id will be unique for given party name
190: OPEN for_party_name(p_x_subscription_tbl(i).requested_by_pty_name);
191: FETCH for_party_name INTO l_requested_by_party_id;
192: IF for_party_name%FOUND THEN

Line 200: ELSIF ahl_di_doc_index_pvt.get_product_install_status('PER') in ('I','S') THEN

196: FND_MSG_PUB.ADD;
197: END IF;
198: CLOSE for_party_name;
199:
200: ELSIF ahl_di_doc_index_pvt.get_product_install_status('PER') in ('I','S') THEN
201: -- If party id is already present, use it; if not, retrieve using party name
202: -- Use cursor to retrieve party id using party name: party id may not be unique for given party name
203: OPEN get_party_name(p_x_subscription_tbl(i).requested_by_pty_name);
204: LOOP

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

239: -- Party Name is present, retrieve party id from party name
240: IF (p_x_subscription_tbl(i).subscribed_frm_pty_name IS NOT NULL)
241: THEN
242:
243: IF ahl_di_doc_index_pvt.get_product_install_status('PO') IN ('N','L') THEN
244: OPEN for_party_name(p_x_subscription_tbl(i).subscribed_frm_pty_name);
245: FETCH for_party_name INTO l_supplier_id;
246: IF for_party_name%FOUND
247: THEN

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

251: FND_MSG_PUB.ADD;
252: END IF;
253: CLOSE for_party_name;
254:
255: ELSIF ahl_di_doc_index_pvt.get_product_install_status('PO') IN ('I','S') THEN
256: OPEN for_vendor_id(p_x_subscription_tbl(i).subscribed_frm_pty_name);
257: FETCH for_vendor_id INTO l_supplier_id;
258: IF for_vendor_id%FOUND
259: THEN

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

383:
384: IF p_x_subscription_tbl(i).purchase_order_no IS NOT NULL
385: THEN
386:
387: IF ahl_di_doc_index_pvt.get_product_install_status('PO') in ('I','S')THEN
388: OPEN for_ponumber_id(p_x_subscription_tbl(i).purchase_order_no);
389: FETCH for_ponumber_id INTO l_purchase_order_no;
390: IF for_ponumber_id%FOUND THEN
391: l_subscription_tbl(i).purchase_order_no := l_purchase_order_no;

Line 398: ELSIF ahl_di_doc_index_pvt.get_product_install_status('PO') in ('N','L')THEN

394: FND_MSG_PUB.ADD;
395: END IF;
396: CLOSE for_ponumber_id;
397:
398: ELSIF ahl_di_doc_index_pvt.get_product_install_status('PO') in ('N','L')THEN
399: l_subscription_tbl(i).purchase_order_no := p_x_subscription_tbl(i).purchase_order_no;
400: END IF;
401:
402: END IF;

Line 838: IF ahl_di_doc_index_pvt.get_product_install_status('PER') in ('N','L') THEN

834: -- Party Name is present
835: IF (p_x_subscription_tbl(i).requested_by_pty_name IS NOT NULL)
836: THEN
837:
838: IF ahl_di_doc_index_pvt.get_product_install_status('PER') in ('N','L') THEN
839: -- Use cursor to retrieve party id using party name: party id will be unique for given party name
840: OPEN for_party_name(p_x_subscription_tbl(i).requested_by_pty_name);
841: FETCH for_party_name INTO l_requested_by_party_id;
842: IF for_party_name%FOUND THEN

Line 850: ELSIF ahl_di_doc_index_pvt.get_product_install_status('PER') in ('I','S') THEN

846: FND_MSG_PUB.ADD;
847: END IF;
848: CLOSE for_party_name;
849:
850: ELSIF ahl_di_doc_index_pvt.get_product_install_status('PER') in ('I','S') THEN
851: -- If party id and name are present, retrieve party id using both
852: OPEN get_party_name_id (p_x_subscription_tbl(i).requested_by_pty_name, p_x_subscription_tbl(i).requested_by_party_id);
853: FETCH get_party_name_id INTO l_requested_by_party_id;
854: -- If 1 record retrieved then party id and name match, use party id

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

899: -- Party Name is available
900:
901: IF (p_x_subscription_tbl(i).subscribed_frm_pty_name IS NOT NULL)
902: THEN
903: IF ahl_di_doc_index_pvt.get_product_install_status('PO') IN ('N','L') THEN
904: OPEN for_party_name(p_x_subscription_tbl(i).subscribed_frm_pty_name);
905: FETCH for_party_name INTO l_supplier_id;
906: IF for_party_name%FOUND
907: THEN

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

911: FND_MSG_PUB.ADD;
912: END IF;
913: CLOSE for_party_name;
914:
915: ELSIF ahl_di_doc_index_pvt.get_product_install_status('PO') IN ('I','S') THEN
916: OPEN for_vendor_id(p_x_subscription_tbl(i).subscribed_frm_pty_name);
917: FETCH for_vendor_id INTO l_supplier_id;
918: IF for_vendor_id%FOUND
919: THEN

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

1045:
1046: IF p_x_subscription_tbl(i).purchase_order_no IS NOT NULL
1047: THEN
1048:
1049: IF ahl_di_doc_index_pvt.get_product_install_status('PO') in ('I','S')THEN
1050:
1051:
1052: OPEN for_ponumber_id(p_x_subscription_tbl(i).purchase_order_no);
1053: FETCH for_ponumber_id INTO l_purchase_order_no;

Line 1066: ELSIF ahl_di_doc_index_pvt.get_product_install_status('PO') in ('N','L')THEN

1062: END IF;
1063: END IF;
1064: CLOSE for_ponumber_id;
1065:
1066: ELSIF ahl_di_doc_index_pvt.get_product_install_status('PO') in ('N','L')THEN
1067:
1068: l_subscription_tbl(i).purchase_order_no := p_x_subscription_tbl(i).purchase_order_no;
1069: END IF;
1070: END IF;