APPS.INL_INTEGRATION_GRP dependencies on RCV_TRANSACTIONS

Line 487: UPDATE rcv_transactions_interface rti

483: p_procedure_name => l_proc_name,
484: p_debug_info => 'Update RTIs to LC_INTERFACED'
485: );
486:
487: UPDATE rcv_transactions_interface rti
488: SET processing_status_code = 'LC_INTERFACED'
489: WHERE transaction_status_code = 'PENDING'
490: AND processing_status_code = 'LC_PENDING'
491: AND (transaction_type = 'RECEIVE' OR

Line 911: l_lci_table(i).line_interface_source_table := 'RCV_TRANSACTIONS_INTERFACE';

907: l_lci_table(i).poa_party_site_id := l_party_site_id;
908: l_lci_table(i).poo_organization_id := l_ship_to_org_id;
909: l_lci_table(i).poo_location_id := p_int_rec(i).ship_to_location_id;
910: l_lci_table(i).org_id := p_int_rec(i).ORG_ID;
911: l_lci_table(i).line_interface_source_table := 'RCV_TRANSACTIONS_INTERFACE';
912: l_lci_table(i).line_interface_source_line_id := p_int_rec(i).interface_transaction_id;
913:
914: EXCEPTION
915: WHEN OTHERS THEN

Line 950: UPDATE rcv_transactions_interface rti

946:
947: IF (l_return_status = 'S') THEN --(currentHeaderId <> -9999 AND currentHeaderId <> erroredHeaderId AND l_return_status = 'S') THEN
948: FOR i IN 1..p_int_rec.COUNT LOOP
949: -- Update RTIs to LC_INTERFACED
950: UPDATE rcv_transactions_interface rti
951: SET processing_status_code = 'LC_INTERFACED'
952: WHERE transaction_status_code = 'PENDING'
953: AND processing_status_code = 'LC_PENDING'
954: AND (transaction_type = 'RECEIVE' OR

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

1149:
1150:
1151: -- API name : Get_LandedCost
1152: -- Type : Group
1153: -- Function : Update RCV Transactions Interface with
1154: -- the calculated Unit Landed Cost.
1155: --
1156: -- Pre-reqs : None
1157: -- Parameters :

Line 1217: UPDATE rcv_transactions_interface

1213: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1214: p_procedure_name => l_api_name,
1215: p_debug_info => 'Updating RTIs with the new landed cost');
1216:
1217: UPDATE rcv_transactions_interface
1218: SET unit_landed_cost = l_actual_unit_landed_cost
1219: WHERE processing_status_code = 'RUNNING'
1220: AND transaction_status_code = 'PENDING'
1221: AND processing_mode_code = p_processing_mode

Line 1239: UPDATE rcv_transactions_interface rti

1235: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1236: p_procedure_name => l_api_name,
1237: p_debug_info => 'Setting RTIs to ERROR. Landed Cost is null.');
1238:
1239: UPDATE rcv_transactions_interface rti
1240: SET unit_landed_cost = NULL,
1241: processing_status_code = 'ERROR'
1242: WHERE processing_status_code = 'RUNNING'
1243: AND transaction_status_code = 'PENDING'

Line 1265: UPDATE rcv_transactions_interface

1261: p_procedure_name => l_api_name);
1262: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1263: p_procedure_name => l_api_name,
1264: p_debug_info => 'the error is: ' || sqlcode ||' '||substr(SQLERRM, 1, 1000));
1265: UPDATE rcv_transactions_interface
1266: SET processing_status_code = 'ERROR'
1267: WHERE processing_status_code = 'RUNNING'
1268: AND transaction_status_code = 'PENDING'
1269: AND mo_global.check_access(org_id) = 'Y'

Line 1427: OPEN c_ship_lines(p_ship_header_id, 'PO', 'RCV_TRANSACTIONS_INTERFACE');

1423:
1424: -- Initialize API RETURN status to success
1425: x_return_status := FND_API.G_RET_STS_SUCCESS;
1426:
1427: OPEN c_ship_lines(p_ship_header_id, 'PO', 'RCV_TRANSACTIONS_INTERFACE');
1428: FETCH c_ship_lines BULK COLLECT INTO l_ship_lines_table;
1429:
1430: IF c_ship_lines%ISOPEN THEN
1431: CLOSE c_ship_lines;

Line 1793: rcv_transactions rtr

1789: rtr.transaction_id,
1790: ish.adjustment_num
1791: FROM inl_ship_headers ish,
1792: inl_ship_lines isl,
1793: rcv_transactions rtr
1794: WHERE ish.ship_header_id = isl.ship_header_id
1795: AND rtr.po_line_location_id = isl.ship_line_source_id
1796: AND rtr.lcm_shipment_line_id = isl.ship_line_id
1797: AND rtr.parent_transaction_id = -1