DBA Data[Home] [Help]

APPS.PA_PO_INTEGRATION_UTILS dependencies on PA_PLSQL_DATATYPES

Line 195: l_rcv_txn_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

191: l_rcv_transaction_id1 NUMBER(15);
192: l_po_dist_id NUMBER(15);
193: l_num_rows NUMBER(15):=0;
194:
195: l_rcv_txn_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
196: l_po_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
197: l_rcv_acct_evt_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes
198:
199:

Line 196: l_po_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

192: l_po_dist_id NUMBER(15);
193: l_num_rows NUMBER(15):=0;
194:
195: l_rcv_txn_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
196: l_po_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
197: l_rcv_acct_evt_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes
198:
199:
200: CURSOR net_zero_po_proj (p_transaction_id IN number) IS /* Modified the cursor query for Bug 5585218 */

Line 197: l_rcv_acct_evt_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes

193: l_num_rows NUMBER(15):=0;
194:
195: l_rcv_txn_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
196: l_po_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
197: l_rcv_acct_evt_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes
198:
199:
200: CURSOR net_zero_po_proj (p_transaction_id IN number) IS /* Modified the cursor query for Bug 5585218 */
201: SELECT /*+ leading(rcv_txn) index(rcvsub RCV_RECEIVING_SUB_LEDGER_N1) */ rcv_txn.transaction_id /*4338075*/