APPS.ZPB_EXCP_PVT dependencies on ZPB_STATUS_SQL

Line 31: l_dim ZPB_STATUS_SQL.dimension_name%type;

27: l_query_name ZPB_TASK_PARAMETERS.value%type;
28: l_query VARCHAR2(8000);
29: l_user_id VARCHAR2(64);
30: l_task_id VARCHAR2(64);
31: l_dim ZPB_STATUS_SQL.dimension_name%type;
32: l_hier ZPB_STATUS_SQL.hierarchy_name%type;
33: l_count NUMBER;
34: l_excp_ct VARCHAR2(32766);
35:

Line 32: l_hier ZPB_STATUS_SQL.hierarchy_name%type;

28: l_query VARCHAR2(8000);
29: l_user_id VARCHAR2(64);
30: l_task_id VARCHAR2(64);
31: l_dim ZPB_STATUS_SQL.dimension_name%type;
32: l_hier ZPB_STATUS_SQL.hierarchy_name%type;
33: l_count NUMBER;
34: l_excp_ct VARCHAR2(32766);
35:
36: l_instance_id NUMBER;

Line 48: from zpb_status_sql

44: or name = QUERY_OBJECT_NAME );
45:
46: cursor statSqlMbrs is
47: select dimension_name dim, hierarchy_name hier
48: from zpb_status_sql
49: where (query_path = l_query);
50:
51: BEGIN
52:

Line 101: --populate zpb_status_sql_members table

97:
98: -- Standard Start of API savepoint
99: SAVEPOINT zpb_excp_pvt_run_exception;
100:
101: --populate zpb_status_sql_members table
102: --ZPB_AW_STATUS.RUN_OLAPI_QUERIES( l_query );
103:
104: --Test the query entry. The same dimension and hierarchy must exist for all rows.
105: l_count := 1;

Line 359: l_dim ZPB_STATUS_SQL.dimension_name%type;

355: l_user_id NUMBER;
356: l_resp_id NUMBER;
357: l_resp_key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%type;
358: l_task_id VARCHAR2(16);
359: l_dim ZPB_STATUS_SQL.dimension_name%type;
360: l_hier ZPB_STATUS_SQL.hierarchy_name%type;
361: l_count NUMBER;
362: l_child_ct VARCHAR2(2000);
363:

Line 360: l_hier ZPB_STATUS_SQL.hierarchy_name%type;

356: l_resp_id NUMBER;
357: l_resp_key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%type;
358: l_task_id VARCHAR2(16);
359: l_dim ZPB_STATUS_SQL.dimension_name%type;
360: l_hier ZPB_STATUS_SQL.hierarchy_name%type;
361: l_count NUMBER;
362: l_child_ct VARCHAR2(2000);
363:
364: cursor task_dfn is

Line 373: from zpb_status_sql

369: or name = QUERY_OBJECT_NAME );
370:
371: cursor statSqlMbrs is
372: select dimension_name dim, hierarchy_name hier
373: from zpb_status_sql
374: where (query_path = l_query);
375:
376: BEGIN
377:

Line 430: --populate zpb_status_sql_members table

426: --
427: --Removed the following call, as this should be called on the OLAP connection
428: --ZPB_AW.INITIALIZE_WORKSPACE(1.0, FND_API.G_FALSE, p_validation_level, x_return_status, x_msg_count, x_msg_data, l_user_id, l_resp_key);
429:
430: --populate zpb_status_sql_members table
431: --ZPB_AW_STATUS.RUN_OLAPI_QUERIES( l_query );
432:
433: --test the OLAPI query results. The same dimension and hierarchy must exist for all rows.
434: l_count := 1;