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_PRD_MTLTXN_PVT dependencies on AHL_OSP_UTIL_PKG

Line 5120: l_bind_value_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

5116: -- sracha: added for bug fix 6328554.
5117: l_index_start NUMBER;
5118:
5119: --pdoki added for Bug 9164678
5120: l_bind_value_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
5121: l_mtl_txns_returns_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
5122: l_bind_index NUMBER;
5123: l_mtl_txn_dtls VARCHAR2(10000);
5124: l_mtl_txn_dtls_where VARCHAR2(10000);

Line 5121: l_mtl_txns_returns_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

5117: l_index_start NUMBER;
5118:
5119: --pdoki added for Bug 9164678
5120: l_bind_value_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
5121: l_mtl_txns_returns_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
5122: l_bind_index NUMBER;
5123: l_mtl_txn_dtls VARCHAR2(10000);
5124: l_mtl_txn_dtls_where VARCHAR2(10000);
5125:

Line 5370: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR(l_mtl_txns_returns_cur, l_bind_value_tbl, l_mtl_txn_dtls);

5366: 'SQL Query String: ' || l_mtl_txn_dtls
5367: );
5368: END IF;
5369:
5370: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR(l_mtl_txns_returns_cur, l_bind_value_tbl, l_mtl_txn_dtls);
5371:
5372: l_index :=p_x_ahl_prd_mtl_txn_tbl.count;
5373: l_index_start := l_index;
5374:

Line 6176: l_bind_value_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

6172: l_junk varchar2(1);
6173: l_valid_flag BOOLEAN;
6174:
6175: -- pdoki added for Bug 9164678
6176: l_bind_value_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
6177: l_mtl_txns_returns_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
6178: l_bind_index NUMBER;
6179: l_mtl_txn_dtls VARCHAR2(10000);
6180: l_mtl_txn_dtls_where VARCHAR2(10000);

Line 6177: l_mtl_txns_returns_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

6173: l_valid_flag BOOLEAN;
6174:
6175: -- pdoki added for Bug 9164678
6176: l_bind_value_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
6177: l_mtl_txns_returns_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
6178: l_bind_index NUMBER;
6179: l_mtl_txn_dtls VARCHAR2(10000);
6180: l_mtl_txn_dtls_where VARCHAR2(10000);
6181:

Line 6316: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR(l_mtl_txns_returns_cur, l_bind_value_tbl, l_mtl_txn_dtls);

6312: 'SQL Query String: ' || l_mtl_txn_dtls
6313: );
6314: END IF;
6315:
6316: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR(l_mtl_txns_returns_cur, l_bind_value_tbl, l_mtl_txn_dtls);
6317:
6318:
6319: LOOP
6320: FETCH l_mtl_txns_returns_cur INTO l_mtlTxn_rec;

Line 6681: l_bind_value_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;

6677: l_index NUMBER := p_x_ahl_prd_mtl_txn_tbl.count;
6678: l_junk varchar2(1);
6679:
6680: --pdoki added for Bug 9164678
6681: l_bind_value_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
6682: l_mtl_txns_returns_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
6683: l_bind_index NUMBER;
6684: l_mtl_txn_dtls VARCHAR2(10000);
6685: l_mtl_txn_dtls_where VARCHAR2(10000);

Line 6682: l_mtl_txns_returns_cur AHL_OSP_UTIL_PKG.ahl_search_csr;

6678: l_junk varchar2(1);
6679:
6680: --pdoki added for Bug 9164678
6681: l_bind_value_tbl AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
6682: l_mtl_txns_returns_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
6683: l_bind_index NUMBER;
6684: l_mtl_txn_dtls VARCHAR2(10000);
6685: l_mtl_txn_dtls_where VARCHAR2(10000);
6686:

Line 6868: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR(l_mtl_txns_returns_cur, l_bind_value_tbl, l_mtl_txn_dtls);

6864: );
6865: END IF;
6866:
6867: -- execute query
6868: AHL_OSP_UTIL_PKG.OPEN_SEARCH_CURSOR(l_mtl_txns_returns_cur, l_bind_value_tbl, l_mtl_txn_dtls);
6869:
6870: LOOP
6871: FETCH l_mtl_txns_returns_cur INTO l_mtl_txn_rec;
6872: EXIT WHEN l_mtl_txns_returns_cur%NOTFOUND;