DBA Data[Home] [Help]

APPS.JAI_RCV_TRX_PROCESSING_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 130: So a new parameter is added, which is used to pick the accrue_on_receipt_flag from po_line_locations_all table

126: Bug#4215402
127: Signature of the function get_accrue_on_receipt is modified to accept po_line_location_id also, because there
128: can be cases where a call to this procedure can pass a null value for po_distribution_id and thus returns a
129: wrong value to caller. this happens in case of receiving of non inventory items.
130: So a new parameter is added, which is used to pick the accrue_on_receipt_flag from po_line_locations_all table
131: if po_distribution_id is null
132:
133: 9 19/03/2005 Vijay Shankar for Bug#4250236(4245089). FileVersion: 115.8
134: .added two new parameter in validate_transaction to hold the process_vat flag and message.

Line 4931: FROM po_line_locations_all

4927:
4928: /* added by Vijay Shankar for Bug#4215402 */
4929: CURSOR c_po_shipment_dtl(cp_po_line_location_id IN NUMBER) IS
4930: SELECT accrue_on_receipt_flag
4931: FROM po_line_locations_all
4932: WHERE line_location_id = cp_po_line_location_id;
4933:
4934: lv_accrue_on_receipt_flag po_line_locations_all.accrue_on_receipt_flag%TYPE;
4935:

Line 4934: lv_accrue_on_receipt_flag po_line_locations_all.accrue_on_receipt_flag%TYPE;

4930: SELECT accrue_on_receipt_flag
4931: FROM po_line_locations_all
4932: WHERE line_location_id = cp_po_line_location_id;
4933:
4934: lv_accrue_on_receipt_flag po_line_locations_all.accrue_on_receipt_flag%TYPE;
4935:
4936: BEGIN
4937:
4938: IF p_po_distribution_id IS NOT NULL THEN