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_TL_LOADER dependencies on FTE_RATE_CHART_PKG

Line 1886: l_currency_tbl FTE_RATE_CHART_PKG.LH_CURRENCY_CODE_TAB;

1882: l_parameter_id NUMBER;
1883: l_rate_basis VARCHAR2(30);
1884: l_rate_basis_uom VARCHAR2(30);
1885: l_modifier_id NUMBER;
1886: l_currency_tbl FTE_RATE_CHART_PKG.LH_CURRENCY_CODE_TAB;
1887: l_name FTE_RATE_CHART_PKG.LH_NAME_TAB;
1888:
1889: l_carrier_name_temp VARCHAR2(60);
1890: l_service_level_temp VARCHAR2(30);

Line 1887: l_name FTE_RATE_CHART_PKG.LH_NAME_TAB;

1883: l_rate_basis VARCHAR2(30);
1884: l_rate_basis_uom VARCHAR2(30);
1885: l_modifier_id NUMBER;
1886: l_currency_tbl FTE_RATE_CHART_PKG.LH_CURRENCY_CODE_TAB;
1887: l_name FTE_RATE_CHART_PKG.LH_NAME_TAB;
1888:
1889: l_carrier_name_temp VARCHAR2(60);
1890: l_service_level_temp VARCHAR2(30);
1891: l_linenum_temp NUMBER;

Line 2105: FTE_RATE_CHART_PKG.QP_API_CALL(p_chart_type => l_chart_type,

2101:
2102: IF (l_chart_type in('TL_RATE_CHART', 'FAC_RATE_CHART')) THEN
2103: l_name(1) := l_chart_name;
2104: l_currency_tbl(1) := l_currency;
2105: FTE_RATE_CHART_PKG.QP_API_CALL(p_chart_type => l_chart_type,
2106: p_process_id => l_process_id,
2107: p_name => l_name,
2108: p_currency => l_currency_tbl,
2109: x_status => x_status,

Line 2137: FTE_RATE_CHART_PKG.QP_API_CALL(p_chart_type => l_chart_type,

2133:
2134: ELSIF (l_chart_type IN ('TL_MODIFIER', 'FAC_MODIFIER', 'FTE_MODIFIER', 'MIN_MODIFIER')) THEN
2135: l_name(1) := l_chart_name;
2136: l_currency_tbl(1) := l_currency;
2137: FTE_RATE_CHART_PKG.QP_API_CALL(p_chart_type => l_chart_type,
2138: p_process_id => l_process_id,
2139: p_name => l_name,
2140: p_currency => l_currency_tbl,
2141: x_status => x_status,

Line 4419: l_assoc_rc_ids := FTE_RATE_CHART_PKG.GET_ASSOC_PRICELISTS(NULL, l_name);

4415:
4416: --+
4417: -- For DELETE, we delete the dummy rate chart associated with the modifier.
4418: --+
4419: l_assoc_rc_ids := FTE_RATE_CHART_PKG.GET_ASSOC_PRICELISTS(NULL, l_name);
4420:
4421: FOR i IN 1..l_assoc_rc_ids.COUNT LOOP
4422:
4423: FTE_RATE_CHART_PKG.G_CHART_TYPE := 'FAC_RATE_CHART';

Line 4423: FTE_RATE_CHART_PKG.G_CHART_TYPE := 'FAC_RATE_CHART';

4419: l_assoc_rc_ids := FTE_RATE_CHART_PKG.GET_ASSOC_PRICELISTS(NULL, l_name);
4420:
4421: FOR i IN 1..l_assoc_rc_ids.COUNT LOOP
4422:
4423: FTE_RATE_CHART_PKG.G_CHART_TYPE := 'FAC_RATE_CHART';
4424: FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => l_assoc_rc_ids(i),
4425: p_name => NULL,
4426: p_action => 'DELETE',
4427: p_line_number => p_line_number + i + 1,

Line 4424: FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => l_assoc_rc_ids(i),

4420:
4421: FOR i IN 1..l_assoc_rc_ids.COUNT LOOP
4422:
4423: FTE_RATE_CHART_PKG.G_CHART_TYPE := 'FAC_RATE_CHART';
4424: FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => l_assoc_rc_ids(i),
4425: p_name => NULL,
4426: p_action => 'DELETE',
4427: p_line_number => p_line_number + i + 1,
4428: x_status => x_status,

Line 4439: FTE_RATE_CHART_PKG.G_CHART_TYPE := 'FAC_MODIFIER';

4435: --+
4436: -- For Delete, we delete the lines and attributes and exit
4437: --+
4438:
4439: FTE_RATE_CHART_PKG.G_CHART_TYPE := 'FAC_MODIFIER';
4440: FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => NULL,
4441: p_name => l_name,
4442: p_action => G_ACTION,
4443: p_line_number => p_line_number + i + 1,

Line 4440: FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => NULL,

4436: -- For Delete, we delete the lines and attributes and exit
4437: --+
4438:
4439: FTE_RATE_CHART_PKG.G_CHART_TYPE := 'FAC_MODIFIER';
4440: FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => NULL,
4441: p_name => l_name,
4442: p_action => G_ACTION,
4443: p_line_number => p_line_number + i + 1,
4444: x_status => x_status,

Line 4936: FTE_RATE_CHART_PKG.G_CHART_TYPE := l_chart_type;

4932: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
4933: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Deleting TL_MODIFIER ' || l_name);
4934: END IF;
4935:
4936: FTE_RATE_CHART_PKG.G_CHART_TYPE := l_chart_type;
4937:
4938: FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => NULL,
4939: p_name => l_name,
4940: p_action => G_ACTION,

Line 4938: FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => NULL,

4934: END IF;
4935:
4936: FTE_RATE_CHART_PKG.G_CHART_TYPE := l_chart_type;
4937:
4938: FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => NULL,
4939: p_name => l_name,
4940: p_action => G_ACTION,
4941: p_line_number => p_line_number + i + 1,
4942: x_status => x_status,

Line 5635: l_assoc_modifier_ids := FTE_RATE_CHART_PKG.GET_ASSOC_MODIFIERS(NULL, l_rate_chart_name);

5631: IF (G_ACTION IN('UPDATE', 'DELETE')) THEN
5632:
5633: -- For both UPDATE and DELETE, delete the associated Mincharge Modifier of the rate chart
5634:
5635: l_assoc_modifier_ids := FTE_RATE_CHART_PKG.GET_ASSOC_MODIFIERS(NULL, l_rate_chart_name);
5636:
5637: FOR i IN 1..l_assoc_modifier_ids.COUNT
5638: LOOP
5639: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

Line 5643: FTE_RATE_CHART_PKG.G_CHART_TYPE := 'TL_MODIFIER';

5639: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
5640: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Deleting Modifier ' || l_assoc_modifier_ids(i) || ' of Rate Chart ' || l_rate_chart_name);
5641: END IF;
5642:
5643: FTE_RATE_CHART_PKG.G_CHART_TYPE := 'TL_MODIFIER';
5644: FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => l_assoc_modifier_ids(i),
5645: p_name => NULL,
5646: p_action => 'DELETE',
5647: p_line_number => p_line_number + i + 1,

Line 5644: FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => l_assoc_modifier_ids(i),

5640: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Deleting Modifier ' || l_assoc_modifier_ids(i) || ' of Rate Chart ' || l_rate_chart_name);
5641: END IF;
5642:
5643: FTE_RATE_CHART_PKG.G_CHART_TYPE := 'TL_MODIFIER';
5644: FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => l_assoc_modifier_ids(i),
5645: p_name => NULL,
5646: p_action => 'DELETE',
5647: p_line_number => p_line_number + i + 1,
5648: x_status => x_status,

Line 5653: FTE_UTIL_PKG.Write_LogFile(l_module_name,'FTE_RATE_CHART_PKG.DELETE_FROM_QP returned with error' || x_error_msg);

5649: x_error_msg => x_error_msg);
5650:
5651:
5652: IF (x_status <> -1) THEN
5653: FTE_UTIL_PKG.Write_LogFile(l_module_name,'FTE_RATE_CHART_PKG.DELETE_FROM_QP returned with error' || x_error_msg);
5654: FTE_UTIL_PKG.Exit_Debug(l_module_name);
5655: RETURN;
5656: END IF;
5657: END LOOP;

Line 5674: FTE_RATE_CHART_PKG.G_CHART_TYPE := 'TL_RATE_CHART';

5670: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
5671: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Deleting TL_RATE_CHART ' || l_rate_chart_name);
5672: END IF;
5673:
5674: FTE_RATE_CHART_PKG.G_CHART_TYPE := 'TL_RATE_CHART';
5675:
5676: FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => NULL,
5677: p_name => l_rate_chart_name,
5678: p_action => G_ACTION,

Line 5676: FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => NULL,

5672: END IF;
5673:
5674: FTE_RATE_CHART_PKG.G_CHART_TYPE := 'TL_RATE_CHART';
5675:
5676: FTE_RATE_CHART_PKG.DELETE_FROM_QP(p_list_header_id => NULL,
5677: p_name => l_rate_chart_name,
5678: p_action => G_ACTION,
5679: p_line_number => p_line_number + i + 1,
5680: x_status => x_status,

Line 5683: FTE_UTIL_PKG.Write_LogFile(l_module_name,'FTE_RATE_CHART_PKG.DELETE_FROM_QP returned with error' || x_error_msg);

5679: p_line_number => p_line_number + i + 1,
5680: x_status => x_status,
5681: x_error_msg => x_error_msg);
5682: IF (x_status <> -1) THEN
5683: FTE_UTIL_PKG.Write_LogFile(l_module_name,'FTE_RATE_CHART_PKG.DELETE_FROM_QP returned with error' || x_error_msg);
5684: FTE_UTIL_PKG.Exit_Debug(l_module_name);
5685: RETURN;
5686: END IF;
5687: