APPS.FTE_RATE_CHART_LOADER dependencies on FTE_RATE_CHART_PKG

Line 12: g_qp_list_header_tbl FTE_RATE_CHART_PKG.qp_list_header_tbl;

8: -- --
9: -------------------------------------------------------------------------- --
10:
11: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_RATE_CHART_LOADER';
12: g_qp_list_header_tbl FTE_RATE_CHART_PKG.qp_list_header_tbl;
13: g_qp_list_line_tbl FTE_RATE_CHART_PKG.qp_list_line_tbl;
14: g_qp_qualifier_tbl FTE_RATE_CHART_PKG.qp_qualifier_tbl;
15: g_qp_pricing_attrib_tbl FTE_RATE_CHART_PKG.qp_pricing_attrib_tbl;
16: g_carrier_id NUMBER;

Line 13: g_qp_list_line_tbl FTE_RATE_CHART_PKG.qp_list_line_tbl;

9: -------------------------------------------------------------------------- --
10:
11: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_RATE_CHART_LOADER';
12: g_qp_list_header_tbl FTE_RATE_CHART_PKG.qp_list_header_tbl;
13: g_qp_list_line_tbl FTE_RATE_CHART_PKG.qp_list_line_tbl;
14: g_qp_qualifier_tbl FTE_RATE_CHART_PKG.qp_qualifier_tbl;
15: g_qp_pricing_attrib_tbl FTE_RATE_CHART_PKG.qp_pricing_attrib_tbl;
16: g_carrier_id NUMBER;
17: g_list_header_deleted BOOLEAN := false;

Line 14: g_qp_qualifier_tbl FTE_RATE_CHART_PKG.qp_qualifier_tbl;

10:
11: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_RATE_CHART_LOADER';
12: g_qp_list_header_tbl FTE_RATE_CHART_PKG.qp_list_header_tbl;
13: g_qp_list_line_tbl FTE_RATE_CHART_PKG.qp_list_line_tbl;
14: g_qp_qualifier_tbl FTE_RATE_CHART_PKG.qp_qualifier_tbl;
15: g_qp_pricing_attrib_tbl FTE_RATE_CHART_PKG.qp_pricing_attrib_tbl;
16: g_carrier_id NUMBER;
17: g_list_header_deleted BOOLEAN := false;
18:

Line 15: g_qp_pricing_attrib_tbl FTE_RATE_CHART_PKG.qp_pricing_attrib_tbl;

11: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_RATE_CHART_LOADER';
12: g_qp_list_header_tbl FTE_RATE_CHART_PKG.qp_list_header_tbl;
13: g_qp_list_line_tbl FTE_RATE_CHART_PKG.qp_list_line_tbl;
14: g_qp_qualifier_tbl FTE_RATE_CHART_PKG.qp_qualifier_tbl;
15: g_qp_pricing_attrib_tbl FTE_RATE_CHART_PKG.qp_pricing_attrib_tbl;
16: g_carrier_id NUMBER;
17: g_list_header_deleted BOOLEAN := false;
18:
19: ----------------------------------------------------------------------------

Line 168: FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).list_header_id,

164:
165: g_carrier_id := l_carrier_id;
166:
167: IF (l_action = 'DELETE') THEN
168: FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).list_header_id,
169: p_name => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).name,
170: p_action => l_action,
171: p_line_number => p_line_number+i+1,
172: x_error_msg => x_error_msg,

Line 178: FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).list_header_id,

174:
175: g_list_header_deleted := true;
176: ELSIF (l_action = 'UPDATE') THEN
177:
178: FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).list_header_id,
179: p_name => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).name,
180: p_action => l_action,
181: p_line_number => p_line_number+i+1,
182: x_error_msg => x_error_msg,

Line 518: FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).list_header_id,

514: END IF;
515: g_carrier_id := l_carrier_id;
516:
517: IF (l_action = 'DELETE') THEN
518: FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).list_header_id,
519: p_name => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).name,
520: p_action => l_action,
521: p_line_number => p_line_number+i+1,
522: x_error_msg => x_error_msg,

Line 528: FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).list_header_id,

524:
525: g_list_header_deleted := true;
526: ELSIF (l_action = 'UPDATE') THEN
527:
528: FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).list_header_id,
529: p_name => g_qp_list_header_tbl(g_qp_list_header_tbl.COUNT).name,
530: p_action => l_action,
531: p_line_number => p_line_number+i+1,
532: x_error_msg => x_error_msg,

Line 830: FTE_RATE_CHART_PKG.INSERT_QP_INTERFACE_TABLES(p_qp_list_header_tbl => g_qp_list_header_tbl,

826: RETURN;
827: END IF;
828:
829: -- have to check if the lanes that has no commodity have to have basis
830: FTE_RATE_CHART_PKG.INSERT_QP_INTERFACE_TABLES(p_qp_list_header_tbl => g_qp_list_header_tbl,
831: p_qp_list_line_tbl => g_qp_list_line_tbl,
832: p_qp_qualifier_tbl => g_qp_qualifier_tbl,
833: p_qp_pricing_attrib_tbl => g_qp_pricing_attrib_tbl,
834: p_qp_call => p_qp_call,