DBA Data[Home] [Help]

APPS.INL_TAX_PVT dependencies on ZX_TRX_HEADERS_GT

Line 745: -- Function : It populate the temporary zx table: zx_trx_headers_gt

741: -- Utility name: Populate_Headers_GT
742: --
743: -- Type : Private
744: --
745: -- Function : It populate the temporary zx table: zx_trx_headers_gt
746: -- but it remove any record of the same ship_Header_id before
747: --
748: -- Pre-reqs : None
749: --

Line 830: l_debug_info := 'Step 8: Populate zx_trx_headers_gt';

826: x_event_type_code := 'ARRIVAL CREATED';
827: END IF;
828: l_step:='03';
829: -------------------------------------------------------------------
830: l_debug_info := 'Step 8: Populate zx_trx_headers_gt';
831: -------------------------------------------------------------------
832: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
833: -- logging message
834: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

Line 838: DELETE FROM zx_trx_headers_gt

834: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
835: p_procedure_name => l_function_name,
836: p_debug_info => l_debug_info);
837: -- Delete records of the current shipment
838: DELETE FROM zx_trx_headers_gt
839: WHERE trx_id=l_ship_header_rec.ship_header_id;
840: -- Insert records
841: l_step:='04';
842:

Line 843: INSERT INTO zx_trx_headers_gt(

839: WHERE trx_id=l_ship_header_rec.ship_header_id;
840: -- Insert records
841: l_step:='04';
842:
843: INSERT INTO zx_trx_headers_gt(
844: /*01*/ internal_organization_id,
845: /*02*/ internal_org_location_id,
846: /*03*/ application_id,
847: /*04*/ entity_code,