DBA Data[Home] [Help]

APPS.PA_PO_INTEGRATION_UTILS dependencies on PA_PLSQL_DATATYPES

Line 157: l_rcv_txn_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

153: l_rcv_transaction_id1 NUMBER(15);
154: l_po_dist_id NUMBER(15);
155: l_num_rows NUMBER(15):=0;
156:
157: l_rcv_txn_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
158: l_po_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
159: l_rcv_acct_evt_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes
160:
161:

Line 158: l_po_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

154: l_po_dist_id NUMBER(15);
155: l_num_rows NUMBER(15):=0;
156:
157: l_rcv_txn_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
158: l_po_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
159: l_rcv_acct_evt_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes
160:
161:
162: CURSOR net_zero_po_proj (p_transaction_id IN number) IS /* Modified the cursor query for Bug 5585218 */

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

155: l_num_rows NUMBER(15):=0;
156:
157: l_rcv_txn_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
158: l_po_dist_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
159: l_rcv_acct_evt_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes
160:
161:
162: CURSOR net_zero_po_proj (p_transaction_id IN number) IS /* Modified the cursor query for Bug 5585218 */
163: SELECT /*+ leading(rcv_txn) index(rcvsub RCV_RECEIVING_SUB_LEDGER_N1) */ rcv_txn.transaction_id /*4338075*/