DBA Data[Home] [Help]

APPS.FTE_LTL_LOADER dependencies on FTE_RATE_CHART_LOADER

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

1158: l_rate_hdr_data('START_DATE') := to_char(l_start_dates(i),FTE_BULKLOAD_PKG.G_DATE_FORMAT);
1159:
1160: l_rate_hdr_block_tbl(1) := l_rate_hdr_data;
1161:
1162: FTE_RATE_CHART_LOADER.PROCESS_RATE_CHART(p_block_header => g_dummy_block_hdr_tbl,
1163: p_block_data => l_rate_hdr_block_tbl,
1164: p_line_number => 0,
1165: p_validate_column => FALSE,
1166: p_process_id => l_process_id,

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

1183: l_qualifier_data('GROUP') := l_max_groups(i)+m;
1184:
1185: l_qualifier_block_tbl(1) := l_qualifier_data;
1186:
1187: FTE_RATE_CHART_LOADER.PROCESS_QUALIFIER(p_block_header => g_dummy_block_hdr_tbl,
1188: p_block_data => l_qualifier_block_tbl,
1189: p_line_number => 0,
1190: x_status => x_status,
1191: x_error_msg => x_error_msg);

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

1197: END LOOP;
1198: END LOOP;
1199:
1200: -- Inserting Data into interface tables
1201: FTE_RATE_CHART_LOADER.SUBMIT_QP_PROCESS(p_qp_call => FALSE,
1202: x_status => x_status,
1203: x_error_msg => x_error_msg);
1204:
1205: IF (x_status <> -1) THEN

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

1768: l_rate_hdr_data('END_DATE') := '';
1769:
1770: l_rate_hdr_block_tbl(1) := l_rate_hdr_data;
1771:
1772: FTE_RATE_CHART_LOADER.PROCESS_RATE_CHART(p_block_header => g_dummy_block_hdr_tbl,
1773: p_block_data => l_rate_hdr_block_tbl,
1774: p_line_number => 0,
1775: p_validate_column => FALSE,
1776: p_process_id => x_process_id,

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

1783: -- v_validate_data(1) := 'DELETE';
1784: l_rate_hdr_data('ACTION') := 'DELETE';
1785: l_rate_hdr_block_tbl(1) := l_rate_hdr_data;
1786:
1787: FTE_RATE_CHART_LOADER.PROCESS_RATE_CHART(p_block_header => g_dummy_block_hdr_tbl,
1788: p_block_data => l_rate_hdr_block_tbl,
1789: p_line_number => 0,
1790: p_validate_column => FALSE,
1791: p_process_id => x_process_id,

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

1794: -- v_validate_data(1) := 'ADD';
1795: l_rate_hdr_data('ACTION') := 'ADD';
1796: l_rate_hdr_block_tbl(1) := l_rate_hdr_data;
1797:
1798: FTE_RATE_CHART_LOADER.PROCESS_RATE_CHART(p_block_header => g_dummy_block_hdr_tbl,
1799: p_block_data => l_rate_hdr_block_tbl,
1800: p_line_number => 0,
1801: p_validate_column => FALSE,
1802: p_process_id => x_process_id,

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

1835: l_rate_line_data('RATE_TYPE') := 'PER_UOM';
1836:
1837: l_rate_line_block_tbl(1) := l_rate_line_data;
1838:
1839: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE(p_block_header => g_dummy_block_hdr_tbl,
1840: p_block_data => l_rate_line_block_tbl,
1841: p_line_number => 0,
1842: p_validate_column => FALSE,
1843: x_status => x_status,

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

1872: l_rate_break_data('RATE') := v_break_charge;
1873:
1874: l_rate_break_block_tbl(1) := l_rate_break_data;
1875:
1876: FTE_RATE_CHART_LOADER.PROCESS_RATE_BREAK(p_block_header => g_dummy_block_hdr_tbl,
1877: p_block_data => l_rate_break_block_tbl,
1878: p_line_number => 0,
1879: p_validate_column => FALSE,
1880: x_status => x_status,

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

1909: l_attribute_data('ATTRIBUTE_VALUE') := 'FC.'||v_class_value;
1910:
1911: l_attribute_block_tbl(1) := l_attribute_data;
1912:
1913: FTE_RATE_CHART_LOADER.PROCESS_RATING_ATTRIBUTE( p_block_header => g_dummy_block_hdr_tbl,
1914: p_block_data => l_attribute_block_tbl,
1915: p_line_number => 0,
1916: p_validate_column => FALSE,
1917: x_status => x_status,

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

1938: l_qualifier_data('GROUP') := q;
1939:
1940: l_qualifier_block_tbl(1) := l_qualifier_data;
1941:
1942: FTE_RATE_CHART_LOADER.PROCESS_QUALIFIER(p_block_header => g_dummy_block_hdr_tbl,
1943: p_block_data => l_qualifier_block_tbl,
1944: p_line_number => 0,
1945: x_status => x_status,
1946: x_error_msg => x_error_msg);

Line 1958: FTE_RATE_CHART_LOADER.SUBMIT_QP_PROCESS(x_status => x_status,

1954: G_CHART_COUNT_TEMP := G_CHART_COUNT_TEMP + 1;
1955:
1956: IF (G_CHART_COUNT_TEMP = G_BULK_INSERT_LIMIT) THEN
1957:
1958: FTE_RATE_CHART_LOADER.SUBMIT_QP_PROCESS(x_status => x_status,
1959: x_error_msg => x_error_msg);
1960:
1961: IF (x_status <> -1) THEN
1962: x_error_msg := 'ERROR INSERTING DATA into QP_INTERFACE TABLES: ' || x_error_msg;

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

3119:
3120: --
3121: -- Call SUBMIT_QP_PROCESS to insert the last set of rate charts into qp_interface tables.
3122: --
3123: FTE_RATE_CHART_LOADER.SUBMIT_QP_PROCESS(p_qp_call => FALSE,
3124: x_status => x_status,
3125: x_error_msg => x_error_msg);
3126:
3127: IF (x_status <> -1) THEN