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.BSC_UPDATE dependencies on BSC_DB_LOADER_CONTROL

Line 406: FROM bsc_db_loader_control

402: h_indicator VARCHAR2(30);
403:
404: CURSOR c_indicators (p_process_id NUMBER) IS
405: SELECT input_table_name
406: FROM bsc_db_loader_control
407: WHERE process_id = p_process_id;
408:
409: h_error_message VARCHAR2(2000);
410:

Line 753: ' FROM bsc_db_loader_control'||

749: h_num_indicators := 0;
750:
751: /*
752: h_sql := 'SELECT input_table_name'||
753: ' FROM bsc_db_loader_control'||
754: ' WHERE process_id = :1';
755: OPEN h_cursor FOR h_sql USING g_process_id;
756: */
757: OPEN c_indicators(g_process_id);

Line 1692: bsc_db_loader_control

1688: ) RETURN BOOLEAN IS
1689: BEGIN
1690:
1691: UPDATE
1692: bsc_db_loader_control
1693: SET
1694: last_stage_flag = 0
1695: WHERE
1696: input_table_name = x_input_table;

Line 1699: bsc_db_loader_control

1695: WHERE
1696: input_table_name = x_input_table;
1697:
1698: UPDATE
1699: bsc_db_loader_control
1700: SET
1701: last_stage_flag = 1
1702: WHERE
1703: input_table_name = x_input_table AND

Line 1781: ' FROM bsc_db_tables_cols c, bsc_db_loader_control p'||

1777: c_edw_dimensions_sql VARCHAR2(2000) := 'SELECT level_table_name'||
1778: ' FROM bsc_sys_dim_levels_b'||
1779: ' WHERE NVL(edw_flag, 0) = :1 AND'||
1780: ' level_pk_col IN (SELECT column_name'||
1781: ' FROM bsc_db_tables_cols c, bsc_db_loader_control p'||
1782: ' WHERE c.table_name = p.input_table_name AND'||
1783: ' c.column_type = :2 AND p.process_id = :3 AND p.status = :4)';
1784: */
1785: CURSOR c_edw_dimensions (p_edw_flag NUMBER, p_column_type VARCHAR2, p_process_id NUMBER, p_status VARCHAR2) IS

Line 1791: FROM bsc_db_tables_cols c, bsc_db_loader_control p

1787: FROM bsc_sys_dim_levels_b
1788: WHERE NVL(edw_flag, 0) = p_edw_flag AND
1789: level_pk_col IN (
1790: SELECT column_name
1791: FROM bsc_db_tables_cols c, bsc_db_loader_control p
1792: WHERE c.table_name = p.input_table_name AND
1793: c.column_type = p_column_type AND p.process_id = p_process_id AND p.status = p_status);
1794:
1795: h_column_type_p VARCHAR2(1);

Line 1915: ' FROM bsc_db_loader_control'||

1911:
1912: /*
1913: c_last_stage t_cursor; -- x_input_table, 1
1914: c_last_stage_sql VARCHAR2(2000) := 'SELECT stage'||
1915: ' FROM bsc_db_loader_control'||
1916: ' WHERE input_table_name = :1 AND last_stage_flag = :2';
1917: */
1918:
1919: BEGIN

Line 1931: FROM bsc_db_loader_control

1927: */
1928: BEGIN
1929: SELECT stage
1930: INTO x_last_stage
1931: FROM bsc_db_loader_control
1932: WHERE input_table_name = x_input_table AND last_stage_flag = 1;
1933: EXCEPTION
1934: WHEN NO_DATA_FOUND THEN
1935: x_last_stage := '?';

Line 2040: --BSC_DB_LOADER_CONTROL

2036: IF x_process_name = PC_LOADER_PROCESS THEN
2037: -- Associate same input tables to new process
2038: --BUG 1473202 Input tables from a previous process may have been dropped due to
2039: --some system change, so we cannot take those input tables
2040: --BSC_DB_LOADER_CONTROL
2041: INSERT INTO BSC_DB_LOADER_CONTROL (
2042: PROCESS_ID,
2043: INPUT_TABLE_NAME,
2044: STATUS,

Line 2041: INSERT INTO BSC_DB_LOADER_CONTROL (

2037: -- Associate same input tables to new process
2038: --BUG 1473202 Input tables from a previous process may have been dropped due to
2039: --some system change, so we cannot take those input tables
2040: --BSC_DB_LOADER_CONTROL
2041: INSERT INTO BSC_DB_LOADER_CONTROL (
2042: PROCESS_ID,
2043: INPUT_TABLE_NAME,
2044: STATUS,
2045: ERROR_CODE,

Line 2057: BSC_DB_LOADER_CONTROL

2053: NULL,
2054: LC_PENDING_STAGE,
2055: 0
2056: FROM
2057: BSC_DB_LOADER_CONTROL
2058: WHERE
2059: PROCESS_ID = x_process_id AND
2060: INPUT_TABLE_NAME IN (SELECT TABLE_NAME FROM BSC_DB_TABLES WHERE TABLE_TYPE = 0);
2061: END IF;

Line 2065: --BSC_DB_LOADER_CONTROL

2061: END IF;
2062:
2063: IF x_process_name = PC_LOAD_DIMENSIONS THEN
2064: -- Associate same input tables to new process
2065: --BSC_DB_LOADER_CONTROL
2066: INSERT INTO BSC_DB_LOADER_CONTROL (
2067: PROCESS_ID,
2068: INPUT_TABLE_NAME,
2069: STATUS,

Line 2066: INSERT INTO BSC_DB_LOADER_CONTROL (

2062:
2063: IF x_process_name = PC_LOAD_DIMENSIONS THEN
2064: -- Associate same input tables to new process
2065: --BSC_DB_LOADER_CONTROL
2066: INSERT INTO BSC_DB_LOADER_CONTROL (
2067: PROCESS_ID,
2068: INPUT_TABLE_NAME,
2069: STATUS,
2070: ERROR_CODE,

Line 2082: BSC_DB_LOADER_CONTROL

2078: NULL,
2079: LC_PENDING_STAGE,
2080: 0
2081: FROM
2082: BSC_DB_LOADER_CONTROL
2083: WHERE
2084: PROCESS_ID = x_process_id AND
2085: INPUT_TABLE_NAME IN (SELECT TABLE_NAME FROM BSC_DB_TABLES WHERE TABLE_TYPE = 2);
2086: END IF;

Line 2115: ' FROM bsc_db_loader_control'||

2111:
2112: /*
2113: c_input_tables t_cursor; -- g_process_id, x_status
2114: c_input_tables_sql VARCHAR2(2000) := 'SELECT input_table_name'||
2115: ' FROM bsc_db_loader_control'||
2116: ' WHERE process_id = :1 AND status = :2';
2117: */
2118: CURSOR c_input_tables (p_process_id NUMBER, p_status VARCHAR2) IS
2119: SELECT input_table_name

Line 2120: FROM bsc_db_loader_control

2116: ' WHERE process_id = :1 AND status = :2';
2117: */
2118: CURSOR c_input_tables (p_process_id NUMBER, p_status VARCHAR2) IS
2119: SELECT input_table_name
2120: FROM bsc_db_loader_control
2121: WHERE process_id = p_process_id AND status = p_status;
2122:
2123: h_input_table_name VARCHAR2(30);
2124:

Line 2514: FROM bsc_db_loader_control

2510: h_num_input_tables_err_status NUMBER;
2511:
2512: CURSOR c_input_tables_err_status IS
2513: SELECT input_table_name
2514: FROM bsc_db_loader_control
2515: WHERE process_id = g_process_id AND status = LC_ERROR_STATUS;
2516:
2517: BEGIN
2518: h_num_dim_tables := 0;

Line 4075: FROM bsc_db_loader_control

4071: END IF;
4072:
4073: SELECT count(*)
4074: INTO h_count
4075: FROM bsc_db_loader_control
4076: WHERE process_id = g_process_id AND status IN (LC_ERROR_STATUS, LC_NO_DATA_STATUS);
4077:
4078: IF h_count > 0 THEN
4079: RAISE e_warning;

Line 4313: ' FROM bsc_db_loader_control'||

4309: END IF;
4310:
4311: /*
4312: h_sql := 'SELECT count(*)'||
4313: ' FROM bsc_db_loader_control'||
4314: ' WHERE process_id = :1 AND status IN (:2, :3)';
4315: OPEN h_cursor FOR h_sql USING g_process_id, LC_ERROR_STATUS, LC_NO_DATA_STATUS;
4316: FETCH h_cursor INTO h_count;
4317: CLOSE h_cursor;

Line 4321: FROM bsc_db_loader_control

4317: CLOSE h_cursor;
4318: */
4319: SELECT count(*)
4320: INTO h_count
4321: FROM bsc_db_loader_control
4322: WHERE process_id = g_process_id AND status IN (LC_ERROR_STATUS, LC_NO_DATA_STATUS);
4323:
4324: IF h_count > 0 THEN
4325: RAISE e_warning;

Line 4485: ' FROM bsc_db_loader_control'||

4481: END IF;
4482:
4483: /*
4484: h_sql := 'SELECT count(*)'||
4485: ' FROM bsc_db_loader_control'||
4486: ' WHERE process_id = :1 AND status IN (:2, :3)';
4487: OPEN h_cursor FOR h_sql USING g_process_id, LC_ERROR_STATUS, LC_NO_DATA_STATUS;
4488: FETCH h_cursor INTO h_count;
4489: CLOSE h_cursor;

Line 4493: FROM bsc_db_loader_control

4489: CLOSE h_cursor;
4490: */
4491: SELECT count(*)
4492: INTO h_count
4493: FROM bsc_db_loader_control
4494: WHERE process_id = g_process_id AND status IN (LC_ERROR_STATUS, LC_NO_DATA_STATUS);
4495:
4496: IF h_count > 0 THEN
4497: RAISE e_warning;

Line 4889: -- Insert input tables in BSC_DB_LOADER_CONTROL

4885: last_update_login, status)
4886: VALUES (h_process_id, PC_LOADER_PROCESS,
4887: SYSDATE, g_user_id, SYSDATE, g_user_id, g_session_id, PC_PENDING_STATUS);
4888:
4889: -- Insert input tables in BSC_DB_LOADER_CONTROL
4890: FOR h_i IN 1..h_num_input_tables LOOP
4891: INSERT INTO bsc_db_loader_control (process_id, input_table_name, status,
4892: error_code, stage, last_stage_flag)
4893: VALUES (h_process_id, h_input_tables(h_i), LC_PENDING_STATUS, NULL, LC_PENDING_STAGE, 0);

Line 4891: INSERT INTO bsc_db_loader_control (process_id, input_table_name, status,

4887: SYSDATE, g_user_id, SYSDATE, g_user_id, g_session_id, PC_PENDING_STATUS);
4888:
4889: -- Insert input tables in BSC_DB_LOADER_CONTROL
4890: FOR h_i IN 1..h_num_input_tables LOOP
4891: INSERT INTO bsc_db_loader_control (process_id, input_table_name, status,
4892: error_code, stage, last_stage_flag)
4893: VALUES (h_process_id, h_input_tables(h_i), LC_PENDING_STATUS, NULL, LC_PENDING_STAGE, 0);
4894: END LOOP;
4895: COMMIT;

Line 4920: FROM bsc_db_loader_control

4916: END IF;
4917:
4918: SELECT count(*)
4919: INTO h_count
4920: FROM bsc_db_loader_control
4921: WHERE process_id = g_process_id AND status IN (LC_ERROR_STATUS, LC_NO_DATA_STATUS);
4922:
4923: IF h_count > 0 THEN
4924: RAISE e_warning;

Line 5204: -- Insert input tables in BSC_DB_LOADER_CONTROL

5200: last_update_login, status)
5201: VALUES (h_process_id, PC_LOAD_DIMENSIONS,
5202: SYSDATE, g_user_id, SYSDATE, g_user_id, g_session_id, PC_PENDING_STATUS);
5203:
5204: -- Insert input tables in BSC_DB_LOADER_CONTROL
5205: FOR h_i IN 1..h_num_input_tables LOOP
5206: INSERT INTO bsc_db_loader_control (process_id, input_table_name, status,
5207: error_code, stage, last_stage_flag)
5208: VALUES (h_process_id, h_input_tables(h_i), LC_PENDING_STATUS, NULL, LC_PENDING_STAGE, 0);

Line 5206: INSERT INTO bsc_db_loader_control (process_id, input_table_name, status,

5202: SYSDATE, g_user_id, SYSDATE, g_user_id, g_session_id, PC_PENDING_STATUS);
5203:
5204: -- Insert input tables in BSC_DB_LOADER_CONTROL
5205: FOR h_i IN 1..h_num_input_tables LOOP
5206: INSERT INTO bsc_db_loader_control (process_id, input_table_name, status,
5207: error_code, stage, last_stage_flag)
5208: VALUES (h_process_id, h_input_tables(h_i), LC_PENDING_STATUS, NULL, LC_PENDING_STAGE, 0);
5209: END LOOP;
5210: COMMIT;

Line 5237: FROM bsc_db_loader_control

5233: END IF;
5234:
5235: SELECT count(*)
5236: INTO h_count
5237: FROM bsc_db_loader_control
5238: WHERE process_id = g_process_id AND status IN (LC_ERROR_STATUS, LC_NO_DATA_STATUS);
5239:
5240: IF h_count > 0 THEN
5241: RAISE e_warning;

Line 5431: -- Insert indicators in BSC_DB_LOADER_CONTROL

5427: last_update_login, status)
5428: VALUES (h_process_id, PC_DELETE_KPI_DATA_PROCESS,
5429: SYSDATE, g_user_id, SYSDATE, g_user_id, g_session_id, PC_PENDING_STATUS);
5430:
5431: -- Insert indicators in BSC_DB_LOADER_CONTROL
5432: FOR h_i IN 1..h_num_indicators LOOP
5433: INSERT INTO bsc_db_loader_control (process_id, input_table_name, status,
5434: error_code, stage, last_stage_flag)
5435: VALUES (h_process_id, h_indicators(h_i), NULL, NULL, NULL, 0);

Line 5433: INSERT INTO bsc_db_loader_control (process_id, input_table_name, status,

5429: SYSDATE, g_user_id, SYSDATE, g_user_id, g_session_id, PC_PENDING_STATUS);
5430:
5431: -- Insert indicators in BSC_DB_LOADER_CONTROL
5432: FOR h_i IN 1..h_num_indicators LOOP
5433: INSERT INTO bsc_db_loader_control (process_id, input_table_name, status,
5434: error_code, stage, last_stage_flag)
5435: VALUES (h_process_id, h_indicators(h_i), NULL, NULL, NULL, 0);
5436: END LOOP;
5437: COMMIT;

Line 5903: bsc_db_loader_control

5899: x_target_stage IN VARCHAR2
5900: ) RETURN BOOLEAN IS
5901: BEGIN
5902: UPDATE
5903: bsc_db_loader_control
5904: SET
5905: stage = x_target_stage
5906: WHERE
5907: input_table_name = x_input_table AND

Line 5932: bsc_db_loader_control

5928: ) RETURN BOOLEAN IS
5929: BEGIN
5930: IF x_last_stage_flag THEN
5931: UPDATE
5932: bsc_db_loader_control
5933: SET
5934: last_stage_flag = 0
5935: WHERE
5936: input_table_name IN (

Line 5940: bsc_db_loader_control

5936: input_table_name IN (
5937: SELECT
5938: input_table_name
5939: FROM
5940: bsc_db_loader_control
5941: WHERE
5942: process_id = g_process_id AND
5943: status = x_current_status
5944: );

Line 5947: bsc_db_loader_control

5943: status = x_current_status
5944: );
5945:
5946: UPDATE
5947: bsc_db_loader_control
5948: SET
5949: stage = x_target_stage,
5950: last_stage_flag = 1
5951: WHERE

Line 5957: bsc_db_loader_control

5953: status = x_current_status;
5954:
5955: ELSE
5956: UPDATE
5957: bsc_db_loader_control
5958: SET
5959: stage = x_target_stage
5960: WHERE
5961: process_id = g_process_id AND

Line 5987: bsc_db_loader_control

5983: x_error_code IN VARCHAR2
5984: ) RETURN BOOLEAN IS
5985: BEGIN
5986: UPDATE
5987: bsc_db_loader_control
5988: SET
5989: status = x_target_status,
5990: error_code = x_error_code
5991: WHERE

Line 6016: bsc_db_loader_control

6012: x_error_code IN VARCHAR2
6013: ) RETURN BOOLEAN IS
6014: BEGIN
6015: UPDATE
6016: bsc_db_loader_control
6017: SET
6018: status = x_target_status,
6019: error_code = x_error_code
6020: WHERE

Line 6096: ' FROM bsc_db_loader_control'||

6092:
6093: /*
6094: c_status t_cursor; -- g_process_id
6095: c_status_sql VARCHAR2(2000) := 'SELECT input_table_name, status, error_code'||
6096: ' FROM bsc_db_loader_control'||
6097: ' WHERE process_id = :1'||
6098: ' ORDER BY input_table_name';
6099: */
6100: CURSOR c_status (p_process_id NUMBER) IS

Line 6102: FROM bsc_db_loader_control

6098: ' ORDER BY input_table_name';
6099: */
6100: CURSOR c_status (p_process_id NUMBER) IS
6101: SELECT input_table_name, status, error_code
6102: FROM bsc_db_loader_control
6103: WHERE process_id = p_process_id
6104: ORDER BY input_table_name;
6105:
6106:

Line 6128: FROM bsc_db_loader_control

6124: SELECT input_table_name, column_name, invalid_code
6125: FROM bsc_db_validation
6126: WHERE input_table_name IN (
6127: SELECT input_table_name
6128: FROM bsc_db_loader_control
6129: WHERE process_id = p_process_id
6130: )
6131: ORDER BY input_table_name;
6132:

Line 6140: ' FROM bsc_db_tables t, bsc_db_loader_control lc, bsc_sys_periodicities_vl p'||

6136: /*
6137: c_tables t_cursor; -- g_process_id
6138: c_tables_sql VARCHAR2(2000) := 'SELECT lc.input_table_name, t.periodicity_id,'||
6139: ' p.name, t.current_period, t.current_subperiod'||
6140: ' FROM bsc_db_tables t, bsc_db_loader_control lc, bsc_sys_periodicities_vl p'||
6141: ' WHERE lc.input_table_name = t.table_name AND'||
6142: ' lc.process_id = :1 AND t.periodicity_id = p.periodicity_id';
6143: */
6144: CURSOR c_tables (p_process_id NUMBER) IS

Line 6147: FROM bsc_db_tables t, bsc_db_loader_control lc, bsc_sys_periodicities_vl p

6143: */
6144: CURSOR c_tables (p_process_id NUMBER) IS
6145: SELECT lc.input_table_name, t.periodicity_id,
6146: p.name, t.current_period, t.current_subperiod
6147: FROM bsc_db_tables t, bsc_db_loader_control lc, bsc_sys_periodicities_vl p
6148: WHERE lc.input_table_name = t.table_name AND
6149: lc.process_id = p_process_id AND t.periodicity_id = p.periodicity_id;
6150:
6151: h_periodicity_id NUMBER;