DBA Data[Home] [Help]

APPS.INL_TAX_PVT dependencies on ZX_TRX_HEADERS_GT

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

1060: -- Utility name: Populate_Headers_GT
1061: --
1062: -- Type : Private
1063: --
1064: -- Function : It populate the temporary zx table: zx_trx_headers_gt
1065: -- but it remove any record of the same ship_Header_id before
1066: --
1067: -- Pre-reqs : None
1068: --

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

1145: x_event_type_code := 'ARRIVAL CREATED';
1146: END IF;
1147: l_step:='03';
1148: -------------------------------------------------------------------
1149: l_debug_info := 'Step 8: Populate zx_trx_headers_gt';
1150: -------------------------------------------------------------------
1151: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1152: -- logging message
1153: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

Line 1157: DELETE FROM zx_trx_headers_gt

1153: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1154: p_procedure_name => l_function_name,
1155: p_debug_info => l_debug_info);
1156: -- Delete records of the current shipment
1157: DELETE FROM zx_trx_headers_gt
1158: WHERE trx_id=l_ship_header_rec.ship_header_id;
1159: -- Insert records
1160: l_step:='04';
1161:

Line 1162: INSERT INTO zx_trx_headers_gt(

1158: WHERE trx_id=l_ship_header_rec.ship_header_id;
1159: -- Insert records
1160: l_step:='04';
1161:
1162: INSERT INTO zx_trx_headers_gt(
1163: /*01*/ internal_organization_id,
1164: /*02*/ internal_org_location_id,
1165: /*03*/ application_id,
1166: /*04*/ entity_code,