APPS.INL_INTEGRATION_GRP dependencies on RCV_TRANSACTIONS_INTERFACE

Line 1257: l_lci_table(l_ind_lci).line_interface_source_table := 'RCV_TRANSACTIONS_INTERFACE';

1253: l_lci_table(l_ind_lci).poa_party_id := l_party_id;
1254: l_lci_table(l_ind_lci).poa_party_site_id := l_party_site_id;
1255: l_lci_table(l_ind_lci).poo_organization_id := l_ship_to_org_id;
1256: l_lci_table(l_ind_lci).poo_location_id := p_int_rec(i).ship_to_location_id;
1257: l_lci_table(l_ind_lci).line_interface_source_table := 'RCV_TRANSACTIONS_INTERFACE';
1258: l_lci_table(l_ind_lci).line_interface_source_line_id := p_int_rec(i).interface_transaction_id;
1259: l_lci_table(l_ind_lci).rcv_enabled_flag := 'Y'; --Bug#9279355
1260: l_ind_lci := l_ind_lci + 1;
1261: EXCEPTION

Line 1370: UPDATE rcv_transactions_interface rti

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;
1370: UPDATE rcv_transactions_interface rti
1371: SET processing_status_code = 'LC_INTERFACED'
1372: WHERE transaction_status_code = 'PENDING'
1373: AND processing_status_code = 'LC_PENDING'
1374: AND (transaction_type in ('RECEIVE', 'MATCH') OR --Bug#9275335

Line 1654: -- Function : Update RCV Transactions Interface with

1650:
1651:
1652: -- API name : Get_LandedCost
1653: -- Type : Group
1654: -- Function : Update RCV Transactions Interface with
1655: -- the calculated Unit Landed Cost.
1656: --
1657: -- Pre-reqs : None
1658: -- Parameters :

Line 1721: UPDATE rcv_transactions_interface

1717: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1718: p_procedure_name => l_api_name,
1719: p_debug_info => 'Updating RTIs with the new landed cost');
1720:
1721: UPDATE rcv_transactions_interface
1722: SET unit_landed_cost = l_actual_unit_landed_cost,
1723: lcm_adjustment_num = l_actual_ajust_num -- opm integration
1724: WHERE processing_status_code = 'RUNNING'
1725: AND transaction_status_code = 'PENDING'

Line 1744: UPDATE rcv_transactions_interface rti

1740: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1741: p_procedure_name => l_api_name,
1742: p_debug_info => 'Setting RTIs to ERROR. Landed Cost is null.');
1743:
1744: UPDATE rcv_transactions_interface rti
1745: SET unit_landed_cost = NULL,
1746: lcm_adjustment_num = NULL, -- opm integration
1747: processing_status_code = 'ERROR'
1748: WHERE processing_status_code = 'RUNNING'

Line 1771: UPDATE rcv_transactions_interface

1767: p_procedure_name => l_api_name);
1768: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1769: p_procedure_name => l_api_name,
1770: p_debug_info => 'the error is: ' || sqlcode ||' '||substr(SQLERRM, 1, 1000));
1771: UPDATE rcv_transactions_interface
1772: SET processing_status_code = 'ERROR'
1773: WHERE processing_status_code = 'RUNNING'
1774: AND transaction_status_code = 'PENDING'
1775: AND mo_global.check_access(org_id) = 'Y'

Line 1933: OPEN c_ship_lines(p_ship_header_id, /*'PO'*/ NULL, 'RCV_TRANSACTIONS_INTERFACE');

1929:
1930: -- Initialize API RETURN status to success
1931: x_return_status := FND_API.G_RET_STS_SUCCESS;
1932:
1933: OPEN c_ship_lines(p_ship_header_id, /*'PO'*/ NULL, 'RCV_TRANSACTIONS_INTERFACE');
1934: FETCH c_ship_lines BULK COLLECT INTO l_ship_lines_table;
1935:
1936: IF c_ship_lines%ISOPEN THEN
1937: CLOSE c_ship_lines;