eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_TRIP_RATING_GRP dependencies on FTE_ID_TAB_TYPE

Line 497: p_lane_sched_id_tab IN FTE_ID_TAB_TYPE, -- lane_ids or schedule_ids

493: p_api_version IN NUMBER DEFAULT 1.0,
494: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
495: p_init_prc_log IN VARCHAR2 DEFAULT 'Y',
496: p_trip_id IN NUMBER DEFAULT NULL,
497: p_lane_sched_id_tab IN FTE_ID_TAB_TYPE, -- lane_ids or schedule_ids
498: p_lane_sched_tab IN FTE_CODE_TAB_TYPE, -- 'L' or 'S' (Lane or Schedule)
499: p_mode_tab IN FTE_CODE_TAB_TYPE,
500: p_service_type_tab IN FTE_CODE_TAB_TYPE,
501: p_vehicle_type_tab IN FTE_ID_TAB_TYPE,

Line 501: p_vehicle_type_tab IN FTE_ID_TAB_TYPE,

497: p_lane_sched_id_tab IN FTE_ID_TAB_TYPE, -- lane_ids or schedule_ids
498: p_lane_sched_tab IN FTE_CODE_TAB_TYPE, -- 'L' or 'S' (Lane or Schedule)
499: p_mode_tab IN FTE_CODE_TAB_TYPE,
500: p_service_type_tab IN FTE_CODE_TAB_TYPE,
501: p_vehicle_type_tab IN FTE_ID_TAB_TYPE,
502: p_dep_date IN DATE DEFAULT sysdate,
503: p_arr_date IN DATE DEFAULT sysdate,
504: p_event IN VARCHAR2 DEFAULT 'FTE_TRIP_COMP',
505: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 507: x_lane_sched_id_tab OUT NOCOPY FTE_ID_TAB_TYPE, -- lane_ids or schedule_ids

503: p_arr_date IN DATE DEFAULT sysdate,
504: p_event IN VARCHAR2 DEFAULT 'FTE_TRIP_COMP',
505: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
506: x_request_id OUT NOCOPY NUMBER,
507: x_lane_sched_id_tab OUT NOCOPY FTE_ID_TAB_TYPE, -- lane_ids or schedule_ids
508: x_lane_sched_tab OUT NOCOPY FTE_CODE_TAB_TYPE, -- 'L' or 'S' (Lane or Schedule)
509: x_vehicle_type_tab OUT NOCOPY FTE_ID_TAB_TYPE,--Vehicle Type Id
510: x_mode_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
511: x_service_type_tab OUT NOCOPY FTE_CODE_TAB_TYPE,

Line 509: x_vehicle_type_tab OUT NOCOPY FTE_ID_TAB_TYPE,--Vehicle Type Id

505: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
506: x_request_id OUT NOCOPY NUMBER,
507: x_lane_sched_id_tab OUT NOCOPY FTE_ID_TAB_TYPE, -- lane_ids or schedule_ids
508: x_lane_sched_tab OUT NOCOPY FTE_CODE_TAB_TYPE, -- 'L' or 'S' (Lane or Schedule)
509: x_vehicle_type_tab OUT NOCOPY FTE_ID_TAB_TYPE,--Vehicle Type Id
510: x_mode_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
511: x_service_type_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
512: x_sum_rate_tab OUT NOCOPY FTE_ID_TAB_TYPE,
513: x_sum_rate_curr_tab OUT NOCOPY FTE_CODE_TAB_TYPE,

Line 512: x_sum_rate_tab OUT NOCOPY FTE_ID_TAB_TYPE,

508: x_lane_sched_tab OUT NOCOPY FTE_CODE_TAB_TYPE, -- 'L' or 'S' (Lane or Schedule)
509: x_vehicle_type_tab OUT NOCOPY FTE_ID_TAB_TYPE,--Vehicle Type Id
510: x_mode_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
511: x_service_type_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
512: x_sum_rate_tab OUT NOCOPY FTE_ID_TAB_TYPE,
513: x_sum_rate_curr_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
514: x_return_status OUT NOCOPY VARCHAR2,
515: x_msg_count OUT NOCOPY NUMBER,
516: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 792: x_sum_rate_tab := FTE_ID_TAB_TYPE(0);

788: THEN
789:
790: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'Init op tables');
791:
792: x_sum_rate_tab := FTE_ID_TAB_TYPE(0);
793: x_sum_rate_curr_tab := FTE_CODE_TAB_TYPE('NULL');
794: -- init all elements the tables with 0 and 'NULL' resp.
795:
796: x_lane_sched_id_tab:=FTE_ID_TAB_TYPE(0);

Line 796: x_lane_sched_id_tab:=FTE_ID_TAB_TYPE(0);

792: x_sum_rate_tab := FTE_ID_TAB_TYPE(0);
793: x_sum_rate_curr_tab := FTE_CODE_TAB_TYPE('NULL');
794: -- init all elements the tables with 0 and 'NULL' resp.
795:
796: x_lane_sched_id_tab:=FTE_ID_TAB_TYPE(0);
797: x_lane_sched_tab:=FTE_CODE_TAB_TYPE('NULL');
798: x_vehicle_type_tab:=FTE_ID_TAB_TYPE(0);
799: x_mode_tab:=FTE_CODE_TAB_TYPE('NULL');
800: x_service_type_tab:=FTE_CODE_TAB_TYPE('NULL');

Line 798: x_vehicle_type_tab:=FTE_ID_TAB_TYPE(0);

794: -- init all elements the tables with 0 and 'NULL' resp.
795:
796: x_lane_sched_id_tab:=FTE_ID_TAB_TYPE(0);
797: x_lane_sched_tab:=FTE_CODE_TAB_TYPE('NULL');
798: x_vehicle_type_tab:=FTE_ID_TAB_TYPE(0);
799: x_mode_tab:=FTE_CODE_TAB_TYPE('NULL');
800: x_service_type_tab:=FTE_CODE_TAB_TYPE('NULL');
801:
802:

Line 1032: p_lane_sched_id_tab IN FTE_ID_TAB_TYPE,

1028: PROCEDURE Compare_Trip_Rates (
1029: p_api_version IN NUMBER DEFAULT 1.0,
1030: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1031: p_trip_id IN NUMBER DEFAULT NULL,
1032: p_lane_sched_id_tab IN FTE_ID_TAB_TYPE,
1033: p_lane_sched_tab IN FTE_CODE_TAB_TYPE,
1034: p_mode_tab IN FTE_CODE_TAB_TYPE,
1035: p_service_type_tab IN FTE_CODE_TAB_TYPE,
1036: p_vehicle_id_tab IN FTE_ID_TAB_TYPE,

Line 1036: p_vehicle_id_tab IN FTE_ID_TAB_TYPE,

1032: p_lane_sched_id_tab IN FTE_ID_TAB_TYPE,
1033: p_lane_sched_tab IN FTE_CODE_TAB_TYPE,
1034: p_mode_tab IN FTE_CODE_TAB_TYPE,
1035: p_service_type_tab IN FTE_CODE_TAB_TYPE,
1036: p_vehicle_id_tab IN FTE_ID_TAB_TYPE,
1037: p_dep_date IN DATE DEFAULT sysdate,
1038: p_arr_date IN DATE DEFAULT sysdate,
1039: p_event IN VARCHAR2 DEFAULT 'FTE_TRIP_COMP',
1040: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 1042: x_sum_rate_tab OUT NOCOPY FTE_ID_TAB_TYPE,

1038: p_arr_date IN DATE DEFAULT sysdate,
1039: p_event IN VARCHAR2 DEFAULT 'FTE_TRIP_COMP',
1040: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1041: x_request_id OUT NOCOPY NUMBER,
1042: x_sum_rate_tab OUT NOCOPY FTE_ID_TAB_TYPE,
1043: x_sum_rate_curr_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
1044: x_return_status OUT NOCOPY VARCHAR2,
1045: x_msg_count OUT NOCOPY NUMBER,
1046: x_msg_data OUT NOCOPY VARCHAR2)

Line 3673: l_lane_sched_id_tab FTE_ID_TAB_TYPE; -- lane_ids or schedule_ids

3669: l_sort_rank_ref DBMS_UTILITY.NUMBER_ARRAY;
3670:
3671: l_elim_rank_ref DBMS_UTILITY.NUMBER_ARRAY;
3672:
3673: l_lane_sched_id_tab FTE_ID_TAB_TYPE; -- lane_ids or schedule_ids
3674: l_lane_sched_tab FTE_CODE_TAB_TYPE; -- 'L' or 'S' (Lane or Schedule)
3675: l_mode_tab FTE_CODE_TAB_TYPE;
3676: l_service_type_tab FTE_CODE_TAB_TYPE;
3677: l_vehicle_type_tab FTE_ID_TAB_TYPE;

Line 3677: l_vehicle_type_tab FTE_ID_TAB_TYPE;

3673: l_lane_sched_id_tab FTE_ID_TAB_TYPE; -- lane_ids or schedule_ids
3674: l_lane_sched_tab FTE_CODE_TAB_TYPE; -- 'L' or 'S' (Lane or Schedule)
3675: l_mode_tab FTE_CODE_TAB_TYPE;
3676: l_service_type_tab FTE_CODE_TAB_TYPE;
3677: l_vehicle_type_tab FTE_ID_TAB_TYPE;
3678:
3679: l_out_lane_sched_id_tab FTE_ID_TAB_TYPE; -- lane_ids or schedule_ids
3680: l_out_lane_sched_tab FTE_CODE_TAB_TYPE; -- 'L' or 'S' (Lane or Schedule)
3681: l_out_mode_tab FTE_CODE_TAB_TYPE;

Line 3679: l_out_lane_sched_id_tab FTE_ID_TAB_TYPE; -- lane_ids or schedule_ids

3675: l_mode_tab FTE_CODE_TAB_TYPE;
3676: l_service_type_tab FTE_CODE_TAB_TYPE;
3677: l_vehicle_type_tab FTE_ID_TAB_TYPE;
3678:
3679: l_out_lane_sched_id_tab FTE_ID_TAB_TYPE; -- lane_ids or schedule_ids
3680: l_out_lane_sched_tab FTE_CODE_TAB_TYPE; -- 'L' or 'S' (Lane or Schedule)
3681: l_out_mode_tab FTE_CODE_TAB_TYPE;
3682: l_out_service_type_tab FTE_CODE_TAB_TYPE;
3683: l_out_vehicle_type_tab FTE_ID_TAB_TYPE;

Line 3683: l_out_vehicle_type_tab FTE_ID_TAB_TYPE;

3679: l_out_lane_sched_id_tab FTE_ID_TAB_TYPE; -- lane_ids or schedule_ids
3680: l_out_lane_sched_tab FTE_CODE_TAB_TYPE; -- 'L' or 'S' (Lane or Schedule)
3681: l_out_mode_tab FTE_CODE_TAB_TYPE;
3682: l_out_service_type_tab FTE_CODE_TAB_TYPE;
3683: l_out_vehicle_type_tab FTE_ID_TAB_TYPE;
3684:
3685: l_sum_rate_tab FTE_ID_TAB_TYPE;
3686: l_sum_rate_curr_tab FTE_CODE_TAB_TYPE;
3687: l_request_id NUMBER;

Line 3685: l_sum_rate_tab FTE_ID_TAB_TYPE;

3681: l_out_mode_tab FTE_CODE_TAB_TYPE;
3682: l_out_service_type_tab FTE_CODE_TAB_TYPE;
3683: l_out_vehicle_type_tab FTE_ID_TAB_TYPE;
3684:
3685: l_sum_rate_tab FTE_ID_TAB_TYPE;
3686: l_sum_rate_curr_tab FTE_CODE_TAB_TYPE;
3687: l_request_id NUMBER;
3688: l_return_status VARCHAR2(1);
3689: l_rating_API_fail VARCHAR2(1);

Line 3816: l_lane_sched_id_tab:=FTE_ID_TAB_TYPE();

3812:
3813:
3814: --Prepare inputs for rating
3815:
3816: l_lane_sched_id_tab:=FTE_ID_TAB_TYPE();
3817: l_lane_sched_tab:=FTE_CODE_TAB_TYPE();
3818: l_mode_tab:=FTE_CODE_TAB_TYPE();
3819: l_service_type_tab:=FTE_CODE_TAB_TYPE();
3820: l_vehicle_type_tab:=FTE_ID_TAB_TYPE();

Line 3820: l_vehicle_type_tab:=FTE_ID_TAB_TYPE();

3816: l_lane_sched_id_tab:=FTE_ID_TAB_TYPE();
3817: l_lane_sched_tab:=FTE_CODE_TAB_TYPE();
3818: l_mode_tab:=FTE_CODE_TAB_TYPE();
3819: l_service_type_tab:=FTE_CODE_TAB_TYPE();
3820: l_vehicle_type_tab:=FTE_ID_TAB_TYPE();
3821:
3822: l_laneSched_count:=l_elim_rank_tab.COUNT;
3823:
3824: l_lane_sched_id_tab.EXTEND(l_laneSched_count);