APPS.FTE_LTL_LOADER dependencies on FTE_RATE_CHART_PKG

Line 1079: l_currency_tbl FTE_RATE_CHART_PKG.LH_CURRENCY_CODE_TAB;

1075:
1076: l_qualifier_data FTE_BULKLOAD_PKG.data_values_tbl;
1077: l_qualifier_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1078:
1079: l_currency_tbl FTE_RATE_CHART_PKG.LH_CURRENCY_CODE_TAB;
1080: l_name FTE_RATE_CHART_PKG.LH_NAME_TAB;
1081:
1082: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.ADD_CARRIERS_TO_RATECHARTS';
1083:

Line 1080: l_name FTE_RATE_CHART_PKG.LH_NAME_TAB;

1076: l_qualifier_data FTE_BULKLOAD_PKG.data_values_tbl;
1077: l_qualifier_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1078:
1079: l_currency_tbl FTE_RATE_CHART_PKG.LH_CURRENCY_CODE_TAB;
1080: l_name FTE_RATE_CHART_PKG.LH_NAME_TAB;
1081:
1082: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.ADD_CARRIERS_TO_RATECHARTS';
1083:
1084: CURSOR GET_RATE_CHART_DETAILS IS

Line 1219: FTE_RATE_CHART_PKG.QP_API_CALL(p_chart_type => 'LTL_RATE_CHART',

1215: LOOP
1216: l_name(1) := l_rate_names(i);
1217: l_currency_tbl(1) := l_currency_codes(i);
1218:
1219: FTE_RATE_CHART_PKG.QP_API_CALL(p_chart_type => 'LTL_RATE_CHART',
1220: p_process_id => l_process_ids(i),
1221: p_name => l_name,
1222: p_currency => l_currency_tbl,
1223: x_status => x_status,

Line 5485: l_currency_tbl FTE_RATE_CHART_PKG.LH_CURRENCY_CODE_TAB;

5481: x_status NUMBER := -1;
5482: x_error_msg VARCHAR2(8000);
5483: l_temp BOOLEAN;
5484: l_name VARCHAR2(200);
5485: l_currency_tbl FTE_RATE_CHART_PKG.LH_CURRENCY_CODE_TAB;
5486: l_name_tbl FTE_RATE_CHART_PKG.LH_NAME_TAB;
5487:
5488: CURSOR GET_PROCESS_ID IS
5489: SELECT

Line 5486: l_name_tbl FTE_RATE_CHART_PKG.LH_NAME_TAB;

5482: x_error_msg VARCHAR2(8000);
5483: l_temp BOOLEAN;
5484: l_name VARCHAR2(200);
5485: l_currency_tbl FTE_RATE_CHART_PKG.LH_CURRENCY_CODE_TAB;
5486: l_name_tbl FTE_RATE_CHART_PKG.LH_NAME_TAB;
5487:
5488: CURSOR GET_PROCESS_ID IS
5489: SELECT
5490: l.process_id, qh.name

Line 5538: FTE_RATE_CHART_PKG.QP_API_CALL(p_chart_type => 'LTL_RATE_CHART',

5534: RETURN;
5535:
5536: END IF;
5537:
5538: FTE_RATE_CHART_PKG.QP_API_CALL(p_chart_type => 'LTL_RATE_CHART',
5539: p_process_id => l_process_id,
5540: p_name => l_name_tbl,
5541: p_currency => l_currency_tbl,
5542: x_status => x_status,