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_MAINT dependencies on ZPB_AW

Line 1338: select ZPB_AW.GET_SCHEMA||'.'||PERSONAL_AW AW_NAME

1334: where BUSINESS_AREA_ID = p_business_area_id;
1335: l_cycles l_cycles_curs%ROWTYPE;
1336:
1337: cursor l_aws_curs is
1338: select ZPB_AW.GET_SCHEMA||'.'||PERSONAL_AW AW_NAME
1339: from ZPB_USERS
1340: where BUSINESS_AREA_ID = p_business_area_id
1341: UNION
1342: select ZPB_AW.GET_SCHEMA||'.'||DATA_AW AW_NAME

Line 1342: select ZPB_AW.GET_SCHEMA||'.'||DATA_AW AW_NAME

1338: select ZPB_AW.GET_SCHEMA||'.'||PERSONAL_AW AW_NAME
1339: from ZPB_USERS
1340: where BUSINESS_AREA_ID = p_business_area_id
1341: UNION
1342: select ZPB_AW.GET_SCHEMA||'.'||DATA_AW AW_NAME
1343: from ZPB_BUSINESS_AREAS
1344: where BUSINESS_AREA_ID = p_business_area_id
1345: UNION
1346: select ZPB_AW.GET_SCHEMA||'.'||ANNOTATION_AW AW_NAME

Line 1346: select ZPB_AW.GET_SCHEMA||'.'||ANNOTATION_AW AW_NAME

1342: select ZPB_AW.GET_SCHEMA||'.'||DATA_AW AW_NAME
1343: from ZPB_BUSINESS_AREAS
1344: where BUSINESS_AREA_ID = p_business_area_id
1345: UNION
1346: select ZPB_AW.GET_SCHEMA||'.'||ANNOTATION_AW AW_NAME
1347: from ZPB_BUSINESS_AREAS
1348: where BUSINESS_AREA_ID = p_business_area_id
1349: UNION
1350: select ZPB_AW.GET_SCHEMA||'.SQTEMP'||p_business_area_id from dual;

Line 1350: select ZPB_AW.GET_SCHEMA||'.SQTEMP'||p_business_area_id from dual;

1346: select ZPB_AW.GET_SCHEMA||'.'||ANNOTATION_AW AW_NAME
1347: from ZPB_BUSINESS_AREAS
1348: where BUSINESS_AREA_ID = p_business_area_id
1349: UNION
1350: select ZPB_AW.GET_SCHEMA||'.SQTEMP'||p_business_area_id from dual;
1351:
1352: l_aws l_aws_curs%ROWTYPE;
1353:
1354: cursor l_session_curs(l_aw_name VARCHAR2) is

Line 1365: a.owner = zpb_aw.get_schema;

1361: l.id2 >= 1000 and
1362: a.aw_number=l.id2 and
1363: s.sid=l.sid and
1364: a.aw_name = l_aw_name and
1365: a.owner = zpb_aw.get_schema;
1366: begin
1367: select SNAPSHOT_OBJECT_ID
1368: into l_snapshot_id
1369: from ZPB_BUSINESS_AREAS

Line 1504: ZPB_AW.EXECUTE ('aw delete '||l_aws.AW_NAME);

1500: for each in l_session_curs(l_aws.AW_NAME) loop
1501: execute immediate each.cmd;
1502: end loop;
1503: begin
1504: ZPB_AW.EXECUTE ('aw delete '||l_aws.AW_NAME);
1505: exception
1506: when others then
1507: ZPB_LOG.LOG_PLSQL_EXCEPTION
1508: ('zpb_busarea_maint.delete_business_area', 4);

Line 2344: -- OUT: p_aw_dim_name - ZPB AW Dimension Name

2340: -- - Added for "Consistent Dimension" Project
2341: --
2342: -- IN: p_dim_type_code - FEM Dimension Type Code
2343: -- p_member_b_table - FEM XDIM Member B Table
2344: -- OUT: p_aw_dim_name - ZPB AW Dimension Name
2345: -------------------------------------------------------------------------
2346: PROCEDURE GENERATE_AW_DIM_NAME (p_dim_type_code IN VARCHAR2,
2347: p_member_b_table IN VARCHAR2,
2348: p_aw_dim_name OUT NOCOPY VARCHAR2)

Line 2364: l_schema := zpb_aw.get_schema;

2360:
2361: else
2362:
2363: l_aw_dim_name := p_member_b_table;
2364: l_schema := zpb_aw.get_schema;
2365:
2366: if (instr(l_aw_dim_name, l_schema) = 1) then
2367: l_aw_dim_name := substr(l_aw_dim_name,5);
2368: end if;