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.AZW_REPORT dependencies on AZ_MONITOR_REPORTS

Line 128: node_id AZ_MONITOR_REPORTS.NODE_ID%TYPE,

124: node_id AZ_PLANNING_REPORTS.NODE_ID%TYPE
125: );
126:
127: TYPE StatusProcessGroupRec IS RECORD(
128: node_id AZ_MONITOR_REPORTS.NODE_ID%TYPE,
129: display_name AZ_MONITOR_REPORTS.DISPLAY_NAME%TYPE,
130: processes_count INTEGER,
131: active_procs_count INTEGER,
132: complete_procs_count INTEGER,

Line 129: display_name AZ_MONITOR_REPORTS.DISPLAY_NAME%TYPE,

125: );
126:
127: TYPE StatusProcessGroupRec IS RECORD(
128: node_id AZ_MONITOR_REPORTS.NODE_ID%TYPE,
129: display_name AZ_MONITOR_REPORTS.DISPLAY_NAME%TYPE,
130: processes_count INTEGER,
131: active_procs_count INTEGER,
132: complete_procs_count INTEGER,
133: not_started_procs_count INTEGER

Line 911: * Private procedure. Called by reports that use az_monitor_reports as the

907:
908: /*------------------------------------------------------------------------
909: * GET_MONITOR_GROUP_PARENT
910: *
911: * Private procedure. Called by reports that use az_monitor_reports as the
912: * intermediate data storage (get_user_trees_by_period,
913: * get_user_trees_by_atleast, get_user_trees_by_atmost, get_status_groups).
914: * Given a group id, recursively get all its group parents into the
915: * intermediate table if the parent does not exist in the table.

Line 955: FROM az_monitor_reports amr

951:
952: v_locator := 2;
953: SELECT COUNT(*)
954: INTO v_exist_cnt
955: FROM az_monitor_reports amr
956: WHERE amr.node_id = v_group.node_id
957: AND amr.assigned_user = p_user;
958:
959: IF (v_exist_cnt = 0) THEN

Line 962: INSERT INTO az_monitor_reports

958:
959: IF (v_exist_cnt = 0) THEN
960: v_status := get_translation('AZ_PROCESS_STATUS', v_group.status);
961: v_locator := 3;
962: INSERT INTO az_monitor_reports
963: (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
964: CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
965: STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
966: VALUES

Line 1323: INSERT INTO az_monitor_reports

1319: IF (p_status IS NULL) THEN /* get all processes */
1320: v_locator := 1;
1321: FOR one_proc IN all_processes_cursor LOOP
1322: v_status := get_translation('AZ_PROCESS_STATUS', one_proc.status);
1323: INSERT INTO az_monitor_reports
1324: (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
1325: CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
1326: STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
1327: VALUES

Line 1337: INSERT INTO az_monitor_reports

1333: ELSIF (p_status = 'I') THEN
1334: v_locator := 2;
1335: FOR one_proc IN incomplete_processes_cursor LOOP
1336: v_status := get_translation('AZ_PROCESS_STATUS', one_proc.status);
1337: INSERT INTO az_monitor_reports
1338: (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
1339: CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
1340: STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
1341: VALUES

Line 1351: INSERT INTO az_monitor_reports

1347: ELSE /* get processes of A, C or N status */
1348: v_locator := 3;
1349: v_status := get_translation('AZ_PROCESS_STATUS', p_status);
1350: FOR one_proc IN status_processes_cursor LOOP
1351: INSERT INTO az_monitor_reports
1352: (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
1353: CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
1354: STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
1355: VALUES

Line 1460: INSERT INTO az_monitor_reports

1456: ELSIF (p_status IS NULL) THEN /* get tasks for all processes */
1457: v_locator := 1;
1458: FOR one_task IN all_tasks_cursor LOOP
1459: v_status := get_translation('AZ_PROCESS_STATUS', one_task.status);
1460: INSERT INTO az_monitor_reports
1461: (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
1462: CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
1463: STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
1464: VALUES

Line 1475: INSERT INTO az_monitor_reports

1471: ELSIF (p_status = 'I') THEN
1472: v_locator := 2;
1473: FOR one_task IN incomplete_tasks_cursor LOOP
1474: v_status := get_translation('AZ_PROCESS_STATUS', one_task.status);
1475: INSERT INTO az_monitor_reports
1476: (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
1477: CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
1478: STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
1479: VALUES

Line 1489: INSERT INTO az_monitor_reports

1485: ELSE /* get tasks for processes of A or C status */
1486: v_locator := 3;
1487: FOR one_task IN status_tasks_cursor LOOP
1488: v_status := get_translation('AZ_PROCESS_STATUS', one_task.status);
1489: INSERT INTO az_monitor_reports
1490: (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
1491: CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
1492: STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
1493: VALUES

Line 1777: INSERT INTO az_monitor_reports

1773: -- get tasks
1774: v_locator := 1;
1775: FOR one_task IN atleast_tasks_cursor LOOP
1776: v_status := get_translation('AZ_PROCESS_STATUS', one_task.status);
1777: INSERT INTO az_monitor_reports
1778: (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
1779: CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
1780: STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
1781: VALUES

Line 1791: INSERT INTO az_monitor_reports

1787: -- get processes
1788: v_status := get_translation('AZ_PROCESS_STATUS', p_status);
1789: v_locator := 2;
1790: FOR one_proc IN atleast_processes_cursor LOOP
1791: INSERT INTO az_monitor_reports
1792: (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
1793: CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
1794: STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
1795: VALUES

Line 1811: INSERT INTO az_monitor_reports

1807: v_locator := 4;
1808: -- get tasks
1809: FOR one_task IN atleast_both_tasks_cursor LOOP
1810: v_status:=get_translation('AZ_PROCESS_STATUS', one_task.status);
1811: INSERT INTO az_monitor_reports
1812: (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
1813: CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
1814: STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
1815: VALUES

Line 1825: INSERT INTO az_monitor_reports

1821: v_locator := 5;
1822: -- get processes
1823: FOR one_proc IN atleast_both_processes_cursor LOOP
1824: v_status := get_translation('AZ_PROCESS_STATUS', one_proc.status);
1825: INSERT INTO az_monitor_reports
1826: (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
1827: CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
1828: STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
1829: VALUES

Line 1999: INSERT INTO az_monitor_reports

1995: -- get tasks
1996: v_locator := 1;
1997: FOR one_task IN atmost_tasks_cursor LOOP
1998: v_status := get_translation('AZ_PROCESS_STATUS', one_task.status);
1999: INSERT INTO az_monitor_reports
2000: (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
2001: CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
2002: STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
2003: VALUES

Line 2013: INSERT INTO az_monitor_reports

2009: v_locator := 2;
2010: -- get processes
2011: v_status := get_translation('AZ_PROCESS_STATUS', p_status);
2012: FOR one_proc IN atmost_processes_cursor LOOP
2013: INSERT INTO az_monitor_reports
2014: (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
2015: CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
2016: STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
2017: VALUES

Line 2033: INSERT INTO az_monitor_reports

2029: v_locator := 4;
2030: -- get tasks
2031: FOR one_task IN atmost_both_tasks_cursor LOOP
2032: v_status := get_translation('AZ_PROCESS_STATUS', one_task.status);
2033: INSERT INTO az_monitor_reports
2034: (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
2035: CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
2036: STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
2037: VALUES

Line 2047: INSERT INTO az_monitor_reports

2043: v_locator := 5;
2044: -- get processes
2045: FOR one_proc IN atmost_both_processes_cursor LOOP
2046: v_status := get_translation('AZ_PROCESS_STATUS', one_proc.status);
2047: INSERT INTO az_monitor_reports
2048: (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
2049: CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
2050: STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
2051: VALUES

Line 2241: INSERT INTO az_monitor_reports

2237: v_locator := 1;
2238: -- get tasks
2239: FOR one_task IN period_tasks_cursor LOOP
2240: v_status := get_translation('AZ_PROCESS_STATUS', one_task.status);
2241: INSERT INTO az_monitor_reports
2242: (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
2243: CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
2244: STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
2245: VALUES

Line 2255: INSERT INTO az_monitor_reports

2251: v_locator := 2;
2252: -- get processes
2253: v_status := get_translation('AZ_PROCESS_STATUS', p_status);
2254: FOR one_proc IN period_processes_cursor LOOP
2255: INSERT INTO az_monitor_reports
2256: (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
2257: CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
2258: STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
2259: VALUES

Line 2275: INSERT INTO az_monitor_reports

2271: v_locator := 4;
2272: -- get tasks
2273: FOR one_task IN period_both_tasks_cursor LOOP
2274: v_status := get_translation('AZ_PROCESS_STATUS', one_task.status);
2275: INSERT INTO az_monitor_reports
2276: (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
2277: CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
2278: STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
2279: VALUES

Line 2289: INSERT INTO az_monitor_reports

2285: v_locator := 5;
2286: -- get processes
2287: FOR one_proc IN period_both_processes_cursor LOOP
2288: v_status := get_translation('AZ_PROCESS_STATUS', one_proc.status);
2289: INSERT INTO az_monitor_reports
2290: (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
2291: CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
2292: STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
2293: VALUES

Line 3945: FROM az_monitor_reports

3941: display_name,
3942: node_type,
3943: parent_node_id,
3944: status_code_name
3945: FROM az_monitor_reports
3946: START WITH parent_node_id IS NULL
3947: CONNECT BY PRIOR node_id = parent_node_id;
3948:
3949: product_rec products_cursor%ROWTYPE;

Line 4799: FROM az_monitor_reports

4795: LEVEL,
4796: parent_node_id,
4797: node_id,
4798: COMMENTS
4799: FROM az_monitor_reports
4800: START WITH parent_node_id IS NULL
4801: CONNECT BY PRIOR node_id = parent_node_id;
4802:
4803: v_colspan PLS_INTEGER;

Line 4809: v_ctx_type_name az_monitor_reports.context_type_name%TYPE;

4805: v_locator PLS_INTEGER := 0;
4806: v_href VARCHAR2(4000);
4807: v_upper_group_names HierarchyLevels;
4808:
4809: v_ctx_type_name az_monitor_reports.context_type_name%TYPE;
4810: v_process_groups VARCHAR2(4000);
4811: v_item_type AZ_TASKS_V.ITEM_TYPE%TYPE;
4812: v_item_key AZ_TASKS_V.ITEM_KEY%TYPE;
4813:

Line 5277: FROM az_monitor_reports

5273: parent_node_id,
5274: LEVEL,
5275: node_id,
5276: comments
5277: FROM az_monitor_reports
5278: WHERE assigned_user = x_user
5279: START WITH parent_node_id IS NULL
5280: CONNECT BY PRIOR node_id = parent_node_id
5281: AND PRIOR assigned_user = assigned_user

Line 5292: v_ctx_type_name az_monitor_reports.context_type_name%TYPE;

5288: v_item_key AZ_TASKS_V.ITEM_KEY%TYPE;
5289: v_href VARCHAR2(4000);
5290: v_upper_group_names HierarchyLevels;
5291:
5292: v_ctx_type_name az_monitor_reports.context_type_name%TYPE;
5293: v_process_groups VARCHAR2(4000);
5294:
5295: BEGIN
5296:

Line 5481: FROM az_monitor_reports

5477: FOR one IN valid_users_cursor LOOP
5478: v_locator := 7;
5479: SELECT count(*)
5480: INTO v_count
5481: FROM az_monitor_reports
5482: WHERE assigned_user = one.user_name;
5483: v_locator := 8;
5484: IF (v_count <> 0) THEN
5485: IF (i > 0) THEN

Line 5594: ** of tasks for each user specified in the temp table az_monitor_reports.

5590: ** ==========================
5591: **
5592: ** Private Procedure.
5593: ** It displays the report summary which contains the total number
5594: ** of tasks for each user specified in the temp table az_monitor_reports.
5595: **
5596: */
5597: PROCEDURE print_user_report_summary IS
5598:

Line 5601: FROM AZ_MONITOR_REPORTS

5597: PROCEDURE print_user_report_summary IS
5598:
5599: CURSOR user_task_count IS
5600: SELECT ASSIGNED_USER, COUNT(NODE_TYPE) NUM_TASKS
5601: FROM AZ_MONITOR_REPORTS
5602: WHERE NODE_TYPE='T'
5603: GROUP BY ASSIGNED_USER;
5604:
5605: BEGIN

Line 5939: ** The node id specified in the az_monitor_reports temp

5935: **
5936: ** GET_TASK_TYPE_KEY
5937: ** =================
5938: **
5939: ** The node id specified in the az_monitor_reports temp
5940: ** table is composed of multiple fields. two of them are
5941: ** the item_type and item_key fields.
5942: ** this procedure extracts and returns these two fields
5943: ** from the input node_id.