DBA Data[Home] [Help]

APPS.FTE_TRIP_RATING_GRP dependencies on FND_API

Line 48: -- p_commit => FND_API.G_FALSE / G_TRUE

44: -- -> caller -> 'FTE','WSH'
45: -- -> event -> 'TP-RELEASE','SHIP-CONFIRM','RE-RATING'
46: -- -> action -> 'RATE'
47: -- -> trip_id -> valid wsh trip_id
48: -- p_commit => FND_API.G_FALSE / G_TRUE
49: -- Output:
50: -- x_return_status OUT NOCOPY VARCHAR2 => Return status
51: --
52: -- Global dependencies:

Line 62: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

58:
59:
60: PROCEDURE Rate_Trip (
61: p_api_version IN NUMBER DEFAULT 1.0,
62: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
63: p_action_params IN FTE_TRIP_RATING_GRP.action_param_rec,
64: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
65: p_init_prc_log IN VARCHAR2 DEFAULT 'Y',
66: x_return_status OUT NOCOPY VARCHAR2,

Line 64: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

60: PROCEDURE Rate_Trip (
61: p_api_version IN NUMBER DEFAULT 1.0,
62: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
63: p_action_params IN FTE_TRIP_RATING_GRP.action_param_rec,
64: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
65: p_init_prc_log IN VARCHAR2 DEFAULT 'Y',
66: x_return_status OUT NOCOPY VARCHAR2,
67: x_msg_count OUT NOCOPY NUMBER,
68: x_msg_data OUT NOCOPY VARCHAR2);

Line 152: -- p_commit => FND_API.G_FALSE / G_TRUE

148: -- p_lane_sched_tab => 'L' or 'S' (Lane or Schedule)
149: -- p_service_type_tab => service type codes
150: -- p_vehicle_id_tab => vehicle item ids
151: -- p_event => Default 'FTE_TRIP_COMP'
152: -- p_commit => FND_API.G_FALSE / G_TRUE
153: -- Output:
154: -- x_request_id => handle to table fte_freight_costs_temp
155: -- x_return_status OUT NOCOPY VARCHAR2 => Return status
156: --

Line 167: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

163:
164:
165: PROCEDURE Compare_Trip_Rates (
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)

Line 178: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,
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

Line 195: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

191:
192:
193: PROCEDURE Search_Rate_Sort(
194: p_api_version IN NUMBER DEFAULT 1.0,
195: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
196: p_event IN VARCHAR2 DEFAULT 'FTE_TRIP_COMP',
197: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
198: p_init_prc_log IN VARCHAR2 DEFAULT 'Y',
199: p_ss_rate_sort_tab IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,

Line 197: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

193: PROCEDURE Search_Rate_Sort(
194: p_api_version IN NUMBER DEFAULT 1.0,
195: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
196: p_event IN VARCHAR2 DEFAULT 'FTE_TRIP_COMP',
197: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
198: p_init_prc_log IN VARCHAR2 DEFAULT 'Y',
199: p_ss_rate_sort_tab IN FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
200: p_ss_rate_sort_atr_rec IN FTE_SS_ATTR_REC,
201: x_ss_rate_sort_tab OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,