[Home] [Help]
1459: n IN OUT NOCOPY BINARY_INTEGER
1460: ) IS
1461: po_line_id_record rcv_shipment_line_sv.po_line_id_record_type;
1462: release_id_record rcv_shipment_line_sv.release_id_record_type;
1463: l_asn_type rcv_shipment_headers.asn_type%type;
1464: l_error_column VARCHAR2(30); --Bugfix 4881909
1465: BEGIN
1466: IF (g_asn_debug = 'Y') THEN
1467: asn_debug.put_line('In derive_po_line_info');
2958: x_rate NUMBER;
2959: x_allow_rate_override VARCHAR2(1);
2960: /* Bug# 1548597 */
2961: x_secondary_available_qty NUMBER := 0;
2962: l_receipt_source_code rcv_shipment_headers.receipt_source_code%TYPE;
2963: l_shipment_line_status_code rcv_shipment_lines.shipment_line_status_code%TYPE;
2964: l_asn_line_flag rcv_shipment_lines.asn_line_flag%TYPE;
2965: l_asn_exists_code rcv_parameters.receipt_asn_exists_code%TYPE;
2966: l_does_asn_exist VARCHAR2(1) := 'N';
3892: l_asn_line_flag
3893: FROM po_line_locations pll,
3894: po_lines pl,
3895: po_headers ph,
3896: rcv_shipment_headers rsh,
3897: rcv_shipment_lines rsl
3898: WHERE rsh.shipment_header_id = temp_cascaded_table(current_n).shipment_header_id
3899: AND rsl.shipment_line_id = temp_cascaded_table(current_n).shipment_line_id
3900: AND rsl.po_header_id = temp_cascaded_table(current_n).po_header_id
4197: */
4198:
4199: SELECT COUNT(*)
4200: INTO l_asn_count
4201: FROM rcv_shipment_headers rsh,
4202: rcv_shipment_lines rsl
4203: WHERE rsh.shipment_header_id = rsl.shipment_header_id
4204: AND NVL(rsh.asn_type, 'STD') IN ('ASN','ASBN') --4287932
4205: AND NVL(rsl.shipment_line_status_code, 'EXPECTED') NOT IN('CANCELLED', 'FULLY RECEIVED')
15753: l_lsl_id NUMBER;
15754: l_rate NUMBER;
15755: l_po_rate NUMBER;
15756: v_sobid NUMBER;
15757: l_lcm_date rcv_shipment_headers.conversion_date%type;
15758: l_rate_override VARCHAR2(1);
15759: p_api_version NUMBER := 1.0;
15760: p_init_msg_list VARCHAR2(1);
15761: p_commit VARCHAR2(1);