eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INL_INTEGRATION_GRP dependencies on RCV_HEADERS_INTERFACE

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

688: p_var_value => l_customer_id );
689:
690: IF(l_receipt_num IS NULL AND p_int_rec(i).header_interface_id IS NOT NULL) THEN
691:
692: -- If receipt num is NULL get it from rcv_headers_interface
693: l_debug_msg := 'Receipt num is NULL get it from rcv_headers_interface';
694: INL_LOGGING_PVT.Log_Statement (
695: p_module_name => g_module_name,
696: p_procedure_name => l_proc_name,

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

689:
690: IF(l_receipt_num IS NULL AND p_int_rec(i).header_interface_id IS NOT NULL) THEN
691:
692: -- If receipt num is NULL get it from rcv_headers_interface
693: l_debug_msg := 'Receipt num is NULL get it from rcv_headers_interface';
694: INL_LOGGING_PVT.Log_Statement (
695: p_module_name => g_module_name,
696: p_procedure_name => l_proc_name,
697: p_debug_info => l_debug_msg);

Line 701: FROM rcv_headers_interface rhi

697: p_debug_info => l_debug_msg);
698:
699: SELECT receipt_num
700: INTO l_receipt_num
701: FROM rcv_headers_interface rhi
702: WHERE header_interface_id = p_int_rec(i).header_interface_id;
703:
704: INL_LOGGING_PVT.Log_Variable (
705: p_module_name => g_module_name,

Line 728: FROM rcv_headers_interface

724: l_receipt_num,
725: l_vendor_id,
726: l_vendor_site_id,
727: l_customer_id
728: FROM rcv_headers_interface
729: WHERE header_interface_id = p_int_rec(i).header_interface_id;
730: END IF;
731:
732: l_curr_vendor_site_id := l_vendor_site_id; --Bug#8820297

Line 940: l_lci_table(l_ind_lci).hdr_interface_source_table := 'RCV_HEADERS_INTERFACE';

936: l_lci_table(l_ind_lci).ship_num := l_ship_num; --Bug#8971617
937: IF p_int_rec(i).shipment_header_id IS NOT NULL THEN
938: l_lci_table(l_ind_lci).hdr_interface_source_table := 'RCV_SHIPMENT_HEADERS';
939: ELSIF p_int_rec(i).header_interface_id IS NOT NULL THEN
940: l_lci_table(l_ind_lci).hdr_interface_source_table := 'RCV_HEADERS_INTERFACE';
941: END IF;
942:
943: l_lci_table(l_ind_lci).hdr_interface_source_line_id := NVL(p_int_rec(i).shipment_header_id,p_int_rec(i).header_interface_id);
944: l_lci_table(l_ind_lci).validation_flag := 'N';

Line 1365: UPDATE rcv_headers_interface rhi

1361: IF NVL(l_lci_table(i).shipment_header_id,l_lci_table(i).header_interface_id) <> -9999 THEN --Bug#9737425
1362: IF currentHeaderId <> l_lci_table(i).hdr_interface_source_line_id THEN
1363: currentHeaderId := l_lci_table(i).hdr_interface_source_line_id;
1364: IF l_lci_table(i).header_interface_id IS NOT NULL THEN
1365: UPDATE rcv_headers_interface rhi
1366: SET processing_status_code = 'LC_INTERFACED'
1367: WHERE processing_status_code='LC_PENDING'
1368: AND header_interface_id=l_lci_table(i).header_interface_id;
1369: END IF;