DBA Data[Home] [Help]

APPS.JAI_PA_COSTING_PKG dependencies on PO_REQ_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 87: from po_req_distributions_all

83: lv_src_type_rtr VARCHAR2(50); --bgowrava for Bug#6452772
84:
85: cursor c_get_reqn_dist_dtl(pn_req_dist_id in number) is
86: select requisition_line_id, req_line_quantity
87: from po_req_distributions_all
88: where distribution_id = pn_req_dist_id;
89: r_get_reqn_dist_dtl c_get_reqn_dist_dtl%rowtype;
90:
91: cursor c_get_reqn_line_dtl(pn_req_line_id in number) is