DBA Data[Home] [Help]

APPS.JAI_PA_COSTING_PKG dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 90: 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 */

86:
87: pv_transaction_source in varchar2,
88: pv_line_type in varchar2,
89: pn_transaction_header_id in number,
90: 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 */
91: pv_currency_of_return_tax_amt in varchar2 default null, /* no value is passed, then tax amount in transaction currency is returned */
92: pv_transaction_uom in varchar2 default null, /* if not given, then conversion of UOM w.r.to main transaction will not be performed */
93: pn_transaction_qty in number default null,
94: pn_currency_conv_rate in number default null

Line 110: from po_req_distributions_all

106: lv_src_type_rtr VARCHAR2(50); --bgowrava for Bug#6452772
107:
108: cursor c_get_reqn_dist_dtl(pn_req_dist_id in number) is
109: select requisition_line_id, req_line_quantity
110: from po_req_distributions_all
111: where distribution_id = pn_req_dist_id;
112: r_get_reqn_dist_dtl c_get_reqn_dist_dtl%rowtype;
113:
114: cursor c_get_reqn_line_dtl(pn_req_line_id in number) is