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_LANE_LOADER dependencies on FTE_LANE_PKG

Line 19: g_lane_tbl FTE_LANE_PKG.lane_tbl;

15: -- PROCESS_SCHEDULE --
16: -------------------------------------------------------------------------- --
17:
18: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_LANE_LOADER';
19: g_lane_tbl FTE_LANE_PKG.lane_tbl;
20: g_lane_rate_chart_tbl FTE_LANE_PKG.lane_rate_chart_tbl;
21: g_lane_service_tbl FTE_LANE_PKG.lane_service_tbl;
22: g_lane_commodity_tbl FTE_LANE_PKG.lane_commodity_tbl;
23: g_schedule_tbl FTE_LANE_PKG.schedule_tbl;

Line 20: g_lane_rate_chart_tbl FTE_LANE_PKG.lane_rate_chart_tbl;

16: -------------------------------------------------------------------------- --
17:
18: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_LANE_LOADER';
19: g_lane_tbl FTE_LANE_PKG.lane_tbl;
20: g_lane_rate_chart_tbl FTE_LANE_PKG.lane_rate_chart_tbl;
21: g_lane_service_tbl FTE_LANE_PKG.lane_service_tbl;
22: g_lane_commodity_tbl FTE_LANE_PKG.lane_commodity_tbl;
23: g_schedule_tbl FTE_LANE_PKG.schedule_tbl;
24: g_prc_parameter_tbl FTE_LANE_PKG.prc_parameter_tbl;

Line 21: g_lane_service_tbl FTE_LANE_PKG.lane_service_tbl;

17:
18: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_LANE_LOADER';
19: g_lane_tbl FTE_LANE_PKG.lane_tbl;
20: g_lane_rate_chart_tbl FTE_LANE_PKG.lane_rate_chart_tbl;
21: g_lane_service_tbl FTE_LANE_PKG.lane_service_tbl;
22: g_lane_commodity_tbl FTE_LANE_PKG.lane_commodity_tbl;
23: g_schedule_tbl FTE_LANE_PKG.schedule_tbl;
24: g_prc_parameter_tbl FTE_LANE_PKG.prc_parameter_tbl;
25:

Line 22: g_lane_commodity_tbl FTE_LANE_PKG.lane_commodity_tbl;

18: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_LANE_LOADER';
19: g_lane_tbl FTE_LANE_PKG.lane_tbl;
20: g_lane_rate_chart_tbl FTE_LANE_PKG.lane_rate_chart_tbl;
21: g_lane_service_tbl FTE_LANE_PKG.lane_service_tbl;
22: g_lane_commodity_tbl FTE_LANE_PKG.lane_commodity_tbl;
23: g_schedule_tbl FTE_LANE_PKG.schedule_tbl;
24: g_prc_parameter_tbl FTE_LANE_PKG.prc_parameter_tbl;
25:
26: g_lane_function VARCHAR2(100);

Line 23: g_schedule_tbl FTE_LANE_PKG.schedule_tbl;

19: g_lane_tbl FTE_LANE_PKG.lane_tbl;
20: g_lane_rate_chart_tbl FTE_LANE_PKG.lane_rate_chart_tbl;
21: g_lane_service_tbl FTE_LANE_PKG.lane_service_tbl;
22: g_lane_commodity_tbl FTE_LANE_PKG.lane_commodity_tbl;
23: g_schedule_tbl FTE_LANE_PKG.schedule_tbl;
24: g_prc_parameter_tbl FTE_LANE_PKG.prc_parameter_tbl;
25:
26: g_lane_function VARCHAR2(100);
27: g_deficit_wt BOOLEAN := FALSE; -- if it's DEFICIT_WT

Line 24: g_prc_parameter_tbl FTE_LANE_PKG.prc_parameter_tbl;

20: g_lane_rate_chart_tbl FTE_LANE_PKG.lane_rate_chart_tbl;
21: g_lane_service_tbl FTE_LANE_PKG.lane_service_tbl;
22: g_lane_commodity_tbl FTE_LANE_PKG.lane_commodity_tbl;
23: g_schedule_tbl FTE_LANE_PKG.schedule_tbl;
24: g_prc_parameter_tbl FTE_LANE_PKG.prc_parameter_tbl;
25:
26: g_lane_function VARCHAR2(100);
27: g_deficit_wt BOOLEAN := FALSE; -- if it's DEFICIT_WT
28: g_first BOOLEAN := TRUE; -- if it's New Lane

Line 150: FTE_LANE_PKG.DELETE_ROW(p_id => g_lane_tbl(g_lane_tbl.COUNT).lane_id,

146: END IF;
147:
148: IF (l_action = 'DELETE') THEN
149: IF (l_type = 'SERVICE') THEN
150: FTE_LANE_PKG.DELETE_ROW(p_id => g_lane_tbl(g_lane_tbl.COUNT).lane_id,
151: p_table => 'FTE_LANES',
152: p_code => NULL,
153: p_line_number => p_line_number+i+1,
154: x_status => x_status,

Line 163: FTE_LANE_PKG.DELETE_ROW(p_id => g_lane_rate_chart_tbl(g_lane_rate_chart_tbl.COUNT).lane_id,

159: END IF;
160:
161: g_lane_tbl(g_lane_tbl.COUNT).lane_id := 0; -- set to 0 so the next component line can be skipped
162: ELSIF (l_type = 'RATE_CHART' AND g_lane_tbl(g_lane_tbl.COUNT).lane_id <> 0) THEN
163: FTE_LANE_PKG.DELETE_ROW(p_id => g_lane_rate_chart_tbl(g_lane_rate_chart_tbl.COUNT).lane_id,
164: p_table => 'FTE_LANE_RATE_CHARTS',
165: p_code => to_char(g_lane_rate_chart_tbl(g_lane_rate_chart_tbl.COUNT).list_header_id),
166: p_line_number => p_line_number+i+1,
167: x_status => x_status,

Line 175: FTE_LANE_PKG.UPDATE_LANE_FLAGS(p_type => l_type,

171: FTE_UTIL_PKG.Exit_Debug(l_module_name);
172: RETURN;
173: END IF;
174:
175: FTE_LANE_PKG.UPDATE_LANE_FLAGS(p_type => l_type,
176: p_lane_id => g_lane_rate_chart_tbl(g_lane_rate_chart_tbl.COUNT).lane_id,
177: x_status => x_status,
178: x_error_msg => x_error_msg);
179:

Line 187: l_find_lane := FTE_LANE_PKG.FIND_TYPE(p_type => 'SERVICE_LEVEL',

183: END IF;
184:
185: g_lane_rate_chart_tbl.DELETE(g_lane_rate_chart_tbl.COUNT);
186: ELSIF (l_type = 'SERVICE_TYPE' AND g_lane_tbl(g_lane_tbl.COUNT).lane_id <> 0) THEN
187: l_find_lane := FTE_LANE_PKG.FIND_TYPE(p_type => 'SERVICE_LEVEL',
188: p_value => g_lane_service_tbl(g_lane_service_tbl.COUNT).service_code,
189: p_lane_id => g_lane_tbl(g_lane_tbl.COUNT).lane_id,
190: p_line_number => p_line_number+i+1,
191: x_status => x_status,

Line 200: FTE_LANE_PKG.DELETE_ROW(p_id => g_lane_tbl(g_lane_tbl.COUNT).lane_id,

196: RETURN;
197: END IF;
198:
199: IF (l_find_lane) THEN
200: FTE_LANE_PKG.DELETE_ROW(p_id => g_lane_tbl(g_lane_tbl.COUNT).lane_id,
201: p_table => 'FTE_LANE_SERVICES',
202: p_code => g_lane_service_tbl(g_lane_service_tbl.COUNT).service_code,
203: p_line_number => p_line_number+i+1,
204: x_status => x_status,

Line 211: FTE_LANE_PKG.UPDATE_LANE_FLAGS(p_type => l_type,

207: FTE_UTIL_PKG.Exit_Debug(l_module_name);
208: RETURN;
209: END IF;
210:
211: FTE_LANE_PKG.UPDATE_LANE_FLAGS(p_type => l_type,
212: p_lane_id => g_lane_tbl(g_lane_tbl.COUNT).lane_id,
213: x_status => x_status,
214: x_error_msg => x_error_msg);
215:

Line 225: l_find_lane := FTE_LANE_PKG.FIND_TYPE(p_type => 'COMMODITY',

221: END IF;
222:
223: g_lane_service_tbl.DELETE(g_lane_service_tbl.COUNT);
224: ELSIF (l_type = 'COMMODITY_TYPE' AND g_lane_tbl(g_lane_tbl.COUNT).lane_id <> 0) THEN
225: l_find_lane := FTE_LANE_PKG.FIND_TYPE(p_type => 'COMMODITY',
226: p_value => TO_CHAR(g_lane_commodity_tbl(g_lane_commodity_tbl.COUNT).commodity_catg_id),
227: p_lane_id => g_lane_tbl(g_lane_tbl.COUNT).lane_id,
228: p_line_number => p_line_number+i+1,
229: x_status => x_status,

Line 238: FTE_LANE_PKG.DELETE_ROW(p_id => g_lane_tbl(g_lane_tbl.COUNT).lane_id,

234: RETURN;
235: END IF;
236:
237: IF (l_find_lane) THEN
238: FTE_LANE_PKG.DELETE_ROW(p_id => g_lane_tbl(g_lane_tbl.COUNT).lane_id,
239: p_table => 'FTE_LANE_COMMODITIES',
240: p_code => to_char(g_lane_commodity_tbl(g_lane_commodity_tbl.COUNT).commodity_catg_id),
241: p_line_number => p_line_number+i+1,
242: x_status => x_status,

Line 248: FTE_LANE_PKG.UPDATE_LANE_FLAGS(p_type => l_type,

244: IF (x_status <> -1) THEN
245: RETURN;
246: END IF;
247:
248: FTE_LANE_PKG.UPDATE_LANE_FLAGS(p_type => l_type,
249: p_lane_id => g_lane_tbl(g_lane_tbl.COUNT).lane_id,
250: x_status => x_status,
251: x_error_msg => x_error_msg);
252:

Line 351: FTE_LANE_PKG.DELETE_ROW(p_id => g_prc_parameter_tbl(g_prc_parameter_tbl.COUNT).lane_id,

347: END IF;
348:
349: IF (l_action = 'DELETE') THEN
350: IF (g_deficit_wt) THEN
351: FTE_LANE_PKG.DELETE_ROW(p_id => g_prc_parameter_tbl(g_prc_parameter_tbl.COUNT).lane_id,
352: p_table => 'FTE_PRC_PARAMETERS',
353: p_code => TO_CHAR(g_prc_parameter_tbl(g_prc_parameter_tbl.COUNT).parameter_id),
354: p_line_number => p_line_number+i+1,
355: x_status => x_status,

Line 359: FTE_LANE_PKG.DELETE_ROW(p_id => g_prc_parameter_tbl(g_prc_parameter_tbl.COUNT).parameter_instance_id,

355: x_status => x_status,
356: x_error_msg => x_error_msg);
357:
358: ELSIF (g_prc_parameter_tbl(g_prc_parameter_tbl.COUNT).parameter_instance_id <> -1) THEN
359: FTE_LANE_PKG.DELETE_ROW(p_id => g_prc_parameter_tbl(g_prc_parameter_tbl.COUNT).parameter_instance_id,
360: p_table => 'FTE_PRC_PARAMETERS',
361: p_code => NULL,
362: p_line_number => p_line_number+i+1,
363: x_status => x_status,

Line 376: FTE_LANE_PKG.DELETE_ROW(p_id => g_prc_parameter_tbl(g_prc_parameter_tbl.COUNT).lane_id,

372: END IF;
373:
374: IF (l_action = 'ADD') THEN
375: IF (g_deficit_wt AND g_first) THEN
376: FTE_LANE_PKG.DELETE_ROW(p_id => g_prc_parameter_tbl(g_prc_parameter_tbl.COUNT).lane_id,
377: p_table => 'FTE_PRC_PARAMETERS',
378: p_code => TO_CHAR(g_prc_parameter_tbl(g_prc_parameter_tbl.COUNT).parameter_id),
379: p_line_number => p_line_number+i+1,
380: x_status => x_status,

Line 390: FTE_LANE_PKG.INSERT_PRC_PARAMETERS(p_prc_parameter_tbl => g_prc_parameter_tbl,

386: END IF;
387:
388: END IF;
389:
390: FTE_LANE_PKG.INSERT_PRC_PARAMETERS(p_prc_parameter_tbl => g_prc_parameter_tbl,
391: x_status => x_status,
392: x_error_msg => x_error_msg);
393:
394: ELSIF (l_action = 'UPDATE') THEN

Line 395: FTE_LANE_PKG.UPDATE_PRC_PARAMETER(p_prc_parameter_tbl => g_prc_parameter_tbl,

391: x_status => x_status,
392: x_error_msg => x_error_msg);
393:
394: ELSIF (l_action = 'UPDATE') THEN
395: FTE_LANE_PKG.UPDATE_PRC_PARAMETER(p_prc_parameter_tbl => g_prc_parameter_tbl,
396: x_status => x_status,
397: x_error_msg => x_error_msg);
398: END IF;
399:

Line 497: FTE_LANE_PKG.INSERT_SCHEDULES(p_schedule_tbl => g_schedule_tbl,

493: p_category => NULL);
494: l_header_printed := true;
495: END IF;
496:
497: FTE_LANE_PKG.INSERT_SCHEDULES(p_schedule_tbl => g_schedule_tbl,
498: x_status => x_status,
499: x_error_msg => x_error_msg);
500:
501: IF (x_status <> -1) THEN

Line 506: FTE_LANE_PKG.UPDATE_LANE_FLAGS(p_type => 'SCHEDULE',

502: FTE_UTIL_PKG.Exit_Debug(l_module_name);
503: RETURN;
504: END IF;
505:
506: FTE_LANE_PKG.UPDATE_LANE_FLAGS(p_type => 'SCHEDULE',
507: p_lane_id => g_schedule_tbl(g_schedule_tbl.COUNT).lane_id,
508: p_value => 'Y',
509: x_status => x_status,
510: x_error_msg => x_error_msg);

Line 522: FTE_LANE_PKG.DELETE_ROW(p_id => g_schedule_tbl(g_schedule_tbl.COUNT).schedules_id,

518: -- need to figure out about update later
519:
520: ELSIF (l_action = 'DELETE') THEN
521: -- Delete a schedule and modify a lane
522: FTE_LANE_PKG.DELETE_ROW(p_id => g_schedule_tbl(g_schedule_tbl.COUNT).schedules_id,
523: p_table => 'FTE_SCHEDULES',
524: p_code => g_schedule_tbl(g_schedule_tbl.COUNT).voyage_number,
525: p_line_number => p_line_number+i+1,
526: x_status => x_status,

Line 543: FTE_LANE_PKG.UPDATE_LANE_FLAGS(p_type => 'SCHEDULE',

539: WHERE LANE_ID = l_lane_id
540: AND NVL(EDITABLE_FLAG,'Y') = 'Y';
541:
542: IF (l_rows = 0) THEN
543: FTE_LANE_PKG.UPDATE_LANE_FLAGS(p_type => 'SCHEDULE',
544: p_lane_id => g_schedule_tbl(g_schedule_tbl.COUNT).lane_id,
545: p_value => 'N',
546: x_status => x_status,
547: x_error_msg => x_error_msg);

Line 583: FTE_LANE_PKG.INSERT_LANE_TABLES(p_lane_tbl => g_lane_tbl,

579: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
580: x_status := -1;
581:
582: -- have to check if the lanes that has no commodity have to have basis
583: FTE_LANE_PKG.INSERT_LANE_TABLES(p_lane_tbl => g_lane_tbl,
584: p_lane_rate_chart_tbl => g_lane_rate_chart_tbl,
585: p_lane_commodity_tbl => g_lane_commodity_tbl,
586: p_lane_service_tbl => g_lane_service_tbl,
587: x_status => x_status,