DBA Data[Home] [Help]

APPS.FTE_TRIP_RATING_GRP dependencies on FTE_ID_TAB_TYPE

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

166: p_api_version IN NUMBER DEFAULT 1.0,
167: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
168: p_init_prc_log IN VARCHAR2 DEFAULT 'Y',
169: p_trip_id IN NUMBER DEFAULT NULL,
170: p_lane_sched_id_tab IN FTE_ID_TAB_TYPE, -- lane_ids or schedule_ids
171: p_lane_sched_tab IN FTE_CODE_TAB_TYPE, -- 'L' or 'S' (Lane or Schedule)
172: p_mode_tab IN FTE_CODE_TAB_TYPE,
173: p_service_type_tab IN FTE_CODE_TAB_TYPE,
174: p_vehicle_type_tab IN FTE_ID_TAB_TYPE,

Line 174: p_vehicle_type_tab IN FTE_ID_TAB_TYPE,

170: p_lane_sched_id_tab IN FTE_ID_TAB_TYPE, -- lane_ids or schedule_ids
171: p_lane_sched_tab IN FTE_CODE_TAB_TYPE, -- 'L' or 'S' (Lane or Schedule)
172: p_mode_tab IN FTE_CODE_TAB_TYPE,
173: p_service_type_tab IN FTE_CODE_TAB_TYPE,
174: p_vehicle_type_tab IN FTE_ID_TAB_TYPE,
175: p_dep_date IN DATE DEFAULT sysdate,
176: p_arr_date IN DATE DEFAULT sysdate,
177: p_event IN VARCHAR2 DEFAULT 'FTE_TRIP_COMP',
178: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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

176: p_arr_date IN DATE DEFAULT sysdate,
177: p_event IN VARCHAR2 DEFAULT 'FTE_TRIP_COMP',
178: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
179: x_request_id OUT NOCOPY NUMBER,
180: x_lane_sched_id_tab OUT NOCOPY FTE_ID_TAB_TYPE, -- lane_ids or schedule_ids
181: x_lane_sched_tab OUT NOCOPY FTE_CODE_TAB_TYPE, -- 'L' or 'S' (Lane or Schedule)
182: x_vehicle_type_tab OUT NOCOPY FTE_ID_TAB_TYPE,--Vehicle Type Id
183: x_mode_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
184: x_service_type_tab OUT NOCOPY FTE_CODE_TAB_TYPE,

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

178: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
179: x_request_id OUT NOCOPY NUMBER,
180: x_lane_sched_id_tab OUT NOCOPY FTE_ID_TAB_TYPE, -- lane_ids or schedule_ids
181: x_lane_sched_tab OUT NOCOPY FTE_CODE_TAB_TYPE, -- 'L' or 'S' (Lane or Schedule)
182: x_vehicle_type_tab OUT NOCOPY FTE_ID_TAB_TYPE,--Vehicle Type Id
183: x_mode_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
184: x_service_type_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
185: x_sum_rate_tab OUT NOCOPY FTE_ID_TAB_TYPE,
186: x_sum_rate_curr_tab OUT NOCOPY FTE_CODE_TAB_TYPE,

Line 185: x_sum_rate_tab OUT NOCOPY FTE_ID_TAB_TYPE,

181: x_lane_sched_tab OUT NOCOPY FTE_CODE_TAB_TYPE, -- 'L' or 'S' (Lane or Schedule)
182: x_vehicle_type_tab OUT NOCOPY FTE_ID_TAB_TYPE,--Vehicle Type Id
183: x_mode_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
184: x_service_type_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
185: x_sum_rate_tab OUT NOCOPY FTE_ID_TAB_TYPE,
186: x_sum_rate_curr_tab OUT NOCOPY FTE_CODE_TAB_TYPE,
187: x_return_status OUT NOCOPY VARCHAR2,
188: x_msg_count OUT NOCOPY NUMBER,
189: x_msg_data OUT NOCOPY VARCHAR2);