APPS.ZPB_BUSAREA_VAL dependencies on ZPB_STATUS_SQL

Line 50: p_queryPath IN ZPB_STATUS_SQL.QUERY_PATH%type,

46: ------------------------------------------------------------------------------
47: PROCEDURE LOCK_OUT_USER(p_baId IN NUMBER,
48: p_userid IN FND_USER.USER_ID%type,
49: p_queryName IN VARCHAR2,
50: p_queryPath IN ZPB_STATUS_SQL.QUERY_PATH%type,
51: p_queryType IN VARCHAR2,
52: p_queryErrorType IN VARCHAR2,
53: p_init_fix IN VARCHAR2,
54: p_statusSqlId IN ZPB_STATUS_SQL.STATUS_SQL_ID%type)

Line 54: p_statusSqlId IN ZPB_STATUS_SQL.STATUS_SQL_ID%type)

50: p_queryPath IN ZPB_STATUS_SQL.QUERY_PATH%type,
51: p_queryType IN VARCHAR2,
52: p_queryErrorType IN VARCHAR2,
53: p_init_fix IN VARCHAR2,
54: p_statusSqlId IN ZPB_STATUS_SQL.STATUS_SQL_ID%type)
55: IS
56:
57: BEGIN
58:

Line 1839: l_queryPath ZPB_STATUS_SQL.QUERY_PATH%type;

1835: l_user_id FND_USER.USER_ID%type;
1836: l_xml BISM_OBJECTS.XML%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;

Line 1847: l_secFoldPath ZPB_STATUS_SQL.QUERY_PATH%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;
1849: l_command VARCHAR2(2000);
1850: l_cursor epb_cur_type;
1851:

Line 1848: l_statusSqlId ZPB_STATUS_SQL.STATUS_SQL_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;
1849: l_command VARCHAR2(2000);
1850: l_cursor epb_cur_type;
1851:
1852: CURSOR l_objs(p_search_str VARCHAR2,

Line 1953: FROM zpb_status_sql

1949: AND SUM_SELECTION_NAME = p_search_str;
1950:
1951: CURSOR l_get_status_sql_id(p_query_path VARCHAR2) IS
1952: SELECT status_sql_id
1953: FROM zpb_status_sql
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

Line 2351: l_queryPath ZPB_STATUS_SQL.QUERY_PATH%type;

2347: l_xml BISM_OBJECTS.XML%type;
2348: l_line_dim VARCHAR2(150);
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;

Line 2361: l_secFoldPath ZPB_STATUS_SQL.QUERY_PATH%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);
2361: l_secFoldPath ZPB_STATUS_SQL.QUERY_PATH%type;
2362: l_statusSqlId ZPB_STATUS_SQL.STATUS_SQL_ID%type;
2363: l_command VARCHAR2(1000);
2364: l_cursor epb_cur_type;
2365:

Line 2362: l_statusSqlId ZPB_STATUS_SQL.STATUS_SQL_ID%type;

2358: l_memberName VARCHAR2(255);
2359: l_rem_def_hier_dim VARCHAR2(30);
2360: l_current_dim VARCHAR2(30);
2361: l_secFoldPath ZPB_STATUS_SQL.QUERY_PATH%type;
2362: l_statusSqlId ZPB_STATUS_SQL.STATUS_SQL_ID%type;
2363: l_command VARCHAR2(1000);
2364: l_cursor epb_cur_type;
2365:
2366: CURSOR l_objs(p_search_str VARCHAR2,

Line 2483: FROM zpb_status_sql

2479: AND TARGET_NUM_MEMBERS IS NOT NULL;
2480:
2481: CURSOR l_get_status_sql_id(p_query_path VARCHAR2) IS
2482: SELECT status_sql_id
2483: FROM zpb_status_sql
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