APPS.FTE_TL_COST_ALLOCATION SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 194

TYPE T_LAST_UPDATE_DATE_typ                 IS TABLE OF                  DATE            INDEX BY BINARY_INTEGER;

Line: 195

TYPE T_LAST_UPDATED_BY_typ                  IS TABLE OF                  NUMBER          INDEX BY BINARY_INTEGER;

Line: 196

TYPE T_LAST_UPDATE_LOGIN_typ                IS TABLE OF                  NUMBER          INDEX BY BINARY_INTEGER;

Line: 199

TYPE T_PROGRAM_UPDATE_DATE_typ              IS TABLE OF                  DATE            INDEX BY BINARY_INTEGER;

Line: 255

G_B_T_LAST_UPDATE_DATE        	      T_LAST_UPDATE_DATE_typ;

Line: 256

G_B_T_LAST_UPDATED_BY         	      T_LAST_UPDATED_BY_typ;

Line: 257

G_B_T_LAST_UPDATE_LOGIN       	      T_LAST_UPDATE_LOGIN_typ;

Line: 260

G_B_T_PROGRAM_UPDATE_DATE     	      T_PROGRAM_UPDATE_DATE_typ;

Line: 363

	G_B_delivery_detail_id.delete;

Line: 364

	G_B_delivery_id.delete;

Line: 365

	G_B_delivery_leg_id.delete;

Line: 366

	G_B_reprice_required.delete;

Line: 367

	G_B_parent_delivery_detail_id.delete;

Line: 368

	G_B_customer_id.delete;

Line: 369

	G_B_sold_to_contact_id.delete;

Line: 370

	G_B_inventory_item_id.delete;

Line: 371

	G_B_item_description.delete;

Line: 372

	G_B_hazard_class_id.delete;

Line: 373

	G_B_country_of_origin.delete;

Line: 374

	G_B_classification.delete;

Line: 375

	G_B_requested_quantity.delete;

Line: 376

	G_B_requested_quantity_uom.delete;

Line: 377

	G_B_master_container_item_id.delete;

Line: 378

	G_B_detail_container_item_id.delete;

Line: 379

	G_B_customer_item_id.delete;

Line: 380

	G_B_net_weight.delete;

Line: 381

	G_B_organization_id.delete;

Line: 382

	G_B_container_flag.delete;

Line: 383

	G_B_container_type_code.delete;

Line: 384

	G_B_container_name.delete;

Line: 385

	G_B_fill_percent.delete;

Line: 386

	G_B_gross_weight.delete;

Line: 387

	G_B_currency_code.delete;

Line: 388

	G_B_freight_class_cat_id.delete;

Line: 389

	G_B_commodity_code_cat_id.delete;

Line: 390

	G_B_weight_uom_code.delete;

Line: 391

	G_B_volume.delete;

Line: 392

	G_B_volume_uom_code.delete;

Line: 393

	G_B_tp_attribute_category.delete;

Line: 394

	G_B_tp_attribute1.delete;

Line: 395

	G_B_tp_attribute2.delete;

Line: 396

	G_B_tp_attribute3.delete;

Line: 397

	G_B_tp_attribute4.delete;

Line: 398

	G_B_tp_attribute5.delete;

Line: 399

	G_B_tp_attribute6.delete;

Line: 400

	G_B_tp_attribute7.delete;

Line: 401

	G_B_tp_attribute8.delete;

Line: 402

	G_B_tp_attribute9.delete;

Line: 403

	G_B_tp_attribute10.delete;

Line: 404

	G_B_tp_attribute11.delete;

Line: 405

	G_B_tp_attribute12.delete;

Line: 406

	G_B_tp_attribute13.delete;

Line: 407

	G_B_tp_attribute14.delete;

Line: 408

	G_B_tp_attribute15.delete;

Line: 409

	G_B_attribute_category.delete;

Line: 410

	G_B_attribute1.delete;

Line: 411

	G_B_attribute2.delete;

Line: 412

	G_B_attribute3.delete;

Line: 413

	G_B_attribute4.delete;

Line: 414

	G_B_attribute5.delete;

Line: 415

	G_B_attribute6.delete;

Line: 416

	G_B_attribute7.delete;

Line: 417

	G_B_attribute8.delete;

Line: 418

	G_B_attribute9.delete;

Line: 419

	G_B_attribute10.delete;

Line: 420

	G_B_attribute11.delete;

Line: 421

	G_B_attribute12.delete;

Line: 422

	G_B_attribute13.delete;

Line: 423

	G_B_attribute14.delete;

Line: 424

	G_B_attribute15.delete;

Line: 425

	G_B_source_type.delete;

Line: 426

	G_B_source_line_id.delete;

Line: 427

	G_B_source_header_id.delete;

Line: 428

	G_B_source_consolidation_id.delete;

Line: 429

	G_B_ship_date.delete;

Line: 430

	G_B_arrival_date.delete;

Line: 439

	G_B_T_FREIGHT_COST_ID.delete;

Line: 440

	G_B_T_FREIGHT_COST_TYPE_ID.delete;

Line: 441

	G_B_T_UNIT_AMOUNT.delete;

Line: 442

	G_B_T_CALCULATION_METHOD.delete;

Line: 443

	G_B_T_UOM.delete;

Line: 444

	G_B_T_QUANTITY.delete;

Line: 445

	G_B_T_TOTAL_AMOUNT.delete;

Line: 446

	G_B_T_CURRENCY_CODE.delete;

Line: 447

	G_B_T_CONVERSION_DATE.delete;

Line: 448

	G_B_T_CONVERSION_RATE.delete;

Line: 449

	G_B_T_CONVERSION_TYPE_CODE.delete;

Line: 450

	G_B_T_TRIP_ID.delete;

Line: 451

	G_B_T_STOP_ID.delete;

Line: 452

	G_B_T_DELIVERY_ID.delete;

Line: 453

	G_B_T_DELIVERY_LEG_ID.delete;

Line: 454

	G_B_T_DELIVERY_DETAIL_ID.delete;

Line: 455

	G_B_T_ATTRIBUTE_CATEGORY.delete;

Line: 456

	G_B_T_ATTRIBUTE1.delete;

Line: 457

	G_B_T_ATTRIBUTE2.delete;

Line: 458

	G_B_T_ATTRIBUTE3.delete;

Line: 459

	G_B_T_ATTRIBUTE4.delete;

Line: 460

	G_B_T_ATTRIBUTE5.delete;

Line: 461

	G_B_T_ATTRIBUTE6.delete;

Line: 462

	G_B_T_ATTRIBUTE7.delete;

Line: 463

	G_B_T_ATTRIBUTE8.delete;

Line: 464

	G_B_T_ATTRIBUTE9.delete;

Line: 465

	G_B_T_ATTRIBUTE10.delete;

Line: 466

	G_B_T_ATTRIBUTE11.delete;

Line: 467

	G_B_T_ATTRIBUTE12.delete;

Line: 468

	G_B_T_ATTRIBUTE13.delete;

Line: 469

	G_B_T_ATTRIBUTE14.delete;

Line: 470

	G_B_T_ATTRIBUTE15.delete;

Line: 471

	G_B_T_CREATION_DATE.delete;

Line: 472

	G_B_T_CREATED_BY.delete;

Line: 473

	G_B_T_LAST_UPDATE_DATE.delete;

Line: 474

	G_B_T_LAST_UPDATED_BY.delete;

Line: 475

	G_B_T_LAST_UPDATE_LOGIN.delete;

Line: 476

	G_B_T_PROGRAM_APPLICATION_ID.delete;

Line: 477

	G_B_T_PROGRAM_ID.delete;

Line: 478

	G_B_T_PROGRAM_UPDATE_DATE.delete;

Line: 479

	G_B_T_REQUEST_ID.delete;

Line: 480

	G_B_T_LINE_TYPE_CODE.delete;

Line: 481

	G_B_T_PRICING_LIST_HEADER_ID.delete;

Line: 482

	G_B_T_PRICING_LIST_LINE_ID.delete;

Line: 483

	G_B_T_APPLIED_TO_CHARGE_ID.delete;

Line: 484

	G_B_T_CHARGE_UNIT_VALUE.delete;

Line: 485

	G_B_T_CHARGE_SOURCE_CODE.delete;

Line: 486

	G_B_T_ESTIMATED_FLAG.delete;

Line: 487

	G_B_T_COMPARISON_REQUEST_ID.delete;

Line: 488

	G_B_T_LANE_ID.delete;

Line: 489

	G_B_T_SCHEDULE_ID.delete;

Line: 490

	G_B_T_MOVED_TO_MAIN_FLAG.delete;

Line: 491

	G_B_T_SERVICE_TYPE_CODE.delete;

Line: 492

	G_B_T_COMMODITY_CATEGORY_ID.delete;

Line: 515

PROCEDURE Insert_Into_Bulk_Array(
	p_freight_cost_rec IN FTE_FREIGHT_PRICING.shipment_line_rec_type,
	x_return_status OUT NOCOPY Varchar2) IS

	l_return_status VARCHAR2(1);

Line: 527

	FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Insert_Into_Bulk_Array','start');

Line: 609

        FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Into_Bulk_Array');

Line: 621

        FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Into_Bulk_Array',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');

Line: 623

        FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Into_Bulk_Array');

Line: 625

END Insert_Into_Bulk_Array;

Line: 628

PROCEDURE Insert_Into_Temp_Bulk_Array(
	p_freight_cost_rec IN FTE_FREIGHT_PRICING.Freight_Cost_Temp_Rec_Type,
	x_return_status OUT NOCOPY Varchar2) IS


	CURSOR C_Next_Freight_Cost_Id
	IS
	SELECT fte_freight_costs_temp_s.nextval
	FROM sys.dual;

Line: 646

	FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Insert_Into_Temp_Bulk_Array','start');

Line: 691

	G_B_T_LAST_UPDATE_DATE(G_B_T_index):=p_freight_cost_rec.LAST_UPDATE_DATE;

Line: 692

	G_B_T_LAST_UPDATED_BY(G_B_T_index):=p_freight_cost_rec.LAST_UPDATED_BY;

Line: 693

	G_B_T_LAST_UPDATE_LOGIN(G_B_T_index):=p_freight_cost_rec.LAST_UPDATE_LOGIN;

Line: 696

	G_B_T_PROGRAM_UPDATE_DATE(G_B_T_index):=p_freight_cost_rec.PROGRAM_UPDATE_DATE;

Line: 722

        FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Into_Temp_Bulk_Array');

Line: 734

        FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Into_Temp_Bulk_Array',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');

Line: 736

        FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Into_Temp_Bulk_Array');

Line: 738

END Insert_Into_Temp_Bulk_Array;

Line: 741

PROCEDURE Bulk_Insert_Temp(
	x_return_status OUT NOCOPY Varchar2) IS

	l_return_status VARCHAR2(1);

Line: 753

	FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Bulk_Insert_Temp','start');

Line: 757

	SAVEPOINT Bulk_Insert_Temp;

Line: 763

			INSERT INTO FTE_FREIGHT_COSTS_TEMP (
				freight_cost_id,
				freight_cost_type_id,
				unit_amount,
				calculation_method,
				uom,
				quantity,
				total_amount,
				currency_code,
				conversion_date,
				conversion_rate,
				conversion_type_code,
				trip_id,
				stop_id,
				delivery_id,
				delivery_leg_id,
				delivery_detail_id,
				attribute_category,
				attribute1,
				attribute2,
				attribute3,
				attribute4,
				attribute5,
				attribute6,
				attribute7,
				attribute8,
				attribute9,
				attribute10,
				attribute11,
				attribute12,
				attribute13,
				attribute14,
				attribute15,
				creation_date,
				created_by,
				last_update_date,
				last_updated_by,
				last_update_login,
				program_application_id,
				program_id,
				program_update_date,
				request_id,
				line_type_code,
				charge_unit_value,
				charge_source_code,
				estimated_flag,
				comparison_request_id,
				lane_id,
				schedule_id,
				moved_to_main_flag,
				service_type_code,  -- bug2741467
				commodity_category_id,
				vehicle_type_id,
				billable_quantity,
				billable_uom,
				billable_basis

			)
			VALUES
				(
				G_B_T_FREIGHT_COST_ID(i),
				G_B_T_FREIGHT_COST_TYPE_ID(i),
				G_B_T_UNIT_AMOUNT(i),
				G_B_T_CALCULATION_METHOD(i),
				G_B_T_UOM(i),
				G_B_T_QUANTITY(i),
				G_B_T_TOTAL_AMOUNT(i),
				G_B_T_CURRENCY_CODE(i),
				G_B_T_CONVERSION_DATE(i),
				G_B_T_CONVERSION_RATE(i),
				G_B_T_CONVERSION_TYPE_CODE(i),
				G_B_T_TRIP_ID(i),
				G_B_T_STOP_ID(i),
				G_B_T_DELIVERY_ID(i),
				G_B_T_DELIVERY_LEG_ID(i),
				G_B_T_DELIVERY_DETAIL_ID(i),
				G_B_T_ATTRIBUTE_CATEGORY(i),
				G_B_T_ATTRIBUTE1(i),
				G_B_T_ATTRIBUTE2(i),
				G_B_T_ATTRIBUTE3(i),
				G_B_T_ATTRIBUTE4(i),
				G_B_T_ATTRIBUTE5(i),
				G_B_T_ATTRIBUTE6(i),
				G_B_T_ATTRIBUTE7(i),
				G_B_T_ATTRIBUTE8(i),
				G_B_T_ATTRIBUTE9(i),
				G_B_T_ATTRIBUTE10(i),
				G_B_T_ATTRIBUTE11(i),
				G_B_T_ATTRIBUTE12(i),
				G_B_T_ATTRIBUTE13(i),
				G_B_T_ATTRIBUTE14(i),
				G_B_T_ATTRIBUTE15(i),
				G_B_T_CREATION_DATE(i),
				G_B_T_CREATED_BY(i),
				G_B_T_LAST_UPDATE_DATE(i),
				G_B_T_LAST_UPDATED_BY(i),
				G_B_T_LAST_UPDATE_LOGIN(i),
				G_B_T_PROGRAM_APPLICATION_ID(i),
				G_B_T_PROGRAM_ID(i),
				G_B_T_PROGRAM_UPDATE_DATE(i),
				G_B_T_REQUEST_ID(i),
				G_B_T_LINE_TYPE_CODE(i),
				--G_B_T_PRICING_LIST_HEADER_ID(i),
				--G_B_T_PRICING_LIST_LINE_ID(i),
				--G_B_T_APPLIED_TO_CHARGE_ID(i),
				G_B_T_CHARGE_UNIT_VALUE(i),
				G_B_T_CHARGE_SOURCE_CODE(i),
				G_B_T_ESTIMATED_FLAG(i),
				G_B_T_COMPARISON_REQUEST_ID(i),
				G_B_T_LANE_ID(i),
				G_B_T_SCHEDULE_ID(i),
				G_B_T_MOVED_TO_MAIN_FLAG(i),
				G_B_T_SERVICE_TYPE_CODE(i),
				G_B_T_COMMODITY_CATEGORY_ID(i),
				G_B_T_VEHICLE_TYPE_ID(i),
				G_B_T_BILLABLE_QUANTITY(i),
				G_B_T_BILLABLE_UOM(i),
				G_B_T_BILLABLE_BASIS(i)
				);

Line: 886

        FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Bulk_Insert_Temp');

Line: 898

        ROLLBACK TO Bulk_Insert_Temp;

Line: 899

        FTE_FREIGHT_PRICING_UTIL.set_exception('Bulk_Insert_Temp',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');

Line: 901

        FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Bulk_Insert_Temp');

Line: 903

END Bulk_Insert_Temp;

Line: 907

PROCEDURE Bulk_Insert(
	x_return_status OUT NOCOPY Varchar2) IS

	l_return_status VARCHAR2(1);

Line: 918

	FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Bulk_Insert','start');

Line: 926

        FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Bulk_Insert');

Line: 938

        FTE_FREIGHT_PRICING_UTIL.set_exception('Bulk_Insert',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');

Line: 940

        FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Bulk_Insert');

Line: 942

END Bulk_Insert;

Line: 953

	SELECT TL_PRIN_COST_ALLOC_BASIS,TL_DISTANCE_ALLOC_BASIS,TL_STOP_COST_ALLOC_BASIS
	FROM WSH_GLOBAL_PARAMETERS;

Line: 1083

	SELECT f.freight_cost_type_id
	FROM WSH_FREIGHT_COST_TYPES f
	WHERE f.freight_cost_type_code='FTEPRICE' AND f.name=c_name;

Line: 1088

	SELECT f.freight_cost_type_id
	FROM WSH_FREIGHT_COST_TYPES f
	WHERE f.freight_cost_type_code='FTECHARGE' AND f.name=c_name;

Line: 1093

	SELECT f.freight_cost_type_id
	FROM WSH_FREIGHT_COST_TYPES f
	WHERE f.freight_cost_type_code='FTESUMMARY'AND f.name=c_name;

Line: 1098

	SELECT f.freight_cost_type_id
	FROM WSH_FREIGHT_COST_TYPES f
	WHERE f.freight_cost_type_code='FTEDISCOUNT'AND f.name=c_name;

Line: 3678

        x_freight_rec.last_update_date:= p_freight_rec.last_update_date;

Line: 3679

        x_freight_rec.last_updated_by:=p_freight_rec.last_updated_by;

Line: 3680

        x_freight_rec.last_update_login:= p_freight_rec.last_update_login;

Line: 3684

        x_freight_rec.program_update_date:= p_freight_rec.program_update_date;

Line: 3714

PROCEDURE Insert_Charge_Rec(
	p_freight_rec IN FTE_FREIGHT_PRICING.Freight_Cost_Temp_Rec_Type,
	p_cost_allocation_parameters IN TL_allocation_params_rec_type,
	x_output_cost_tab IN OUT NOCOPY
		FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type,
	x_freight_cost_id IN OUT NOCOPY NUMBER,
	x_return_status IN OUT NOCOPY VARCHAR2) IS

	l_freight_rec_main WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;

Line: 3733

	FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Insert_Charge_Rec','start');

Line: 3738

	SAVEPOINT Insert_Charge_Rec;

Line: 3748

		Insert_Into_Temp_Bulk_Array(
			p_freight_cost_rec =>l_freight_rec,
			x_return_status=>x_return_status);

Line: 3793

	--delivery leg summary always exists, just update it

		 IF ((l_freight_rec_main.delivery_leg_id IS NOT NULL)
				 AND(l_freight_rec_main.delivery_detail_id IS NULL)
			 AND (l_freight_rec_main.line_type_code='SUMMARY'))
		THEN
			l_freight_rec_main.freight_cost_id:=FTE_FREIGHT_PRICING.get_fc_id_from_dleg(l_freight_rec_main.delivery_leg_id);

Line: 3809

		      WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(
			 p_rowid                  =>  l_rowid,
			 p_freight_cost_info      =>  l_freight_rec_main,
			 x_return_status          =>  l_return_status);

Line: 3816

				FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'Update_Freight_Cost');

Line: 3817

				raise FTE_FREIGHT_PRICING_UTIL.g_update_freight_cost_failed;

Line: 3819

				FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_WRN,'Update_Freight_Cost returned warning ');

Line: 3859

        FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Charge_Rec');

Line: 3868

    	 ROLLBACK TO Insert_Charge_Rec;

Line: 3870

         FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Charge_Rec',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_tmp_bulk_arr_fail');

Line: 3871

         FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Charge_Rec');

Line: 3875

    	 ROLLBACK TO Insert_Charge_Rec;

Line: 3877

         FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Charge_Rec',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_fc_id_fail');

Line: 3878

         FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Charge_Rec');

Line: 3880

    WHEN FTE_FREIGHT_PRICING_UTIL.g_update_freight_cost_failed THEN
    	 ROLLBACK TO Insert_Charge_Rec;

Line: 3883

         FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Charge_Rec',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_update_freight_cost_failed');

Line: 3884

         FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Charge_Rec');

Line: 3887

    	 ROLLBACK TO Insert_Charge_Rec;

Line: 3889

         FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Charge_Rec',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_cr_fr_cost_temp_fail');

Line: 3890

         FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Charge_Rec');

Line: 3893

    	  ROLLBACK TO Insert_Charge_Rec;

Line: 3895

          FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Charge_Rec',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_copy_fr_rec_fail');

Line: 3896

          FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Charge_Rec');

Line: 3899

    	  ROLLBACK TO Insert_Charge_Rec;

Line: 3901

          FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Charge_Rec',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_cr_fr_cost_fail');

Line: 3902

          FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Charge_Rec');

Line: 3905

    	  ROLLBACK TO Insert_Charge_Rec;

Line: 3907

          FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Charge_Rec',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_invalid_output_type');

Line: 3908

          FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Charge_Rec');

Line: 3911

    	ROLLBACK TO Insert_Charge_Rec;

Line: 3913

        FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Charge_Rec',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');

Line: 3915

        FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Charge_Rec');

Line: 3919

END Insert_Charge_Rec;

Line: 3923

PROCEDURE Insert_Dlv_Dtl_Level_Charge(
	p_charge_type IN NUMBER,
	p_line_type_code IN VARCHAR2,
	p_charge IN NUMBER,
	p_unit_charge IN NUMBER,
	p_freight_rec IN FTE_FREIGHT_PRICING.Freight_Cost_Temp_Rec_Type,
	p_cost_allocation_parameters IN TL_allocation_params_rec_type,
	x_output_cost_tab IN  OUT NOCOPY
		FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type ,
	x_return_status OUT NOCOPY Varchar2) IS

	l_freight_rec  FTE_FREIGHT_PRICING.Freight_Cost_Temp_Rec_Type;

Line: 3946

	FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Insert_Dlv_Dtl_Level_Charge','start');

Line: 3957

	Insert_Charge_Rec(
		p_freight_rec=>	l_freight_rec,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters,
		x_output_cost_tab=>	x_output_cost_tab ,
		x_freight_cost_id=>	l_freight_cost_id,
		x_return_status=>	l_return_status);

Line: 3973

        FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Dlv_Dtl_Level_Charge');

Line: 3982

        FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Dlv_Dtl_Level_Charge',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_charge_rec_fail');

Line: 3983

        FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Dlv_Dtl_Level_Charge');

Line: 3988

        FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Dlv_Dtl_Level_Charge',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');

Line: 3990

        FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Dlv_Dtl_Level_Charge');

Line: 3994

END Insert_Dlv_Dtl_Level_Charge;

Line: 3998

PROCEDURE Insert_Trip_Level_Charge(
	p_charge_type IN NUMBER,
	p_line_type_code IN VARCHAR2,
	p_charge IN NUMBER,
	p_unit_charge IN NUMBER,
	p_freight_rec IN FTE_FREIGHT_PRICING.Freight_Cost_Temp_Rec_Type,
	p_cost_allocation_parameters IN TL_allocation_params_rec_type,
	x_output_cost_tab IN  OUT NOCOPY
		FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type,
	x_return_status OUT NOCOPY Varchar2) IS

	l_freight_rec  FTE_FREIGHT_PRICING.Freight_Cost_Temp_Rec_Type;

Line: 4021

	FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Insert_Trip_Level_Charge','start');

Line: 4033

	Insert_Charge_Rec(
		p_freight_rec=>	l_freight_rec,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters,
		x_output_cost_tab=>	x_output_cost_tab ,
		x_freight_cost_id=>	l_freight_cost_id,
		x_return_status=>	l_return_status);

Line: 4048

        FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Trip_Level_Charge');

Line: 4057

        FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Trip_Level_Charge',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_charge_rec_fail');

Line: 4058

        FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Trip_Level_Charge');

Line: 4063

        FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Trip_Level_Charge',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');

Line: 4065

        FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Trip_Level_Charge');

Line: 4069

END Insert_Trip_Level_Charge;

Line: 4073

PROCEDURE Insert_Stop_Level_Charge(
	p_charge_type IN NUMBER,
	p_line_type_code IN VARCHAR2,
	p_charge IN NUMBER,
	p_unit_charge IN NUMBER,
	p_freight_rec IN FTE_FREIGHT_PRICING.Freight_Cost_Temp_Rec_Type,
	p_cost_allocation_parameters IN TL_allocation_params_rec_type,
	x_output_cost_tab IN  OUT NOCOPY
		FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type ,
	x_return_status OUT NOCOPY Varchar2) IS

	l_freight_rec  FTE_FREIGHT_PRICING.Freight_Cost_Temp_Rec_Type;

Line: 4096

	FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Insert_Stop_Level_Charge','start');

Line: 4106

	Insert_Charge_Rec(
		p_freight_rec=>	l_freight_rec,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters,
		x_output_cost_tab=>	x_output_cost_tab ,
		x_freight_cost_id=>	l_freight_cost_id,
		x_return_status=>	l_return_status);

Line: 4121

        FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Stop_Level_Charge');

Line: 4130

        FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Stop_Level_Charge',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_charge_rec_fail');

Line: 4131

        FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Stop_Level_Charge');

Line: 4135

        FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Stop_Level_Charge',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');

Line: 4137

        FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Stop_Level_Charge');

Line: 4141

END Insert_Stop_Level_Charge;

Line: 4146

PROCEDURE Insert_Dleg_Level_Charge(
	p_charge_type IN NUMBER,
	p_line_type_code IN VARCHAR2,
	p_charge IN NUMBER,
	p_unit_charge IN NUMBER,
	p_freight_rec IN FTE_FREIGHT_PRICING.Freight_Cost_Temp_Rec_Type,
	p_cost_allocation_parameters IN TL_allocation_params_rec_type,
	x_output_cost_tab IN  OUT NOCOPY FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type,
	x_return_status OUT NOCOPY Varchar2) IS

	l_freight_rec  FTE_FREIGHT_PRICING.Freight_Cost_Temp_Rec_Type;

Line: 4168

	FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Insert_Dleg_Level_Charge','start');

Line: 4180

	Insert_Charge_Rec(
		p_freight_rec=>	l_freight_rec,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters,
		x_output_cost_tab=>	x_output_cost_tab ,
		x_freight_cost_id=>	l_freight_cost_id,
		x_return_status=>	l_return_status);

Line: 4195

        FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Dleg_Level_Charge');

Line: 4204

        FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Dleg_Level_Charge',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_charge_rec_fail');

Line: 4205

        FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Dleg_Level_Charge');

Line: 4210

        FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Dleg_Level_Charge',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');

Line: 4212

        FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Dleg_Level_Charge');

Line: 4216

END Insert_Dleg_Level_Charge;

Line: 4553

	l_freight_rec_common.last_update_date := sysdate;

Line: 4554

        l_freight_rec_common.last_updated_by := FND_GLOBAL.USER_ID;

Line: 4555

        l_freight_rec_common.last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 4563

	Insert_Trip_Level_Charge(
		p_charge_type=>	g_tl_freight_codes(C_SUMMARY).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	l_total_trip_charge,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 4585

	Insert_Trip_Level_Charge(
		p_charge_type=>	g_tl_freight_codes(C_LOADED_DISTANCE_RT).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_trip_charges_rec.base_dist_load_chrg,
		p_unit_charge=>	p_trip_charges_rec.base_dist_load_unit_chrg,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	x_return_status);

Line: 4608

	Insert_Trip_Level_Charge(
		p_charge_type=>	g_tl_freight_codes(C_UNLOADED_DISTANCE_RT).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_trip_charges_rec.base_dist_unload_chrg,
		p_unit_charge=>	p_trip_charges_rec.base_dist_unload_unit_chrg,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 4664

	Insert_Trip_Level_Charge(
		p_charge_type=>	l_unit_freight_code,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_trip_charges_rec.base_unit_chrg,
		p_unit_charge=>	p_trip_charges_rec.base_unit_unit_chrg,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status
		);

Line: 4686

	Insert_Trip_Level_Charge(
		p_charge_type=>	g_tl_freight_codes(C_TIME_RT).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_trip_charges_rec.base_time_chrg,
		p_unit_charge=>	p_trip_charges_rec.base_time_unit_chrg,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 4708

	Insert_Trip_Level_Charge(
		p_charge_type=>	g_tl_freight_codes(C_FLAT_RT).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_trip_charges_rec.base_flat_chrg,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 4728

	Insert_Trip_Level_Charge(
		p_charge_type=>	g_tl_freight_codes(C_STOP_OFF_CHRG).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_trip_charges_rec.stop_off_chrg,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 4753

	Insert_Trip_Level_Charge(
		p_charge_type=>	g_tl_freight_codes(C_OUT_OF_ROUTE_CHRG).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_trip_charges_rec.out_of_route_chrg,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 4775

	Insert_Trip_Level_Charge(
		g_tl_freight_codes(C_DOCUMENT_CHRG).fte_summary_code_id,
		'SUMMARY',
		p_trip_charges_rec.document_chrg,
		NULL,
		l_freight_rec_common,
		p_cost_allocation_parameters,
		x_output_cost_tab);

Line: 4788

	Insert_Trip_Level_Charge(
		p_charge_type=>	g_tl_freight_codes(C_HANDLING_CHRG).fte_summary_code_id,
		p_line_type_code=>'SUMMARY',
		p_charge=>	p_trip_charges_rec.handling_chrg,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 4808

	Insert_Trip_Level_Charge(
		p_charge_type=>	g_tl_freight_codes(C_FUEL_CHRG).fte_summary_code_id,
		p_line_type_code=>'SUMMARY',
		p_charge=>	p_trip_charges_rec.fuel_chrg,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 4833

	Insert_Trip_Level_Charge(
	  p_charge_type=>	g_tl_freight_codes(C_CONTINUOUS_MOVE_DISCOUNT).fte_summary_code_id,
	  p_line_type_code=>	'DISCOUNT',
	  p_charge=>	p_trip_charges_rec.cm_discount_value,
	  p_unit_charge=>	NULL,
	  p_freight_rec=>	l_freight_rec_common,
	  p_cost_allocation_parameters=>	p_cost_allocation_parameters,
	  x_output_cost_tab=>	x_output_cost_tab,
	  x_return_status=>	l_return_status);

Line: 4984

	l_freight_rec_common.last_update_date := sysdate;

Line: 4985

        l_freight_rec_common.last_updated_by := FND_GLOBAL.USER_ID;

Line: 4986

        l_freight_rec_common.last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 5008

	Insert_Stop_Level_Charge(
		p_charge_type=>	g_tl_freight_codes(C_SUMMARY).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	l_total_stop_charge,
		p_unit_charge=>NULL,
		p_freight_rec=>l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5029

	Insert_Stop_Level_Charge(
		p_charge_type=>	g_tl_freight_codes(C_WEEKDAY_LAYOVER_CHRG).fte_summary_code_id,
		p_line_type_code=>'SUMMARY',
		p_charge=>p_stop_charges_rec.weekday_layover_chrg,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5051

	Insert_Stop_Level_Charge(
		p_charge_type=>	g_tl_freight_codes(C_WEEKEND_LAYOVER_CHRG).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_stop_charges_rec.weekend_layover_chrg,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5075

	Insert_Stop_Level_Charge(
		p_charge_type=>	g_tl_freight_codes(C_LOADING_CHRG).fte_summary_code_id,
		p_line_type_code=>'SUMMARY',
		p_charge=>p_stop_charges_rec.loading_chrg,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters ,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5096

	Insert_Stop_Level_Charge(
		p_charge_type=>	g_tl_freight_codes(C_AST_LOADING_CHRG).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_stop_charges_rec.ast_loading_chrg,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters ,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5121

	Insert_Stop_Level_Charge(
		p_charge_type=>	g_tl_freight_codes(C_UNLOADING_CHRG).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_stop_charges_rec.unloading_chrg,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5142

	Insert_Stop_Level_Charge(
		p_charge_type=>	g_tl_freight_codes(C_AST_UNLOADING_CHRG).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_stop_charges_rec.ast_unloading_chrg,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5165

	Insert_Stop_Level_Charge(
		p_charge_type=>	g_tl_freight_codes(C_ORIGIN_SURCHRG).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_stop_charges_rec.origin_surchrg,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5188

	Insert_Stop_Level_Charge(
		p_charge_type=>	g_tl_freight_codes(C_DESTINATION_SURCHRG).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_stop_charges_rec.destination_surchrg,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5229

	Insert_Stop_Level_Charge(
		p_charge_type=>g_tl_freight_codes(F_LOADING_CHRG).fte_summary_code_id,
		p_line_type_code=>'SUMMARY',
		p_charge=>l_charge,
		p_unit_charge=>NULL,
		p_freight_rec=>l_freight_rec_common,
		p_cost_allocation_parameters=>p_cost_allocation_parameters ,
		x_output_cost_tab=>x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5268

	Insert_Stop_Level_Charge(
		p_charge_type=>g_tl_freight_codes(F_AST_LOADING_CHRG).fte_summary_code_id,
		p_line_type_code=>'SUMMARY',
		p_charge=>l_charge,
		p_unit_charge=>NULL,
		p_freight_rec=>l_freight_rec_common,
		p_cost_allocation_parameters=>p_cost_allocation_parameters ,
		x_output_cost_tab=>x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5306

	Insert_Stop_Level_Charge(
		p_charge_type=>g_tl_freight_codes(F_UNLOADING_CHRG).fte_summary_code_id,
		p_line_type_code=>'SUMMARY',
		p_charge=>l_charge,
		p_unit_charge=>NULL,
		p_freight_rec=>l_freight_rec_common,
		p_cost_allocation_parameters=>p_cost_allocation_parameters ,
		x_output_cost_tab=>x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5343

	Insert_Stop_Level_Charge(
		p_charge_type=>g_tl_freight_codes(F_AST_UNLOADING_CHRG).fte_summary_code_id,
		p_line_type_code=>'SUMMARY',
		p_charge=>l_charge,
		p_unit_charge=>NULL,
		p_freight_rec=>l_freight_rec_common,
		p_cost_allocation_parameters=>p_cost_allocation_parameters ,
		x_output_cost_tab=>x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5380

	Insert_Stop_Level_Charge(
		p_charge_type=>g_tl_freight_codes(F_HANDLING_CHRG).fte_summary_code_id,
		p_line_type_code=>'SUMMARY',
		p_charge=>l_charge,
		p_unit_charge=>NULL,
		p_freight_rec=>l_freight_rec_common,
		p_cost_allocation_parameters=>p_cost_allocation_parameters ,
		x_output_cost_tab=>x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5550

	l_freight_rec_common.last_update_date := sysdate;

Line: 5551

        l_freight_rec_common.last_updated_by := FND_GLOBAL.USER_ID;

Line: 5552

        l_freight_rec_common.last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 5574

	Insert_Dleg_Level_Charge(
		p_charge_type=>g_tl_freight_codes(C_SUMMARY).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	l_total_dleg_charge,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters ,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5595

	Insert_Dleg_Level_Charge(
		p_charge_type=>g_tl_freight_codes(C_LOADED_DISTANCE_RT).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_dleg_alloc_rec.base_dist_load_chrg,
		p_unit_charge=>	p_dleg_alloc_rec.base_dist_load_unit_chrg,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters ,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5619

	Insert_Dleg_Level_Charge(
		p_charge_type=>g_tl_freight_codes(C_UNLOADED_DISTANCE_RT).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_dleg_alloc_rec.base_dist_unload_chrg,
		p_unit_charge=>	p_dleg_alloc_rec.base_dist_unload_unit_chrg,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters ,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5676

	Insert_Dleg_Level_Charge(
		p_charge_type=>l_unit_freight_code,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_dleg_alloc_rec.base_unit_chrg,
		p_unit_charge=>	p_dleg_alloc_rec.base_unit_unit_chrg,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters ,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5699

	Insert_Dleg_Level_Charge(
		p_charge_type=>g_tl_freight_codes(C_TIME_RT).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_dleg_alloc_rec.base_time_chrg,
		p_unit_charge=>	p_dleg_alloc_rec.base_time_unit_chrg,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters ,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5722

	Insert_Dleg_Level_Charge(
		p_charge_type=>g_tl_freight_codes(C_FLAT_RT).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_dleg_alloc_rec.base_flat_chrg,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters ,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5745

	Insert_Dleg_Level_Charge(
		p_charge_type=>g_tl_freight_codes(C_STOP_OFF_CHRG).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_dleg_alloc_rec.stop_off_chrg,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters ,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5767

	Insert_Dleg_Level_Charge(
		p_charge_type=>g_tl_freight_codes(C_OUT_OF_ROUTE_CHRG).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_dleg_alloc_rec.out_of_route_chrg,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters ,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5791

	Insert_Dleg_Level_Charge(
		g_tl_freight_codes(C_DOCUMENT_CHRG).fte_summary_code_id,
		'SUMMARY',
		p_dleg_alloc_rec.document_chrg,
		NULL,
		l_freight_rec_common,
		p_cost_allocation_parameters ,
		x_output_cost_tab);

Line: 5802

	Insert_Dleg_Level_Charge(
		p_charge_type=>g_tl_freight_codes(C_HANDLING_CHRG).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_dleg_alloc_rec.handling_chrg,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters ,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5825

	Insert_Dleg_Level_Charge(
		p_charge_type=>g_tl_freight_codes(C_FUEL_CHRG).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_dleg_alloc_rec.fuel_chrg,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters ,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5850

	Insert_Dleg_Level_Charge(
		p_charge_type=>g_tl_freight_codes(C_WEEKDAY_LAYOVER_CHRG).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_dleg_alloc_rec.weekday_layover_chrg,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters ,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5872

	Insert_Dleg_Level_Charge(
		p_charge_type=>g_tl_freight_codes(C_WEEKEND_LAYOVER_CHRG).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_dleg_alloc_rec.weekend_layover_chrg,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters ,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5895

	Insert_Dleg_Level_Charge(
		p_charge_type=>g_tl_freight_codes(C_LOADING_CHRG).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_dleg_alloc_rec.loading_chrg,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters ,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5916

	Insert_Dleg_Level_Charge(
		p_charge_type=>g_tl_freight_codes(C_AST_LOADING_CHRG).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_dleg_alloc_rec.ast_loading_chrg,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters ,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5939

	Insert_Dleg_Level_Charge(
		p_charge_type=>g_tl_freight_codes(C_UNLOADING_CHRG).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_dleg_alloc_rec.unloading_chrg,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters ,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5961

	Insert_Dleg_Level_Charge(
		p_charge_type=>g_tl_freight_codes(C_AST_UNLOADING_CHRG).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_dleg_alloc_rec.ast_unloading_chrg,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters ,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 5983

	Insert_Dleg_Level_Charge(
		p_charge_type=>g_tl_freight_codes(C_ORIGIN_SURCHRG).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_dleg_alloc_rec.origin_surchrg,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters ,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 6006

	Insert_Dleg_Level_Charge(
		p_charge_type=>g_tl_freight_codes(C_DESTINATION_SURCHRG).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_dleg_alloc_rec.destination_surchrg,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters ,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 6044

	Insert_Dleg_Level_Charge(
		p_charge_type=>g_tl_freight_codes(F_LOADING_CHRG).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	l_charge,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters ,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 6083

	Insert_Dleg_Level_Charge(
		p_charge_type=>g_tl_freight_codes(F_AST_LOADING_CHRG).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	l_charge,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters ,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 6123

	Insert_Dleg_Level_Charge(
		p_charge_type=>g_tl_freight_codes(F_UNLOADING_CHRG).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	l_charge,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters ,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 6164

	Insert_Dleg_Level_Charge(
		p_charge_type=>g_tl_freight_codes(F_AST_UNLOADING_CHRG).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	l_charge,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters ,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 6203

	Insert_Dleg_Level_Charge(
		p_charge_type=>g_tl_freight_codes(F_HANDLING_CHRG).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	l_charge,
		p_unit_charge=>	NULL,
		p_freight_rec=>	l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters ,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 6430

	l_freight_rec_common.last_update_date := sysdate;

Line: 6431

        l_freight_rec_common.last_updated_by := FND_GLOBAL.USER_ID;

Line: 6432

        l_freight_rec_common.last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 6503

		Insert_Dlv_Dtl_Level_Charge(
			 p_charge_type=>l_unit_freight_code,
			 p_line_type_code=>	'TLPRICE',
			 p_charge=>p_factor*p_dleg_alloc_rec.base_unit_chrg,
			 p_unit_charge=>p_factor*p_dleg_alloc_rec.base_unit_unit_chrg,
			 p_freight_rec=>l_freight_rec_common,
			 p_cost_allocation_parameters=>	p_cost_allocation_parameters,
			 x_output_cost_tab=>	x_output_cost_tab,
			 x_return_status=>	l_return_status);

Line: 6529

			Insert_Dlv_Dtl_Level_Charge(
			 p_charge_type=>	g_tl_freight_codes(C_CONTINUOUS_MOVE_DISTANCE_RT
				).fte_price_code_id,
			 p_line_type_code=>	'TLPRICE',
			 p_charge=>p_factor*p_dleg_alloc_rec.base_dist_load_chrg,
			 p_unit_charge=>p_factor*p_dleg_alloc_rec.base_dist_load_unit_chrg,
			 p_freight_rec=>l_freight_rec_common,
			 p_cost_allocation_parameters=>	p_cost_allocation_parameters,
			 x_output_cost_tab=>	x_output_cost_tab,
			 x_return_status=>	l_return_status);

Line: 6552

			Insert_Dlv_Dtl_Level_Charge(
			 p_charge_type=>g_tl_freight_codes(C_LOADED_DISTANCE_RT).fte_price_code_id,
			 p_line_type_code=>	'TLPRICE',
			 p_charge=>p_factor*p_dleg_alloc_rec.base_dist_load_chrg,
			 p_unit_charge=>p_factor*p_dleg_alloc_rec.base_dist_load_unit_chrg,
			 p_freight_rec=>l_freight_rec_common,
			 p_cost_allocation_parameters=>	p_cost_allocation_parameters,
			 x_output_cost_tab=>	x_output_cost_tab,
			 x_return_status=>	l_return_status);

Line: 6578

		Insert_Dlv_Dtl_Level_Charge(
			 p_charge_type=>g_tl_freight_codes(C_UNLOADED_DISTANCE_RT).fte_price_code_id,
			 p_line_type_code=>	'TLPRICE',
			 p_charge=>p_factor*p_dleg_alloc_rec.base_dist_unload_chrg,
			 p_unit_charge=>p_factor*p_dleg_alloc_rec.base_dist_unload_unit_chrg,
			 p_freight_rec=>l_freight_rec_common,
			 p_cost_allocation_parameters=>	p_cost_allocation_parameters,
			 x_output_cost_tab=>	x_output_cost_tab,
			 x_return_status=>	l_return_status);

Line: 6603

		Insert_Dlv_Dtl_Level_Charge(
			 p_charge_type=>g_tl_freight_codes(C_TIME_RT).fte_price_code_id,
			 p_line_type_code=>	'TLPRICE',
			 p_charge=>p_factor*p_dleg_alloc_rec.base_time_chrg,
			 p_unit_charge=>p_factor*p_dleg_alloc_rec.base_time_unit_chrg,
			 p_freight_rec=>l_freight_rec_common,
			 p_cost_allocation_parameters=>	p_cost_allocation_parameters,
			 x_output_cost_tab=>	x_output_cost_tab,
			 x_return_status=>	l_return_status);

Line: 6626

		Insert_Dlv_Dtl_Level_Charge(
			 p_charge_type=>g_tl_freight_codes(C_FLAT_RT).fte_price_code_id,
			 p_line_type_code=>	'TLPRICE',
			 p_charge=>p_factor*p_dleg_alloc_rec.base_flat_chrg,
			 p_unit_charge=>NULL,
			 p_freight_rec=>l_freight_rec_common,
			 p_cost_allocation_parameters=>	p_cost_allocation_parameters,
			 x_output_cost_tab=>	x_output_cost_tab,
			 x_return_status=>	l_return_status);

Line: 6649

		Insert_Dlv_Dtl_Level_Charge(
			 p_charge_type=>g_tl_freight_codes(C_STOP_OFF_CHRG).fte_charge_code_id,
			 p_line_type_code=>	'TLCHARGE',
			 p_charge=>p_factor*p_dleg_alloc_rec.stop_off_chrg,
			 p_unit_charge=>NULL,
			 p_freight_rec=>l_freight_rec_common,
			 p_cost_allocation_parameters=>	p_cost_allocation_parameters,
			 x_output_cost_tab=>	x_output_cost_tab,
			 x_return_status=>	l_return_status);

Line: 6673

		Insert_Dlv_Dtl_Level_Charge(
			 p_charge_type=>g_tl_freight_codes(C_OUT_OF_ROUTE_CHRG).fte_charge_code_id,
			 p_line_type_code=>	'TLCHARGE',
			 p_charge=>p_factor*p_dleg_alloc_rec.out_of_route_chrg,
			 p_unit_charge=>NULL,
			 p_freight_rec=>l_freight_rec_common,
			 p_cost_allocation_parameters=>	p_cost_allocation_parameters,
			 x_output_cost_tab=>	x_output_cost_tab,
			 x_return_status=>	l_return_status);

Line: 6696

		Insert_Dlv_Dtl_Level_Charge(
			 p_charge_type=>g_tl_freight_codes(C_HANDLING_CHRG).fte_charge_code_id,
			 p_line_type_code=>	'TLCHARGE',
			 p_charge=>p_factor*p_dleg_alloc_rec.handling_chrg,
			 p_unit_charge=>NULL,
			 p_freight_rec=>l_freight_rec_common,
			 p_cost_allocation_parameters=>	p_cost_allocation_parameters,
			 x_output_cost_tab=>	x_output_cost_tab,
			 x_return_status=>	l_return_status);

Line: 6720

		Insert_Dlv_Dtl_Level_Charge(
			 p_charge_type=>g_tl_freight_codes(C_FUEL_CHRG).fte_charge_code_id,
			 p_line_type_code=>	'TLCHARGE',
			 p_charge=>p_factor*p_dleg_alloc_rec.fuel_chrg,
			 p_unit_charge=>NULL,
			 p_freight_rec=>l_freight_rec_common,
			 p_cost_allocation_parameters=>	p_cost_allocation_parameters,
			 x_output_cost_tab=>	x_output_cost_tab,
			 x_return_status=>	l_return_status);

Line: 6744

		Insert_Dlv_Dtl_Level_Charge(
			 p_charge_type=>g_tl_freight_codes(C_WEEKDAY_LAYOVER_CHRG).fte_charge_code_id,
			 p_line_type_code=>	'TLCHARGE',
			 p_charge=>p_factor*p_dleg_alloc_rec.weekday_layover_chrg,
			 p_unit_charge=>NULL,
			 p_freight_rec=>l_freight_rec_common,
			 p_cost_allocation_parameters=>	p_cost_allocation_parameters,
			 x_output_cost_tab=>	x_output_cost_tab,
			 x_return_status=>	l_return_status);

Line: 6768

		Insert_Dlv_Dtl_Level_Charge(
			 p_charge_type=>g_tl_freight_codes(C_WEEKEND_LAYOVER_CHRG).fte_charge_code_id,
			 p_line_type_code=>	'TLCHARGE',
			 p_charge=>p_factor*p_dleg_alloc_rec.weekend_layover_chrg,
			 p_unit_charge=>NULL,
			 p_freight_rec=>l_freight_rec_common,
			 p_cost_allocation_parameters=>	p_cost_allocation_parameters,
			 x_output_cost_tab=>	x_output_cost_tab,
			 x_return_status=>	l_return_status);

Line: 6792

		' BEFORE INSERTING loading charge '|| g_tl_freight_codes(C_LOADING_CHRG).fte_charge_code_id|| '*');

Line: 6796

		Insert_Dlv_Dtl_Level_Charge(
			 p_charge_type=>g_tl_freight_codes(C_LOADING_CHRG).fte_charge_code_id,
			 p_line_type_code=>	'TLCHARGE',
			 p_charge=>p_factor*p_dleg_alloc_rec.loading_chrg,
			 p_unit_charge=>NULL,
			 p_freight_rec=>l_freight_rec_common,
			 p_cost_allocation_parameters=>	p_cost_allocation_parameters,
			 x_output_cost_tab=>	x_output_cost_tab,
			 x_return_status=>	l_return_status);

Line: 6817

		' AFTER INSERTING loading charge '|| g_tl_freight_codes(C_LOADING_CHRG).fte_charge_code_id|| '*');

Line: 6822

		Insert_Dlv_Dtl_Level_Charge(
			 p_charge_type=>g_tl_freight_codes(C_AST_LOADING_CHRG).fte_charge_code_id,
			 p_line_type_code=>	'TLCHARGE',
			 p_charge=>p_factor*p_dleg_alloc_rec.ast_loading_chrg,
			 p_unit_charge=>NULL,
			 p_freight_rec=>l_freight_rec_common,
			 p_cost_allocation_parameters=>	p_cost_allocation_parameters,
			 x_output_cost_tab=>	x_output_cost_tab,
			 x_return_status=>	l_return_status);

Line: 6845

		Insert_Dlv_Dtl_Level_Charge(
			 p_charge_type=>g_tl_freight_codes(C_UNLOADING_CHRG).fte_charge_code_id,
			 p_line_type_code=>	'TLCHARGE',
			 p_charge=>p_factor*p_dleg_alloc_rec.unloading_chrg,
			 p_unit_charge=>NULL,
			 p_freight_rec=>l_freight_rec_common,
			 p_cost_allocation_parameters=>	p_cost_allocation_parameters,
			 x_output_cost_tab=>	x_output_cost_tab,
			 x_return_status=>	l_return_status);

Line: 6869

		Insert_Dlv_Dtl_Level_Charge(
			 p_charge_type=>g_tl_freight_codes(C_AST_UNLOADING_CHRG).fte_charge_code_id,
			 p_line_type_code=>	'TLCHARGE',
			 p_charge=>p_factor*p_dleg_alloc_rec.ast_unloading_chrg,
			 p_unit_charge=>NULL,
			 p_freight_rec=>l_freight_rec_common,
			 p_cost_allocation_parameters=>	p_cost_allocation_parameters,
			 x_output_cost_tab=>	x_output_cost_tab,
			 x_return_status=>	l_return_status);

Line: 6894

		Insert_Dlv_Dtl_Level_Charge(
			 p_charge_type=>g_tl_freight_codes(C_ORIGIN_SURCHRG).fte_charge_code_id,
			 p_line_type_code=>	'TLCHARGE',
			 p_charge=>p_factor*p_dleg_alloc_rec.origin_surchrg,
			 p_unit_charge=>NULL,
			 p_freight_rec=>l_freight_rec_common,
			 p_cost_allocation_parameters=>	p_cost_allocation_parameters,
			 x_output_cost_tab=>	x_output_cost_tab,
			 x_return_status=>	l_return_status);

Line: 6918

		Insert_Dlv_Dtl_Level_Charge(
			 p_charge_type=>g_tl_freight_codes(C_DESTINATION_SURCHRG).fte_charge_code_id,
			 p_line_type_code=>	'TLCHARGE',
			 p_charge=>p_factor*p_dleg_alloc_rec.destination_surchrg,
			 p_unit_charge=>NULL,
			 p_freight_rec=>l_freight_rec_common,
			 p_cost_allocation_parameters=>	p_cost_allocation_parameters,
			 x_output_cost_tab=>	x_output_cost_tab,
			 x_return_status=>	l_return_status);

Line: 6963

		Insert_Dlv_Dtl_Level_Charge(
			 p_charge_type=>g_tl_freight_codes(F_LOADING_CHRG).fte_charge_code_id,
			 p_line_type_code=>	'TLCHARGE',
			 p_charge=>p_factor*l_charge,
			 p_unit_charge=>NULL,
			 p_freight_rec=>l_freight_rec_common,
			 p_cost_allocation_parameters=>	p_cost_allocation_parameters,
			 x_output_cost_tab=>	x_output_cost_tab,
			 x_return_status=>	l_return_status);

Line: 7003

		Insert_Dlv_Dtl_Level_Charge(
			 p_charge_type=>g_tl_freight_codes(F_AST_LOADING_CHRG).fte_charge_code_id,
			 p_line_type_code=>	'TLCHARGE',
			 p_charge=>p_factor*l_charge,
			 p_unit_charge=>NULL,
			 p_freight_rec=>l_freight_rec_common,
			 p_cost_allocation_parameters=>	p_cost_allocation_parameters,
			 x_output_cost_tab=>	x_output_cost_tab,
			 x_return_status=>	l_return_status);

Line: 7044

		Insert_Dlv_Dtl_Level_Charge(
			 p_charge_type=>g_tl_freight_codes(F_UNLOADING_CHRG).fte_charge_code_id,
			 p_line_type_code=>	'TLCHARGE',
			 p_charge=>p_factor*l_charge,
			 p_unit_charge=>NULL,
			 p_freight_rec=>l_freight_rec_common,
			 p_cost_allocation_parameters=>	p_cost_allocation_parameters,
			 x_output_cost_tab=>	x_output_cost_tab,
			 x_return_status=>	l_return_status);

Line: 7084

		Insert_Dlv_Dtl_Level_Charge(
			 p_charge_type=>g_tl_freight_codes(F_AST_UNLOADING_CHRG).fte_charge_code_id,
			 p_line_type_code=>	'TLCHARGE',
			 p_charge=>p_factor*l_charge,
			 p_unit_charge=>NULL,
			 p_freight_rec=>l_freight_rec_common,
			 p_cost_allocation_parameters=>	p_cost_allocation_parameters,
			 x_output_cost_tab=>	x_output_cost_tab,
			 x_return_status=>	l_return_status);

Line: 7128

		Insert_Dlv_Dtl_Level_Charge(
			 p_charge_type=>g_tl_freight_codes(F_HANDLING_CHRG).fte_charge_code_id,
			 p_line_type_code=>	'TLCHARGE',
			 p_charge=>p_factor*l_charge,
			 p_unit_charge=>NULL,
			 p_freight_rec=>l_freight_rec_common,
			 p_cost_allocation_parameters=>	p_cost_allocation_parameters,
			 x_output_cost_tab=>	x_output_cost_tab,
			 x_return_status=>	l_return_status);

Line: 7152

	Insert_Dlv_Dtl_Level_Charge(
		p_charge_type=>	g_tl_freight_codes(C_SUMMARY).fte_summary_code_id,
		p_line_type_code=>	'SUMMARY',
		p_charge=>	p_factor*p_dleg_alloc_rec.total_dleg_charge,
		p_unit_charge=>NULL,
		p_freight_rec=>l_freight_rec_common,
		p_cost_allocation_parameters=>	p_cost_allocation_parameters,
		x_output_cost_tab=>	x_output_cost_tab,
		x_return_status=>	l_return_status);

Line: 8122

    	SELECT stop_id
    	FROM wsh_trip_stops
    	WHERE  trip_id = c_trip_id
    	FOR UPDATE NOWAIT;

Line: 8260

		Bulk_Insert_Temp(x_return_status=>x_return_status);

Line: 8301

          FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'got update lock of wsh_trip_stops');

Line: 8318

	    g_stop_id_tbl.DELETE;

Line: 8319

	    g_distance_to_next_stop_tbl.DELETE;

Line: 8330

	      UPDATE wsh_trip_stops
	      SET  	distance_to_next_stop = g_distance_to_next_stop_tbl(i),
	   	  	distance_uom = l_distance_uom
	      WHERE stop_id = g_stop_id_tbl(i);

Line: 8334

            FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'bulk update wsh_trip_stops done');

Line: 8338

		'stop index range is wrong. wsh_trip_stops is not updated with distance');