APPS.INL_INTEGRATION_GRP dependencies on RCV_HEADERS_INTERFACE

Line 541: -- If receipt num is NULL get it from rcv_headers_interface

537: p_var_value => l_receipt_num );
538:
539: IF(l_receipt_num IS NULL AND p_int_rec(i).header_interface_id IS NOT NULL) THEN
540:
541: -- If receipt num is NULL get it from rcv_headers_interface
542: l_debug_msg := 'Receipt num is NULL get it from rcv_headers_interface';
543: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
544: p_procedure_name => l_proc_name,
545: p_debug_info => l_debug_msg);

Line 542: l_debug_msg := 'Receipt num is NULL get it from rcv_headers_interface';

538:
539: IF(l_receipt_num IS NULL AND p_int_rec(i).header_interface_id IS NOT NULL) THEN
540:
541: -- If receipt num is NULL get it from rcv_headers_interface
542: l_debug_msg := 'Receipt num is NULL get it from rcv_headers_interface';
543: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
544: p_procedure_name => l_proc_name,
545: p_debug_info => l_debug_msg);
546:

Line 549: FROM rcv_headers_interface rhi

545: p_debug_info => l_debug_msg);
546:
547: SELECT receipt_num
548: INTO l_receipt_num
549: FROM rcv_headers_interface rhi
550: WHERE header_interface_id = p_int_rec(i).header_interface_id;
551:
552: END IF;
553:

Line 566: FROM rcv_headers_interface

562: l_ship_to_location_id,
563: l_receipt_num,
564: l_vendor_id,
565: l_vendor_site_id
566: FROM rcv_headers_interface
567: WHERE header_interface_id = p_int_rec(i).header_interface_id;
568: END IF;
569:
570: INL_LOGGING_PVT.Log_Variable (

Line 720: l_lci_table(i).hdr_interface_source_table := 'RCV_HEADERS_INTERFACE';

716: l_lci_table(i).interface_source_code := 'RCV';
717: IF p_int_rec(i).shipment_header_id IS NOT NULL THEN
718: l_lci_table(i).hdr_interface_source_table := 'RCV_SHIPMENT_HEADERS';
719: ELSIF p_int_rec(i).header_interface_id IS NOT NULL THEN
720: l_lci_table(i).hdr_interface_source_table := 'RCV_HEADERS_INTERFACE';
721: END IF;
722: l_lci_table(i).hdr_interface_source_line_id := Nvl(p_int_rec(i).shipment_header_id,p_int_rec(i).header_interface_id);
723: l_lci_table(i).validation_flag := 'Y';
724: l_lci_table(i).receipt_num := l_receipt_num;

Line 964: UPDATE rcv_headers_interface rhi

960: AND pll.lcm_flag = 'Y' )
961: AND Nvl(shipment_header_id,Header_interface_id) = Nvl(p_int_rec(i).shipment_header_id,p_int_rec(i).header_interface_id);
962:
963: IF p_int_rec(i).header_interface_id IS NOT NULL THEN
964: UPDATE rcv_headers_interface rhi
965: SET processing_status_code = 'LC_INTERFACED'
966: WHERE processing_status_code='LC_PENDING'
967: AND header_interface_id=p_int_rec(i).header_interface_id;
968: END IF;