APPS.INV_RCV_TXN_INTERFACE dependencies on RCV_PARAMETERS

Line 666: rcv_parameters rp

662: from po_line_locations_trx_v pll, -- CLM project, bug 9403291
663: po_lines_trx_v pl -- CLM project, bug 9403291
664: -- For Bug 7440217
665: , mtl_parameters mp,
666: rcv_parameters rp
667: -- End for Bug 7440217
668: -- Bug 3444226 The Join with po_headers is unnecessary
669: -- po_headers_all ph
670: -- where ph.po_header_id = header_id

Line 740: rcv_parameters rp

736: from po_line_locations_trx_v pll, -- CLM project, bug 9403291
737: po_lines_trx_v pl -- CLM project, bug 9403291
738: -- For Bug 7440217
739: , mtl_parameters mp,
740: rcv_parameters rp
741: -- End for Bug 7440217
742: WHERE pll.po_header_id = header_id
743: -- For Bug 7440217
744: AND mp.organization_id = v_organization_id

Line 1386: l_asn_exists_code rcv_parameters.receipt_asn_exists_code%TYPE; --Bug 8726009

1382: l_tol_qty_po_uom NUMBER := 0; -- Tolerable quantity in the uom of the po.
1383: --End of fix for Bug 4004656
1384:
1385: l_blind_receiving_flag VARCHAR2(1) := 'N'; -- Bug 6365270
1386: l_asn_exists_code rcv_parameters.receipt_asn_exists_code%TYPE; --Bug 8726009
1387: l_asn_count NUMBER := 0; --Bug 8726009
1388: l_asn_validation_failed VARCHAR2(1) :='N';
1389: -- For Bug 7440217
1390: l_asn_type VARCHAR2(40);

Line 2130: * Options window. Get the control code from rcv_parameters.

2126: current_n := current_n -1 ;
2127: end if;
2128: /* Bug 8726009.
2129: * We need to use the ASN control action set in the Receiving
2130: * Options window. Get the control code from rcv_parameters.
2131: * If the transaction type is Receive/Dir Deliver and if there is an
2132: * ASN existing for that PO, then depending on this value
2133: * we should either allow or error out.
2134: */

Line 2155: FROM rcv_parameters

2151: ELSE
2152:
2153: SELECT NVL(receipt_asn_exists_code, 'NONE')
2154: INTO l_asn_exists_code
2155: FROM rcv_parameters
2156: WHERE organization_id = temp_cascaded_table(current_n).to_organization_id;
2157:
2158: End If;
2159:

Line 2164: FROM rcv_parameters

2160: Else
2161:
2162: SELECT NVL(receipt_asn_exists_code, 'NONE')
2163: INTO l_asn_exists_code
2164: FROM rcv_parameters
2165: WHERE organization_id = temp_cascaded_table(current_n).to_organization_id;
2166:
2167: END IF;
2168:

Line 2178: print_debug('ASN CODE IN rcv_parameters = '||l_asn_exists_code,4);

2174: /* End Bug 9158529 */
2175:
2176: IF l_print_debug = 1 THEN
2177: IF (l_debug = 1) THEN
2178: print_debug('ASN CODE IN rcv_parameters = '||l_asn_exists_code,4);
2179: print_debug('x_cascaded_table(n).transaction_type = '||x_cascaded_table(n).transaction_type,4);
2180: print_debug('x_cascaded_table(n).shipment_header_id = '||x_cascaded_table(n).shipment_header_id,4);
2181: print_debug('x_shipmentdistributionrec.line_location_id = '||x_shipmentdistributionrec.line_location_id,4);
2182: END IF;

Line 2293: FROM rcv_parameters

2289: -- Start of fix for Bug 6365270
2290: BEGIN
2291: SELECT blind_receiving_flag
2292: INTO l_blind_receiving_flag
2293: FROM rcv_parameters
2294: WHERE organization_id = temp_cascaded_table(current_n).to_organization_id;
2295: EXCEPTION
2296: when others then
2297: NULL;