DBA Data[Home] [Help]

APPS.FTE_TL_LOADER dependencies on FTE_RATE_CHART_LOADER

Line 913: FTE_RATE_CHART_LOADER.PROCESS_QUALIFIER(p_block_header => g_dummy_block_hdr_tbl,

909: l_qualifier_data('GROUP') := 1;
910:
911: l_qualifier_data_tbl(1) := l_qualifier_data;
912:
913: FTE_RATE_CHART_LOADER.PROCESS_QUALIFIER(p_block_header => g_dummy_block_hdr_tbl,
914: p_block_data => l_qualifier_data_tbl,
915: p_line_number => 0,
916: x_status => x_status,
917: x_error_msg => x_error_msg);

Line 927: FTE_RATE_CHART_LOADER.SUBMIT_QP_PROCESS(p_qp_call => FALSE,

923: FTE_UTIL_PKG.Exit_Debug(l_module_name);
924: RETURN;
925: END IF;
926:
927: FTE_RATE_CHART_LOADER.SUBMIT_QP_PROCESS(p_qp_call => FALSE,
928: x_status => x_status,
929: x_error_msg => x_error_msg);
930: IF (x_status <> -1) THEN
931: FTE_UTIL_PKG.Write_LogFile(l_module_name, x_error_msg);

Line 1062: FTE_RATE_CHART_LOADER.PROCESS_RATING_ATTRIBUTE( p_block_header => g_dummy_block_hdr_tbl,

1058: l_attribute_data('COMPARISON_OPERATOR') := p_comp_operator;
1059:
1060: l_attribute_block_tbl(1) := l_attribute_data;
1061:
1062: FTE_RATE_CHART_LOADER.PROCESS_RATING_ATTRIBUTE( p_block_header => g_dummy_block_hdr_tbl,
1063: p_block_data => l_attribute_block_tbl,
1064: p_line_number => p_line_number,
1065: p_validate_column => FALSE,
1066: x_status => x_status,

Line 1234: FTE_RATE_CHART_LOADER.PROCESS_RATE_BREAK(p_block_header => g_dummy_block_hdr_tbl,

1230: l_rate_break_data('TYPE') := 'ACCESSORIAL_SURCHARGE';
1231:
1232: l_rate_break_block_tbl(1) := l_rate_break_data;
1233:
1234: FTE_RATE_CHART_LOADER.PROCESS_RATE_BREAK(p_block_header => g_dummy_block_hdr_tbl,
1235: p_block_data => l_rate_break_block_tbl,
1236: p_line_number => p_line_number,
1237: p_validate_column => FALSE,
1238: x_status => x_status,

Line 1380: FTE_RATE_CHART_LOADER.PROCESS_RATE_CHART(p_block_header => g_dummy_block_hdr_tbl,

1376: l_rate_hdr_data('ATTRIBUTE1') := l_chart_type;
1377:
1378: l_rate_hdr_block_tbl(1) := l_rate_hdr_data;
1379:
1380: FTE_RATE_CHART_LOADER.PROCESS_RATE_CHART(p_block_header => g_dummy_block_hdr_tbl,
1381: p_block_data => l_rate_hdr_block_tbl,
1382: p_line_number => p_line_number,
1383: p_validate_column => FALSE,
1384: p_process_id => l_process_id,

Line 1489: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE(p_block_header => g_dummy_block_hdr_tbl,

1485: l_rate_line_data('ATTRIBUTE_VALUE_TO') := g_max_number;
1486:
1487: l_rate_line_block_tbl(1) := l_rate_line_data;
1488:
1489: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE(p_block_header => g_dummy_block_hdr_tbl,
1490: p_block_data => l_rate_line_block_tbl,
1491: p_line_number => p_line_number,
1492: p_validate_column => FALSE,
1493: x_status => x_status,

Line 1778: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE(p_block_header => g_dummy_block_hdr_tbl,

1774: l_rate_line_data('UOM') := g_unit_uom;
1775:
1776: l_rate_line_block_tbl(1) := l_rate_line_data;
1777:
1778: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE(p_block_header => g_dummy_block_hdr_tbl,
1779: p_block_data => l_rate_line_block_tbl,
1780: p_line_number => p_line_number,
1781: p_validate_column => FALSE,
1782: x_status => x_status,

Line 1844: -- PURPOSE: Calls FTE_RATE_CHART_LOADER.SUBMIT_QP_PROCESS, to popupulate the interface

1840: --_________________________________________________________________________________--
1841: --
1842: -- PROCEDURE: SUBMIT_TL_CHART
1843: --
1844: -- PURPOSE: Calls FTE_RATE_CHART_LOADER.SUBMIT_QP_PROCESS, to popupulate the interface
1845: -- tables and call corresponginf QP API. The values for headers,lines, attribs,
1846: -- qualifiers have already been stored through the validation procedures.
1847: -- For instance, FTE.VALIDATION_PKG.VALIDATE_RATE_CHART stores the header info
1848: -- after all validations for header in temporary pl/sql tables.

Line 2063: FTE_RATE_CHART_LOADER.SUBMIT_QP_PROCESS(p_qp_call => FALSE,

2059: -- Now Insert All rate chart data into the QP_INTERFACE tables.
2060: -- Insert_qp_interface tables of rate chart package should not call QP_MOD_LOADER_PUB.LOAD_MOD_LIST(p
2061: -- depending on some parameters.
2062: --+
2063: FTE_RATE_CHART_LOADER.SUBMIT_QP_PROCESS(p_qp_call => FALSE,
2064: x_error_msg => x_error_msg,
2065: x_status => x_status);
2066:
2067: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

Line 2068: FTE_UTIL_PKG.Write_LogFile(l_module_name,'Return Status from FTE_RATE_CHART_LOADER.SUBMIT_QP_PROCESS', x_status);

2064: x_error_msg => x_error_msg,
2065: x_status => x_status);
2066:
2067: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2068: FTE_UTIL_PKG.Write_LogFile(l_module_name,'Return Status from FTE_RATE_CHART_LOADER.SUBMIT_QP_PROCESS', x_status);
2069: FTE_UTIL_PKG.Write_LogFile(l_module_name,'Return Message from FTE_RATE_CHART_LOADER.SUBMIT_QP_PROCESS', x_error_msg);
2070: END IF;
2071:
2072: IF (x_status <> -1) THEN

Line 2069: FTE_UTIL_PKG.Write_LogFile(l_module_name,'Return Message from FTE_RATE_CHART_LOADER.SUBMIT_QP_PROCESS', x_error_msg);

2065: x_status => x_status);
2066:
2067: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2068: FTE_UTIL_PKG.Write_LogFile(l_module_name,'Return Status from FTE_RATE_CHART_LOADER.SUBMIT_QP_PROCESS', x_status);
2069: FTE_UTIL_PKG.Write_LogFile(l_module_name,'Return Message from FTE_RATE_CHART_LOADER.SUBMIT_QP_PROCESS', x_error_msg);
2070: END IF;
2071:
2072: IF (x_status <> -1) THEN
2073: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Return status from SUBMIT_QP_PROCESS', x_status );

Line 2470: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE(p_block_header => g_dummy_block_hdr_tbl,

2466: l_rate_line_data('UOM') := g_unit_uom;
2467:
2468: l_rate_line_block_tbl(1) := l_rate_line_data;
2469:
2470: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE(p_block_header => g_dummy_block_hdr_tbl,
2471: p_block_data => l_rate_line_block_tbl,
2472: p_line_number => p_line_number,
2473: p_validate_column => FALSE,
2474: x_status => x_status,

Line 2602: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE(p_block_header => g_dummy_block_hdr_tbl,

2598: l_rate_line_data('UOM') := g_unit_uom;
2599:
2600: l_rate_line_block_tbl(1) := l_rate_line_data;
2601:
2602: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE(p_block_header => g_dummy_block_hdr_tbl,
2603: p_block_data => l_rate_line_block_tbl,
2604: p_line_number => p_line_number,
2605: p_validate_column => FALSE,
2606: x_status => x_status,

Line 2772: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE(p_block_header => g_dummy_block_hdr_tbl,

2768: l_rate_line_data('UOM') := g_unit_uom;
2769:
2770: l_rate_line_block_tbl(1) := l_rate_line_data;
2771:
2772: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE(p_block_header => g_dummy_block_hdr_tbl,
2773: p_block_data => l_rate_line_block_tbl,
2774: p_line_number => p_line_number,
2775: p_validate_column => FALSE,
2776: x_status => x_status,

Line 3311: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE(p_block_header => g_dummy_block_hdr_tbl,

3307: l_rate_line_data('RATE_BREAK_TYPE') := l_break_type;
3308:
3309: l_rate_line_block_tbl(1) := l_rate_line_data;
3310:
3311: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE(p_block_header => g_dummy_block_hdr_tbl,
3312: p_block_data => l_rate_line_block_tbl,
3313: p_line_number => p_line_number,
3314: p_validate_column => FALSE,
3315: x_status => x_status,

Line 3433: FTE_RATE_CHART_LOADER.PROCESS_RATE_BREAK(p_block_header => g_dummy_block_hdr_tbl,

3429: l_rate_break_data('SUBTYPE') := l_subtype2;
3430:
3431: l_rate_break_block_tbl(1) := l_rate_break_data;
3432:
3433: FTE_RATE_CHART_LOADER.PROCESS_RATE_BREAK(p_block_header => g_dummy_block_hdr_tbl,
3434: p_block_data => l_rate_break_block_tbl ,
3435: p_line_number => p_line_number,
3436: p_validate_column => FALSE,
3437: x_status => x_status,

Line 3469: FTE_RATE_CHART_LOADER.PROCESS_RATE_BREAK(p_block_header => g_dummy_block_hdr_tbl,

3465: l_rate_break_data('SUBTYPE') := l_subtype;
3466:
3467: l_rate_break_block_tbl(1) := l_rate_break_data;
3468:
3469: FTE_RATE_CHART_LOADER.PROCESS_RATE_BREAK(p_block_header => g_dummy_block_hdr_tbl,
3470: p_block_data => l_rate_break_block_tbl,
3471: p_line_number => p_line_number,
3472: p_validate_column => FALSE,
3473: x_status => x_status,

Line 3576: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE(p_block_header => g_dummy_block_hdr_tbl,

3572: l_rate_line_data('RATE_BREAK_TYPE') := l_break_type;
3573:
3574: l_rate_line_block_tbl(1) := l_rate_line_data;
3575:
3576: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE(p_block_header => g_dummy_block_hdr_tbl,
3577: p_block_data => l_rate_line_block_tbl,
3578: p_line_number => p_line_number,
3579: p_validate_column => FALSE,
3580: x_status => x_status,

Line 3644: FTE_RATE_CHART_LOADER.PROCESS_RATE_BREAK(p_block_header => g_dummy_block_hdr_tbl,

3640: l_rate_break_data('CONTEXT') := l_context;
3641:
3642: l_rate_break_block_tbl(1) := l_rate_break_data;
3643:
3644: FTE_RATE_CHART_LOADER.PROCESS_RATE_BREAK(p_block_header => g_dummy_block_hdr_tbl,
3645: p_block_data => l_rate_break_block_tbl,
3646: p_line_number => p_line_number,
3647: p_validate_column => FALSE,
3648: x_status => x_status,

Line 4041: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE(p_block_header => g_dummy_block_hdr_tbl,

4037: l_rate_line_data('PERCENTAGE') := Fnd_Number.Number_To_Canonical(l_cont_mv_dsct_prcnt);
4038:
4039: l_rate_line_block_tbl(1) := l_rate_line_data;
4040:
4041: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE(p_block_header => g_dummy_block_hdr_tbl,
4042: p_block_data => l_rate_line_block_tbl,
4043: p_line_number => p_line_number,
4044: p_validate_column => FALSE,
4045: x_status => x_status,

Line 4507: FTE_RATE_CHART_LOADER.PROCESS_RATE_CHART(p_block_header => g_dummy_block_hdr_tbl,

4503: l_rate_hdr_data('ATTRIBUTE1') := 'FAC_RATE_CHART';
4504:
4505: l_rate_hdr_block_tbl(1) := l_rate_hdr_data;
4506:
4507: FTE_RATE_CHART_LOADER.PROCESS_RATE_CHART(p_block_header => g_dummy_block_hdr_tbl,
4508: p_block_data => l_rate_hdr_block_tbl,
4509: p_line_number => p_line_number + i + 1,
4510: p_validate_column => FALSE,
4511: p_process_id => l_process_id,

Line 4534: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE(p_block_header => g_dummy_block_hdr_tbl,

4530: l_rate_line_data('RATE_TYPE') := 'PER_UOM';
4531:
4532: l_rate_line_block_tbl(1) := l_rate_line_data;
4533:
4534: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE(p_block_header => g_dummy_block_hdr_tbl,
4535: p_block_data => l_rate_line_block_tbl,
4536: p_line_number => p_line_number + i + 1,
4537: p_validate_column => FALSE,
4538: x_status => x_status,

Line 4583: FTE_RATE_CHART_LOADER.PROCESS_RATE_CHART(p_block_header => g_dummy_block_hdr_tbl,

4579: l_rate_hdr_data('ATTRIBUTE1') := l_chart_type;
4580:
4581: l_rate_hdr_block_tbl(1) := l_rate_hdr_data;
4582:
4583: FTE_RATE_CHART_LOADER.PROCESS_RATE_CHART(p_block_header => g_dummy_block_hdr_tbl,
4584: p_block_data => l_rate_hdr_block_tbl,
4585: p_line_number => p_line_number + i + 1,
4586: p_validate_column => FALSE,
4587: p_process_id => l_process_id,

Line 5002: FTE_RATE_CHART_LOADER.PROCESS_RATE_CHART(p_block_header => g_dummy_block_hdr_tbl,

4998: l_rate_hdr_data('ATTRIBUTE1') := 'TL_MODIFIER';
4999:
5000: l_rate_hdr_block_tbl(1) := l_rate_hdr_data;
5001:
5002: FTE_RATE_CHART_LOADER.PROCESS_RATE_CHART(p_block_header => g_dummy_block_hdr_tbl,
5003: p_block_data => l_rate_hdr_block_tbl,
5004: p_line_number => p_line_number + i + 1,
5005: p_validate_column => FALSE,
5006: p_process_id => l_process_id,

Line 5949: FTE_RATE_CHART_LOADER.PROCESS_RATE_CHART(p_block_header => g_dummy_block_hdr_tbl,

5945: l_rate_hdr_data('ATTRIBUTE1') := 'TL_RATE_CHART';
5946:
5947: l_rate_hdr_block_tbl(1) := l_rate_hdr_data;
5948:
5949: FTE_RATE_CHART_LOADER.PROCESS_RATE_CHART(p_block_header => g_dummy_block_hdr_tbl,
5950: p_block_data => l_rate_hdr_block_tbl,
5951: p_line_number => p_line_number + i + 1,
5952: p_validate_column => FALSE,
5953: p_process_id => l_process_id,

Line 5993: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE(p_block_header => g_dummy_block_hdr_tbl,

5989: l_rate_line_data('END_DATE_ACTIVE') := l_end_date;
5990:
5991: l_rate_line_block_tbl(1) := l_rate_line_data;
5992:
5993: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE(p_block_header => g_dummy_block_hdr_tbl,
5994: p_block_data => l_rate_line_block_tbl,
5995: p_line_number => p_line_number + i + 1,
5996: p_validate_column => FALSE,
5997: x_status => x_status,

Line 6053: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE(p_block_header => g_dummy_block_hdr_tbl,

6049: l_rate_line_data('END_DATE_ACTIVE') := l_end_date;
6050:
6051: l_rate_line_block_tbl(1) := l_rate_line_data;
6052:
6053: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE(p_block_header => g_dummy_block_hdr_tbl,
6054: p_block_data => l_rate_line_block_tbl,
6055: p_line_number => p_line_number + i + 1,
6056: p_validate_column => FALSE,
6057: x_status => x_status,

Line 6109: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE(p_block_header => g_dummy_block_hdr_tbl,

6105: l_rate_line_data('END_DATE_ACTIVE') := l_end_date;
6106:
6107: l_rate_line_block_tbl(1) := l_rate_line_data;
6108:
6109: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE(p_block_header => g_dummy_block_hdr_tbl,
6110: p_block_data => l_rate_line_block_tbl,
6111: p_line_number => p_line_number + i + 1,
6112: p_validate_column => FALSE,
6113: x_status => x_status,

Line 6248: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE(p_block_header => g_dummy_block_hdr_tbl,

6244: l_rate_line_data('END_DATE_ACTIVE') := l_end_date;
6245:
6246: l_rate_line_block_tbl(1) := l_rate_line_data;
6247:
6248: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE(p_block_header => g_dummy_block_hdr_tbl,
6249: p_block_data => l_rate_line_block_tbl,
6250: p_line_number => p_line_number + i + 1,
6251: p_validate_column => FALSE,
6252: x_status => x_status,