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.ZPB_BUSAREA_VAL dependencies on ZPB_ANALYSIS_CYCLES

Line 181: p_acID IN zpb_analysis_cycles.analysis_cycle_id%TYPE := NULL,

177: PROCEDURE DISABLE_BP(p_baId IN NUMBER,
178: p_queryName IN VARCHAR,
179: p_queryPath IN VARCHAR,
180: p_queryErrorType IN VARCHAR,
181: p_acID IN zpb_analysis_cycles.analysis_cycle_id%TYPE := NULL,
182: p_init_fix IN VARCHAR2)
183: IS
184: l_num NUMBER;
185:

Line 211: UPDATE zpb_analysis_cycles

207: l_num := 0;
208: END;
209: -- Mark the BP as Invalid only if it is Published
210: IF(l_num <> 0) THEN
211: UPDATE zpb_analysis_cycles
212: SET STATUS_CODE = 'INVALID_BP'
213: WHERE analysis_cycle_id = p_acID
214: AND business_area_id = p_baID;
215: END IF;

Line 1843: l_acID ZPB_ANALYSIS_CYCLES.ANALYSIS_CYCLE_ID%type;

1839: l_queryPath ZPB_STATUS_SQL.QUERY_PATH%type;
1840: l_queryErrorType varchar2(1);
1841: l_dim ZPB_CYCLE_MODEL_DIMENSIONS.DIMENSION_NAME%type;
1842: l_dimName ZPB_CYCLE_MODEL_DIMENSIONS.DIMENSION_NAME%type;
1843: l_acID ZPB_ANALYSIS_CYCLES.ANALYSIS_CYCLE_ID%type;
1844: l_bpName ZPB_ANALYSIS_CYCLES.NAME%type;
1845: l_memberID ZPB_LINE_DIMENSIONALITY.MEMBER%type;
1846: l_memberName VARCHAR2(255);
1847: l_secFoldPath ZPB_STATUS_SQL.QUERY_PATH%type;

Line 1844: l_bpName ZPB_ANALYSIS_CYCLES.NAME%type;

1840: l_queryErrorType varchar2(1);
1841: l_dim ZPB_CYCLE_MODEL_DIMENSIONS.DIMENSION_NAME%type;
1842: l_dimName ZPB_CYCLE_MODEL_DIMENSIONS.DIMENSION_NAME%type;
1843: l_acID ZPB_ANALYSIS_CYCLES.ANALYSIS_CYCLE_ID%type;
1844: l_bpName ZPB_ANALYSIS_CYCLES.NAME%type;
1845: l_memberID ZPB_LINE_DIMENSIONALITY.MEMBER%type;
1846: l_memberName VARCHAR2(255);
1847: l_secFoldPath ZPB_STATUS_SQL.QUERY_PATH%type;
1848: l_statusSqlId ZPB_STATUS_SQL.STATUS_SQL_ID%type;

Line 1882: from ZPB_DC_OBJECTS A, ZPB_ANALYSIS_CYCLES B

1878:
1879: cursor l_dc_tg_objs(p_search_str VARCHAR2, p_baID NUMBER) is
1880: select TEMPLATE_NAME, OBJECT_TYPE, A.ANALYSIS_CYCLE_ID, TARGET_OBJ_PATH
1881: into l_str2, l_str, l_acID, l_queryPath
1882: from ZPB_DC_OBJECTS A, ZPB_ANALYSIS_CYCLES B
1883: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
1884: AND B.STATUS_CODE <> 'MARKED_FOR_DELETION'
1885: AND B.BUSINESS_AREA_ID = p_baID
1886: AND TARGET_OBJ_NAME = p_search_str;

Line 1891: from ZPB_DC_OBJECTS A, ZPB_ANALYSIS_CYCLES B

1887:
1888: cursor l_dc_data_objs(p_search_str VARCHAR2, p_baID NUMBER) is
1889: select TEMPLATE_NAME, OBJECT_TYPE, A.ANALYSIS_CYCLE_ID, TARGET_OBJ_PATH
1890: into l_str2, l_str, l_acID, l_queryPath
1891: from ZPB_DC_OBJECTS A, ZPB_ANALYSIS_CYCLES B
1892: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
1893: AND B.STATUS_CODE <> 'MARKED_FOR_DELETION'
1894: AND B.BUSINESS_AREA_ID = p_baID
1895: AND DATAENTRY_OBJ_NAME = p_search_str;

Line 1900: from ZPB_SOLVE_INPUT_SELECTIONS A, ZPB_ANALYSIS_CYCLES B

1896:
1897: cursor l_input_sel(p_search_str VARCHAR2, p_baID NUMBER) is
1898: select SELECTION_NAME, SELECTION_PATH, A.ANALYSIS_CYCLE_ID, B.NAME
1899: into l_str, l_queryPath, l_acID, l_bpName
1900: from ZPB_SOLVE_INPUT_SELECTIONS A, ZPB_ANALYSIS_CYCLES B
1901: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
1902: AND B.STATUS_CODE <> 'MARKED_FOR_DELETION'
1903: AND B.BUSINESS_AREA_ID = p_baID
1904: AND SELECTION_NAME = p_search_str;

Line 1909: from ZPB_SOLVE_OUTPUT_SELECTIONS A, ZPB_ANALYSIS_CYCLES B

1905:
1906: cursor l_output_sel(p_search_str VARCHAR2, p_baID NUMBER) is
1907: select SELECTION_NAME, SELECTION_PATH, A.ANALYSIS_CYCLE_ID, B.NAME
1908: into l_str, l_queryPath, l_acID, l_bpName
1909: from ZPB_SOLVE_OUTPUT_SELECTIONS A, ZPB_ANALYSIS_CYCLES B
1910: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
1911: AND B.STATUS_CODE <> 'MARKED_FOR_DELETION'
1912: AND B.BUSINESS_AREA_ID = p_baID
1913: AND SELECTION_NAME = p_search_str;

Line 1918: from ZPB_DATA_INITIALIZATION_DEFS A, ZPB_ANALYSIS_CYCLES B

1914:
1915: cursor l_init_source(p_search_str VARCHAR2, p_baID NUMBER) is
1916: select SOURCE_QUERY_NAME, QUERY_PATH, MEMBER, A.ANALYSIS_CYCLE_ID
1917: into l_str, l_queryPath, l_memberID, l_acID
1918: from ZPB_DATA_INITIALIZATION_DEFS A, ZPB_ANALYSIS_CYCLES B
1919: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
1920: AND B.STATUS_CODE <> 'MARKED_FOR_DELETION'
1921: AND B.BUSINESS_AREA_ID = p_baID
1922: AND SOURCE_QUERY_NAME = p_search_str;

Line 1927: from ZPB_DATA_INITIALIZATION_DEFS A, ZPB_ANALYSIS_CYCLES B

1923:
1924: cursor l_init_target(p_search_str VARCHAR2, p_baID NUMBER) is
1925: select TARGET_QUERY_NAME, QUERY_PATH, MEMBER, A.ANALYSIS_CYCLE_ID
1926: into l_str, l_queryPath, l_memberID, l_acID
1927: from ZPB_DATA_INITIALIZATION_DEFS A, ZPB_ANALYSIS_CYCLES B
1928: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
1929: AND B.STATUS_CODE <> 'MARKED_FOR_DELETION'
1930: AND B.BUSINESS_AREA_ID = p_baID
1931: AND TARGET_QUERY_NAME = p_search_str;

Line 1936: from zpb_cycle_model_dimensions A, ZPB_ANALYSIS_CYCLES B

1932:
1933: cursor l_sum_sel1(p_search_str VARCHAR2, p_baID NUMBER) is
1934: select SUM_SELECTION_NAME, SUM_SELECTION_PATH, DIMENSION_NAME, A.ANALYSIS_CYCLE_ID
1935: into l_str, l_queryPath, l_dim, l_acID
1936: from zpb_cycle_model_dimensions A, ZPB_ANALYSIS_CYCLES B
1937: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
1938: AND B.STATUS_CODE <> 'MARKED_FOR_DELETION'
1939: AND B.BUSINESS_AREA_ID = p_baID
1940: AND SUM_SELECTION_NAME = p_search_str;

Line 1945: from ZPB_LINE_DIMENSIONALITY A, ZPB_ANALYSIS_CYCLES B

1941:
1942: cursor l_sum_sel2(p_search_str VARCHAR2, p_baID NUMBER) is
1943: select SUM_SELECTION_NAME, SUM_SELECTION_PATH, MEMBER, DIMENSION, A.ANALYSIS_CYCLE_ID
1944: into l_str, l_queryPath, l_memberID, l_dim, l_acID
1945: from ZPB_LINE_DIMENSIONALITY A, ZPB_ANALYSIS_CYCLES B
1946: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
1947: AND B.STATUS_CODE <> 'MARKED_FOR_DELETION'
1948: AND B.BUSINESS_AREA_ID = p_baID
1949: AND SUM_SELECTION_NAME = p_search_str;

Line 1958: from ZPB_ANALYSIS_CYCLES A,

1954: WHERE query_path = p_query_path;
1955:
1956: cursor query_objects(p_object_name varchar2, p_folder_name varchar2) is
1957: select distinct A.NAME, A.ANALYSIS_CYCLE_ID, B.QUERY_OBJECT_PATH
1958: from ZPB_ANALYSIS_CYCLES A,
1959: ZPB_CYCLE_MODEL_DIMENSIONS B
1960: where B.QUERY_OBJECT_NAME = p_object_name
1961: and B.QUERY_OBJECT_PATH like '%'||p_folder_name
1962: and A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID

Line 2038: ZPB_ANALYSIS_CYCLES B,

2034: select A.TASK_NAME, A.TASK_ID, A.ANALYSIS_CYCLE_ID,
2035: nvl (D.INSTANCE_DESCRIPTION, B.NAME) NAME
2036: into l_str2, l_taskID, l_acID, l_str
2037: from ZPB_ANALYSIS_CYCLE_TASKS A,
2038: ZPB_ANALYSIS_CYCLES B,
2039: ZPB_TASK_PARAMETERS C,
2040: ZPB_ANALYSIS_CYCLE_INSTANCES D
2041: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
2042: and B.STATUS_CODE <> 'MARKED_FOR_DELETION'

Line 2355: l_acID ZPB_ANALYSIS_CYCLES.ANALYSIS_CYCLE_ID%type;

2351: l_queryPath ZPB_STATUS_SQL.QUERY_PATH%type;
2352: l_queryErrorType varchar2(1);
2353: l_dim ZPB_CYCLE_MODEL_DIMENSIONS.DIMENSION_NAME%type;
2354: l_dimName ZPB_CYCLE_MODEL_DIMENSIONS.DIMENSION_NAME%type;
2355: l_acID ZPB_ANALYSIS_CYCLES.ANALYSIS_CYCLE_ID%type;
2356: l_bpName ZPB_ANALYSIS_CYCLES.NAME%type;
2357: l_memberID ZPB_LINE_DIMENSIONALITY.MEMBER%type;
2358: l_memberName VARCHAR2(255);
2359: l_rem_def_hier_dim VARCHAR2(30);

Line 2356: l_bpName ZPB_ANALYSIS_CYCLES.NAME%type;

2352: l_queryErrorType varchar2(1);
2353: l_dim ZPB_CYCLE_MODEL_DIMENSIONS.DIMENSION_NAME%type;
2354: l_dimName ZPB_CYCLE_MODEL_DIMENSIONS.DIMENSION_NAME%type;
2355: l_acID ZPB_ANALYSIS_CYCLES.ANALYSIS_CYCLE_ID%type;
2356: l_bpName ZPB_ANALYSIS_CYCLES.NAME%type;
2357: l_memberID ZPB_LINE_DIMENSIONALITY.MEMBER%type;
2358: l_memberName VARCHAR2(255);
2359: l_rem_def_hier_dim VARCHAR2(30);
2360: l_current_dim VARCHAR2(30);

Line 2396: from ZPB_DC_OBJECTS A, ZPB_ANALYSIS_CYCLES B

2392:
2393: cursor l_dc_tg_objs(p_search_str VARCHAR2, p_baID NUMBER) is
2394: select TEMPLATE_NAME, OBJECT_TYPE, A.ANALYSIS_CYCLE_ID, TARGET_OBJ_PATH
2395: into l_str2, l_str, l_acID, l_queryPath
2396: from ZPB_DC_OBJECTS A, ZPB_ANALYSIS_CYCLES B
2397: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
2398: AND B.STATUS_CODE <> 'MARKED_FOR_DELETION'
2399: AND B.BUSINESS_AREA_ID = p_baID
2400: AND TARGET_OBJ_NAME = p_search_str;

Line 2405: from ZPB_DC_OBJECTS A, ZPB_ANALYSIS_CYCLES B

2401:
2402: cursor l_dc_data_objs(p_search_str VARCHAR2, p_baID NUMBER) is
2403: select TEMPLATE_NAME, OBJECT_TYPE, A.ANALYSIS_CYCLE_ID, TARGET_OBJ_PATH
2404: into l_str2, l_str, l_acID, l_queryPath
2405: from ZPB_DC_OBJECTS A, ZPB_ANALYSIS_CYCLES B
2406: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
2407: AND B.STATUS_CODE <> 'MARKED_FOR_DELETION'
2408: AND B.BUSINESS_AREA_ID = p_baID
2409: AND DATAENTRY_OBJ_NAME = p_search_str;

Line 2414: from ZPB_SOLVE_INPUT_SELECTIONS A, ZPB_ANALYSIS_CYCLES B

2410:
2411: cursor l_input_sel(p_search_str VARCHAR2, p_baID NUMBER) is
2412: select SELECTION_NAME, SELECTION_PATH, A.ANALYSIS_CYCLE_ID, DIMENSION, B.NAME
2413: into l_str, l_queryPath, l_acID, l_current_dim, l_bpName
2414: from ZPB_SOLVE_INPUT_SELECTIONS A, ZPB_ANALYSIS_CYCLES B
2415: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
2416: AND B.STATUS_CODE <> 'MARKED_FOR_DELETION'
2417: AND B.BUSINESS_AREA_ID = p_baID
2418: AND SELECTION_NAME = p_search_str;

Line 2423: from ZPB_SOLVE_OUTPUT_SELECTIONS A, ZPB_ANALYSIS_CYCLES B

2419:
2420: cursor l_output_sel(p_search_str VARCHAR2, p_baID NUMBER) is
2421: select SELECTION_NAME, SELECTION_PATH, A.ANALYSIS_CYCLE_ID, DIMENSION, B.NAME
2422: into l_str, l_queryPath, l_acID, l_current_dim, l_bpName
2423: from ZPB_SOLVE_OUTPUT_SELECTIONS A, ZPB_ANALYSIS_CYCLES B
2424: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
2425: AND B.STATUS_CODE <> 'MARKED_FOR_DELETION'
2426: AND B.BUSINESS_AREA_ID = p_baID
2427: AND SELECTION_NAME = p_search_str;

Line 2432: from ZPB_DATA_INITIALIZATION_DEFS A, ZPB_ANALYSIS_CYCLES B

2428:
2429: cursor l_init_source(p_search_str VARCHAR2, p_baID NUMBER) is
2430: select SOURCE_QUERY_NAME, QUERY_PATH, MEMBER, A.ANALYSIS_CYCLE_ID
2431: into l_str, l_queryPath, l_memberID, l_acID
2432: from ZPB_DATA_INITIALIZATION_DEFS A, ZPB_ANALYSIS_CYCLES B
2433: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
2434: AND B.STATUS_CODE <> 'MARKED_FOR_DELETION'
2435: AND B.BUSINESS_AREA_ID = p_baID
2436: AND SOURCE_QUERY_NAME = p_search_str;

Line 2441: from ZPB_DATA_INITIALIZATION_DEFS A, ZPB_ANALYSIS_CYCLES B

2437:
2438: cursor l_init_target(p_search_str VARCHAR2, p_baID NUMBER) is
2439: select TARGET_QUERY_NAME, QUERY_PATH, MEMBER, A.ANALYSIS_CYCLE_ID
2440: into l_str, l_queryPath, l_memberID, l_acID
2441: from ZPB_DATA_INITIALIZATION_DEFS A, ZPB_ANALYSIS_CYCLES B
2442: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
2443: AND B.STATUS_CODE <> 'MARKED_FOR_DELETION'
2444: AND B.BUSINESS_AREA_ID = p_baID
2445: AND TARGET_QUERY_NAME = p_search_str;

Line 2450: from zpb_cycle_model_dimensions A, ZPB_ANALYSIS_CYCLES B

2446:
2447: cursor l_sum_sel1(p_search_str VARCHAR2, p_baID NUMBER) is
2448: select SUM_SELECTION_NAME, SUM_SELECTION_PATH, DIMENSION_NAME, A.ANALYSIS_CYCLE_ID
2449: into l_str, l_queryPath, l_dim, l_acID
2450: from zpb_cycle_model_dimensions A, ZPB_ANALYSIS_CYCLES B
2451: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
2452: AND B.STATUS_CODE <> 'MARKED_FOR_DELETION'
2453: AND B.BUSINESS_AREA_ID = p_baID
2454: AND SUM_SELECTION_NAME = p_search_str;

Line 2459: from ZPB_LINE_DIMENSIONALITY A, ZPB_ANALYSIS_CYCLES B

2455:
2456: cursor l_sum_sel2(p_search_str VARCHAR2, p_baID NUMBER) is
2457: select SUM_SELECTION_NAME, SUM_SELECTION_PATH, MEMBER, DIMENSION, A.ANALYSIS_CYCLE_ID
2458: into l_str, l_queryPath, l_memberID, l_dim, l_acID
2459: from ZPB_LINE_DIMENSIONALITY A, ZPB_ANALYSIS_CYCLES B
2460: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
2461: AND B.STATUS_CODE <> 'MARKED_FOR_DELETION'
2462: AND B.BUSINESS_AREA_ID = p_baID
2463: AND SUM_SELECTION_NAME = p_search_str;

Line 2488: from ZPB_ANALYSIS_CYCLES A,

2484: WHERE query_path = p_query_path;
2485:
2486: cursor query_objects(p_object_name varchar2, p_folder_name varchar2) is
2487: select distinct A.NAME, A.ANALYSIS_CYCLE_ID, B.QUERY_OBJECT_PATH
2488: from ZPB_ANALYSIS_CYCLES A,
2489: ZPB_CYCLE_MODEL_DIMENSIONS B
2490: where B.QUERY_OBJECT_NAME = p_object_name
2491: and B.QUERY_OBJECT_PATH like '%'||p_folder_name
2492: and A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID

Line 2576: ZPB_ANALYSIS_CYCLES B,

2572: select A.TASK_NAME, A.TASK_ID, A.ANALYSIS_CYCLE_ID,
2573: nvl (D.INSTANCE_DESCRIPTION, B.NAME) NAME
2574: into l_str2, l_taskID, l_acID, l_str
2575: from ZPB_ANALYSIS_CYCLE_TASKS A,
2576: ZPB_ANALYSIS_CYCLES B,
2577: ZPB_TASK_PARAMETERS C,
2578: ZPB_ANALYSIS_CYCLE_INSTANCES D
2579: where A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID
2580: and B.STATUS_CODE <> 'MARKED_FOR_DELETION'

Line 2915: l_name ZPB_ANALYSIS_CYCLES.NAME%type;

2911: l_refr_vers ZPB_BUSAREA_VERSIONS.VERSION_ID%type;
2912: l_vers_type ZPB_BUSAREA_VERSIONS.VERSION_TYPE%type;
2913: l_ba_id ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;
2914: l_aw ZPB_BUSINESS_AREAS.DATA_AW%type;
2915: l_name ZPB_ANALYSIS_CYCLES.NAME%type;
2916: l_folder BISM_OBJECTS.FOLDER_ID%type;
2917: l_num NUMBER;
2918: l_id VARCHAR2(60);
2919: l_view VARCHAR2(60);

Line 3048: from ZPB_ANALYSIS_CYCLES A, ZPB_CYCLE_DATASETS B,

3044: where B.VERSION_ID = p_version_id);
3045:
3046: cursor l_ac_datasets(p_ba NUMBER, p_dataset NUMBER) is
3047: select distinct nvl (C.INSTANCE_DESCRIPTION, A.NAME) NAME
3048: from ZPB_ANALYSIS_CYCLES A, ZPB_CYCLE_DATASETS B,
3049: ZPB_ANALYSIS_CYCLE_INSTANCES C
3050: where A.BUSINESS_AREA_ID = p_ba
3051: and A.STATUS_CODE <> 'MARKED_FOR_DELETION'
3052: and A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID