APPS.ZPB_BUSAREA_VAL dependencies on ZPB_CYCLE_MODEL_DIMENSIONS

Line 1841: l_dim ZPB_CYCLE_MODEL_DIMENSIONS.DIMENSION_NAME%type;

1837: l_line_dim VARCHAR2(150);
1838: l_folder BISM_OBJECTS.FOLDER_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;

Line 1842: l_dimName ZPB_CYCLE_MODEL_DIMENSIONS.DIMENSION_NAME%type;

1838: l_folder BISM_OBJECTS.FOLDER_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);

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 1959: ZPB_CYCLE_MODEL_DIMENSIONS B

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
1963: and A.STATUS_CODE <> 'MARKED_FOR_DELETION'

Line 2353: l_dim ZPB_CYCLE_MODEL_DIMENSIONS.DIMENSION_NAME%type;

2349: l_line_dimID VARCHAR2(30);
2350: l_folder BISM_OBJECTS.FOLDER_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;

Line 2354: l_dimName ZPB_CYCLE_MODEL_DIMENSIONS.DIMENSION_NAME%type;

2350: l_folder BISM_OBJECTS.FOLDER_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);

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 2489: ZPB_CYCLE_MODEL_DIMENSIONS B

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
2493: and A.STATUS_CODE <> 'MARKED_FOR_DELETION'