DBA Data[Home] [Help]

APPS.JAI_PA_COSTING_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 67: pn_transaction_dist_id in number, /* One of PO_REQ_DISTRIBUTIONS_ALL.distribution_id, PO_DISTRIBUTIONS_ALL.po_distribution_id, RCV_TRANSACTIONS.transaction_id, AP_INVOICE_DISTRIBUTIONS_ALL.invoice_distribution_id */

63:
64: pv_transaction_source in varchar2,
65: pv_line_type in varchar2,
66: pn_transaction_header_id in number,
67: pn_transaction_dist_id in number, /* One of PO_REQ_DISTRIBUTIONS_ALL.distribution_id, PO_DISTRIBUTIONS_ALL.po_distribution_id, RCV_TRANSACTIONS.transaction_id, AP_INVOICE_DISTRIBUTIONS_ALL.invoice_distribution_id */
68: pv_currency_of_return_tax_amt in varchar2 default null, /* no value is passed, then tax amount in transaction currency is returned */
69: pv_transaction_uom in varchar2 default null, /* if not given, then conversion of UOM w.r.to main transaction will not be performed */
70: pn_transaction_qty in number default null,
71: pn_currency_conv_rate in number default null

Line 99: from po_distributions_all

95: r_get_reqn_line_dtl c_get_reqn_line_dtl%rowtype;
96:
97: cursor c_get_po_dist_dtl(pn_po_dist_id in number) is
98: select line_location_id, quantity_ordered
99: from po_distributions_all
100: where po_distribution_id = pn_po_dist_id;
101: r_get_po_dist_dtl c_get_po_dist_dtl%rowtype;
102:
103: cursor c_get_po_line_loc_dtl(pn_line_loc_id in number) is