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 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 38


  g_selected    VARCHAR2(2000) := NULL;  -- Product Selected

Line: 76


  g_no_prod_sel 	VARCHAR2(2000) := NULL; -- no products selected

Line: 210


  PROCEDURE print_selected_prods_table (p_ids IN id_tbl_t);

Line: 234


		p_selected_products 	IN VARCHAR2,
		p_instance_id 		IN NUMBER,
		p_display_msg 		IN VARCHAR2);

Line: 252


**	It checks if any of the selected products is in
**	the defined list of installed products for the
**	current activity.
**	It returns Y or N to match
**
*/
FUNCTION check_activity_products (
		p_selected_products IN VARCHAR2,
		p_instance_id IN NUMBER) RETURN VARCHAR2 IS

  v_app_id     	NUMBER;

Line: 270


  v_app_id := azw_proc.parse_application_ids(p_selected_products, v_cnt);

Line: 274


    v_app_id := azw_proc.parse_application_ids(p_selected_products, v_cnt);

Line: 277


  SELECT TEXT_VALUE INTO v_inst_prods
  FROM wf_activity_attr_values
  WHERE NAME = 'AZW_IA_WFPROD'
  AND PROCESS_ACTIVITY_ID = p_instance_id
  AND TEXT_VALUE <> 'AZW_IA_WFPROD';

Line: 309


    SELECT application_name
    INTO   v_name
    FROM   fnd_application_vl
    WHERE  application_id = p_app_id;

Line: 335


    SELECT application_short_name
    INTO   v_name
    FROM   fnd_application_vl
    WHERE  application_id = p_app_id;

Line: 403


    SELECT meaning
    INTO   v_meaning
    FROM   fnd_lookups
    WHERE  lookup_type = p_type
    AND    lookup_code = p_code;

Line: 485


**      It checks if the specified instance ID has already been inserted
**      in the g_instance_ids PL/SQL table. Not to process an activity twice.
**      Called from display_process_steps, print_activity.
**
*/

FUNCTION is_act_notfound(p_instance_id IN NUMBER) return boolean IS
   i 	PLS_INTEGER;

Line: 611


   *      context report ans passes the user selected context type; Cancel

Line: 617


      SELECT   lookup_code,
               meaning,
               DECODE(lookup_code, 'NONE', 1, 'BG', 2, 'SOB', 3, 'OU', 4, 5)
                 display_order
      FROM     fnd_lookups
      WHERE    lookup_type = 'AZ_CONTEXT_TYPE'
      ORDER BY display_order;

Line: 641


    htp.p('');

Line: 686


      SELECT     LPAD(g_blank, g_indent*(LEVEL-1))||display_name hierarchy,
                 node_type,
                 context_type_name,
                 description,
                 parent_node_id,
                 node_id,
                 LEVEL
      FROM       az_planning_reports
      START WITH parent_node_id IS NULL
      CONNECT BY PRIOR node_id = parent_node_id
      AND	 PRIOR phase = phase;

Line: 799


      SELECT DISTINCT TO_CHAR(apv.display_order, '0000')||'.'||apv.item_type
               ||'.'||apv.process_name node_id,
             apv.display_name,
             apv.context_type_name,
             TO_CHAR(ag.display_order, '0000')||'.'||apv.parent_id
               parent_node_id,
             apv.description
      FROM   az_processes_all_v apv,
     	     az_groups ag
      WHERE  (apv.context_type = p_context OR apv.context_type = 'NONE')
      AND    apv.process_type = 'IMP'
      AND    apv.parent_id = ag.group_id
      AND    ag.process_type = apv.process_type;

Line: 814


      SELECT DISTINCT apv.parent_id
      FROM   az_processes_all_v apv
      WHERE  apv.context_type = p_context OR apv.context_type = 'NONE';

Line: 822


      INSERT INTO az_planning_reports
      (NODE_ID, PHASE, NODE_TYPE, DISPLAY_NAME,
        CONTEXT_TYPE_NAME,PARENT_NODE_ID, DESCRIPTION)
      VALUES
      (one_proc.node_id, -1, 'P', one_proc.display_name,
       one_proc.context_type_name, one_proc.parent_node_id, one_proc.description);

Line: 859


       SELECT DISTINCT TO_CHAR(apv.display_order, '0000')||'.'||
             apv.item_type ||'.'||apv.process_name node_id,
             apv.display_name,
             TO_CHAR(agv.display_order, '0000')||'.'|| apv.parent_id parent_node_id,
             apv.description
      FROM   az_processes_all_v apv,
             az_groups agv,
             az_flow_phases_v afpv
      WHERE  afpv.phase = p_phase
      AND    afpv.item_type = apv.item_type
      AND    afpv.process_name = apv.process_name
      AND    apv.parent_id = agv.group_id
      AND    apv.process_type = 'IMP'
      AND    agv.process_type = apv.process_type;

Line: 875


      SELECT DISTINCT apv.parent_id
      FROM   az_processes apv,
             az_flow_phases_v afpv
      WHERE  apv.item_type = afpv.item_type
      AND    apv.process_name = afpv.process_name
      AND    apv.process_type = 'IMP'
      AND    afpv.phase = p_phase;

Line: 887


      INSERT INTO az_planning_reports
       (NODE_ID, PHASE, NODE_TYPE, DISPLAY_NAME,
        CONTEXT_TYPE_NAME,PARENT_NODE_ID, DESCRIPTION)
       VALUES
            (one_process.node_id, p_phase, 'P', one_process.display_name, '',
             one_process.parent_node_id, one_process.description);

Line: 921


       SELECT TO_CHAR(agv.display_order, '0000')||'.'||agv.group_id node_id,
         agv.display_name,
         TO_CHAR(ag.display_order, '0000')||'.'|| agv.hierarchy_parent_id  parent_node_id,
         agv.status,
         agv.hierarchy_parent_id h_parent_id
        FROM   az_groups_v agv,
               az_groups ag
        WHERE   agv.group_id = p_group_id
        AND   	agv.process_type = g_current_mode
        AND   	ag.process_type = g_current_mode
        AND    	agv.hierarchy_parent_id = ag.group_id
        UNION
        SELECT TO_CHAR(agv.display_order, '0000')||'.'||agv.group_id node_id,
               agv.display_name,
               NULL parent_node_id,
               agv.status,
               NULL  h_parent_id
        FROM    az_groups_v agv
        WHERE   agv.group_id = p_group_id
        AND     agv.process_type = g_current_mode
        AND     agv.hierarchy_parent_id IS NULL;

Line: 953


    SELECT COUNT(*)
    INTO   v_exist_cnt
    FROM   az_monitor_reports amr
    WHERE  amr.node_id = v_group.node_id
    AND    amr.assigned_user = p_user;

Line: 962


      INSERT INTO az_monitor_reports
       (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
         CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
          STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
      VALUES
      (v_group.node_id, p_user, 'G', v_group.display_name, '',
       '', v_group.parent_node_id, v_status, '', '', '', NULL);

Line: 999


       SELECT TO_CHAR(agv.display_order, '0000')||'.'||agv.group_id node_id,
              agv.display_name,
              DECODE(agv.hierarchy_parent_id, '', '',
                   TO_CHAR(ag.display_order, '0000')||'.'||
              agv.hierarchy_parent_id) parent_node_id,
              agv.hierarchy_parent_id h_parent_id
       FROM   az_groups_v agv,
              az_groups ag
       WHERE  agv.group_id = p_group_id
       AND    agv.process_type = g_current_mode
       AND    ag.process_type = g_current_mode
       AND    agv.hierarchy_parent_id = ag.group_id
       UNION
       SELECT TO_CHAR(agv.display_order, '0000')||'.'||agv.group_id node_id,
              agv.display_name,
              NULL,
              NULL
       FROM   az_groups_v agv
       WHERE  agv.group_id = p_group_id
       AND    agv.process_type = g_current_mode
       AND    agv.hierarchy_parent_id IS NULL;

Line: 1030


    SELECT COUNT(*)
    INTO   v_exist_cnt
    FROM   az_planning_reports apr
    WHERE  apr.node_id = v_group.node_id
    AND    apr.phase = p_phase;

Line: 1038


      INSERT INTO az_planning_reports
       (NODE_ID, PHASE, NODE_TYPE, DISPLAY_NAME,
        CONTEXT_TYPE_NAME,PARENT_NODE_ID, DESCRIPTION)
      VALUES
      (v_group.node_id, p_phase, 'G', v_group.display_name, '',
       v_group.parent_node_id, NULL);

Line: 1079


      SELECT DISTINCT TO_CHAR(apf.display_order, '0000')||'.'||apf.item_type
               ||'.'||apf.process_name node_id,
             wav.display_name display_name,
             TO_CHAR(ag.display_order, '0000')||'.'||apf.parent_id
               parent_node_id,
               meaning context_type_name,
             wav.description
      FROM   az_product_flows apf,
     	     az_groups ag,
             wf_activities_vl wav,
             fnd_lookups fnd
      WHERE  apf.application_id = p_application_id
      AND    apf.process_type = 'IMP'
      AND    wav.end_date IS NULL
      AND    wav.item_type like 'AZ%'
      AND    wav.name like 'AZ%'
      AND    apf.item_type = wav.item_type
      AND    apf.process_name = wav.name
      AND    ag.process_type = apf.process_type
      AND    apf.parent_id = ag.group_id
      AND    fnd.lookup_type = 'AZ_CONTEXT_TYPE'
      AND    fnd.lookup_code = apf.context_type;

Line: 1103


      SELECT DISTINCT apf.parent_id
      FROM   az_product_flows apf
      WHERE  apf.application_id = p_application_id;

Line: 1116


      SELECT COUNT(*)
      INTO   v_exist_cnt
      FROM   az_planning_reports apr
      WHERE  apr.node_id = one_process.node_id
      AND    apr.phase = -1;

Line: 1123


        INSERT INTO az_planning_reports
       (NODE_ID, PHASE, NODE_TYPE, DISPLAY_NAME,
        CONTEXT_TYPE_NAME,PARENT_NODE_ID, DESCRIPTION)
      VALUES
        (one_process.node_id, -1, 'P', one_process.display_name,
         one_process.context_type_name, one_process.parent_node_id, one_process.description);

Line: 1197


      SELECT DISTINCT apv.parent_id
      FROM   az_processes apv
      WHERE  apv.status_code = p_status
      AND    apv.process_type = g_current_mode;

Line: 1204


      SELECT DISTINCT apv.parent_id
      FROM   az_processes apv
      WHERE  (apv.status_code = 'N'
      OR     apv.status_code = 'A')
      AND    apv.process_type = g_current_mode;

Line: 1213


      SELECT DISTINCT apv.parent_id
      FROM   az_processes apv
      WHERE  apv.process_type = g_current_mode;

Line: 1263


      SELECT DISTINCT TO_CHAR(apv.display_order, '0000')||'.'||apv.item_type
               ||'.'||apv.process_name||'.'||apv.context_id node_id,
             apv.display_name,
             TO_CHAR(ag.display_order, '0000')||'.'||apv.parent_id
               parent_node_id,
             apv.status,
             apv.context_type_name,
             apv.context_name,
             apv.comments
      FROM   az_processes_all_v apv,
     	     az_groups ag
      WHERE  apv.status = p_status
      AND    apv.process_type = g_current_mode
      AND    ag.process_type = g_current_mode
      AND    apv.parent_id = ag.group_id;

Line: 1281


      SELECT DISTINCT TO_CHAR(apv.display_order, '0000')||'.'||apv.item_type
               ||'.'||apv.process_name||'.'||apv.context_id node_id,
             apv.display_name,
             TO_CHAR(ag.display_order, '0000')||'.'||apv.parent_id
               parent_node_id,
             apv.status,
             apv.context_type_name,
             apv.context_name,
             apv.comments
      FROM   az_processes_all_v apv,
     	     az_groups ag
      WHERE  (apv.status = 'N' OR apv.status = 'A')
      AND    apv.process_type = g_current_mode
      AND    ag.process_type = g_current_mode
      AND    apv.parent_id = ag.group_id;

Line: 1299


      SELECT DISTINCT TO_CHAR(apv.display_order, '0000')||'.'||apv.item_type
               ||'.'||apv.process_name||'.'||apv.context_id node_id,
             apv.display_name,
             TO_CHAR(ag.display_order, '0000')||'.'||apv.parent_id
               parent_node_id,
             apv.status,
             apv.context_type_name,
             apv.context_name,
             apv.comments
      FROM   az_processes_all_v apv,
     	     az_groups ag
      WHERE  apv.process_type = g_current_mode
      AND    ag.process_type = g_current_mode
      AND apv.parent_id = ag.group_id;

Line: 1323


      INSERT INTO az_monitor_reports
       (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
         CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
          STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
      VALUES
        (one_proc.node_id, ' ', 'P', one_proc.display_name,
         one_proc.context_type_name, one_proc.context_name,
         one_proc.parent_node_id, v_status, '', '', '',one_proc.comments);

Line: 1337


      INSERT INTO az_monitor_reports
       (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
         CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
          STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
      VALUES
        (one_proc.node_id, ' ', 'P', one_proc.display_name,
         one_proc.context_type_name, one_proc.context_name,
         one_proc.parent_node_id, v_status, '', '', '', one_proc.comments);

Line: 1351


      INSERT INTO az_monitor_reports
       (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
         CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
          STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
      VALUES
        (one_proc.node_id, ' ', 'P', one_proc.display_name,
         one_proc.context_type_name, one_proc.context_name,
         one_proc.parent_node_id, v_status, '', '', '', one_proc.comments);

Line: 1386


      SELECT atv.item_type||'.'||atv.root_activity||'.'||atv.context_id||'.'||
               TO_CHAR(TO_NUMBER(atv.item_key), '00000') node_id,
             apv.context_type_name,
             atv.context_name,
             TO_CHAR(apv.display_order, '0000')||'.'||apv.item_type||'.'||
               apv.process_name||'.'||apv.context_id parent_node_id,
             atv.status,
             atv.assigned_user,
             atv.begin_date,
             atv.end_date,
             atv.duration
      FROM   az_tasks_v atv,
             az_processes_all_v apv
      WHERE  apv.status = p_status
      AND    atv.item_type = apv.item_type
      AND    atv.root_activity = apv.process_name
      AND    apv.process_type = g_current_mode
      AND    atv.context_id = apv.context_id;

Line: 1408


      SELECT atv.item_type||'.'||atv.root_activity||'.'||atv.context_id||'.'||
               TO_CHAR(TO_NUMBER(atv.item_key), '00000') node_id,
             apv.context_type_name,
             atv.context_name,
             TO_CHAR(apv.display_order, '0000')||'.'||apv.item_type||'.'||
               apv.process_name||'.'||apv.context_id parent_node_id,
             atv.status,
             atv.assigned_user,
             atv.begin_date,
             atv.end_date,
             atv.duration
      FROM   az_tasks_v atv,
             az_processes_all_v apv
      WHERE  (apv.status = 'N'
      OR     apv.status = 'A')
      AND    atv.item_type = apv.item_type
      AND    atv.root_activity = apv.process_name
      AND    apv.process_type = g_current_mode
      AND    atv.context_id = apv.context_id;

Line: 1431


      SELECT atv.item_type||'.'||atv.root_activity||'.'||atv.context_id||'.'||
               TO_CHAR(TO_NUMBER(atv.item_key), '00000') node_id,
             apv.context_type_name,
             atv.context_name,
             TO_CHAR(apv.display_order, '0000')||'.'||apv.item_type||'.'||
               apv.process_name||'.'||apv.context_id parent_node_id,
             atv.status,
             atv.assigned_user,
             atv.begin_date,
             atv.end_date,
             atv.duration
      FROM   az_tasks_v atv,
             az_processes_all_v apv
      WHERE  atv.item_type = apv.item_type
      AND    atv.root_activity = apv.process_name
      AND    apv.process_type = g_current_mode
      AND    atv.context_id = apv.context_id;

Line: 1460


      INSERT INTO az_monitor_reports
       (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
         CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
          STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
      VALUES
        (one_task.node_id, one_task.assigned_user, 'T', '',
         one_task.context_type_name, one_task.context_name,
         one_task.parent_node_id, v_status, one_task.begin_date,
         one_task.end_date, one_task.duration, NULL);

Line: 1475


      INSERT INTO az_monitor_reports
       (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
         CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
          STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
      VALUES
        (one_task.node_id, one_task.assigned_user, 'T', '',
         one_task.context_type_name, one_task.context_name,
         one_task.parent_node_id, v_status, one_task.begin_date,
         one_task.end_date, one_task.duration,NULL);

Line: 1489


      INSERT INTO az_monitor_reports
       (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
         CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
          STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
      VALUES
        (one_task.node_id, one_task.assigned_user, 'T', '',
         one_task.context_type_name, one_task.context_name,
         one_task.parent_node_id, v_status, one_task.begin_date,
         one_task.end_date, one_task.duration,NULL);

Line: 1543


    g_selected    := FND_MESSAGE.get_string('AZ', 'AZW_RPT_PRDSLCT');

Line: 1589


    SELECT meaning
    INTO   g_mode_label
    FROM   fnd_lookups
    WHERE  lookup_type = 'AZ_PROCESS_TYPE'
    AND    lookup_code = g_current_mode;

Line: 1596


    g_no_prod_sel := FND_MESSAGE.get_string('AZ', 'AZW_RPT_NO_PROD_SELECTED');

Line: 1631


   * Populate the hierarchies based on the selected criteria into the
   * intermediate table.  Performs the following steps:
   *   1. If no status is chosen, get tasks, processes, and groups for both
   *      Active and Completed statuses based on the 'at least' duration search
   *      criterion into the intermediate table.
   *   2. Otherwise, get tasks, processes, and groups for the particular status
   *      based on the 'at least' duration search criterion into
   *      the intermediate table.
   *-----------------------------------------------------------------------*/
  PROCEDURE get_user_trees_by_atleast(p_user       IN VARCHAR2,
                                      p_status     IN VARCHAR2,
                                      p_duration   IN NUMBER)
                                      IS

                      /* cursors for at least case with one status (A or C) */

    CURSOR atleast_tasks_cursor IS
      SELECT atv.item_type||'.'||atv.root_activity||'.'||atv.context_id||'.'||
               TO_CHAR(TO_NUMBER(atv.item_key), '00000') node_id,
             apv.context_type_name,
             atv.context_name,
             TO_CHAR(apv.display_order, '0000')||'.'||apv.item_type||'.'||
               apv.process_name||'.'||apv.context_id parent_node_id,
             atv.status,
             atv.assigned_user,
             atv.begin_date,
             atv.end_date,
             atv.duration
      FROM   az_tasks_v atv,
             az_processes_all_v apv
      WHERE  atv.assigned_user = p_user
      AND    atv.status = p_status
      AND    atv.duration >= p_duration
      AND    atv.item_type = apv.item_type
      AND    atv.root_activity = apv.process_name
      AND    atv.context_id = apv.context_id
      AND    apv.process_type = g_current_mode;

Line: 1670


      SELECT DISTINCT TO_CHAR(apv.display_order, '0000')||'.'||apv.item_type
               ||'.'||apv.process_name||'.'||apv.context_id node_id,
             apv.display_name,
             apv.context_type_name,
             apv.context_name,
             TO_CHAR(ag.display_order, '0000')||'.'||apv.parent_id
               parent_node_id,
             apv.status,
             apv.comments
      FROM   az_processes_all_v apv,
     	     az_groups ag
      WHERE  apv.parent_id = ag.group_id
      AND    apv.process_type = g_current_mode
      AND    ag.process_type = g_current_mode
      AND    EXISTS(
             SELECT 1
             FROM   az_tasks_v atv
             WHERE apv.context_id = atv.context_id
             AND   apv.item_type = atv.item_type
             AND   apv.process_name = atv.root_activity
	     AND   atv.assigned_user = p_user
	     AND   atv.status = p_status
	     AND   atv.duration >= p_duration);

Line: 1695


      SELECT DISTINCT apv.parent_id
      FROM   az_processes_all_v apv
      WHERE  EXISTS(
             SELECT 1
             FROM   az_tasks_v atv
             WHERE apv.item_type = atv.item_type
	     AND   apv.process_name = atv.root_activity
	     AND   apv.context_id = atv.context_id
	     AND   atv.status = p_status
	     AND   atv.assigned_user = p_user
	     AND   atv.duration >= p_duration
	     AND   apv.process_type = g_current_mode);

Line: 1711


      SELECT atv.item_type||'.'||atv.root_activity||'.'||atv.context_id||'.'||
               TO_CHAR(TO_NUMBER(atv.item_key), '00000') node_id,
             apv.context_type_name,
             atv.context_name,
             TO_CHAR(apv.display_order, '0000')||'.'||apv.item_type||'.'||
               apv.process_name||'.'||apv.context_id parent_node_id,
             atv.status,
             atv.assigned_user,
             atv.begin_date,
             atv.end_date,
             atv.duration
      FROM az_tasks_v atv,
           az_processes_all_v apv
      WHERE atv.assigned_user = p_user
      AND   atv.duration >= p_duration
      AND   atv.item_type = apv.item_type
      AND   atv.root_activity = apv.process_name
      AND   atv.context_id = apv.context_id
      AND    apv.process_type = g_current_mode;

Line: 1732


      SELECT DISTINCT TO_CHAR(apv.display_order, '0000')||'.'||apv.item_type
               ||'.'||apv.process_name||'.'||apv.context_id node_id,
             apv.display_name,
             apv.context_type_name,
             apv.context_name,
             TO_CHAR(ag.display_order, '0000')||'.'||apv.parent_id
               parent_node_id,
             apv.status,
             apv.comments
      FROM   az_processes_all_v apv,
     	     az_groups ag
      WHERE  apv.parent_id = ag.group_id
      AND    apv.process_type = g_current_mode
      AND    ag.process_type = g_current_mode
      AND    EXISTS(
             SELECT 1
             FROM   az_tasks_v atv
             WHERE  apv.item_type = atv.item_type
	     AND    apv.process_name = atv.root_activity
	     AND    apv.context_id = atv.context_id
	     AND    atv.assigned_user = p_user
	     AND    atv.duration >= p_duration);

Line: 1756


     SELECT DISTINCT apv.parent_id
      FROM   az_processes_all_v apv
      WHERE  EXISTS(
             SELECT 1
             FROM   az_tasks_v atv
             WHERE apv.item_type = atv.item_type
             AND   apv.process_name = atv.root_activity
             AND   apv.context_id = atv.context_id
             AND   atv.assigned_user = p_user
             AND   atv.duration >= p_duration
             AND   apv.process_type = g_current_mode);

Line: 1777


      INSERT INTO az_monitor_reports
       (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
         CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
          STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
      VALUES
        (one_task.node_id, p_user, 'T', '',
         one_task.context_type_name, one_task.context_name,
         one_task.parent_node_id, v_status, one_task.begin_date,
         one_task.end_date, one_task.duration, NULL);

Line: 1791


      INSERT INTO az_monitor_reports
       (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
         CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
          STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
      VALUES
        (one_proc.node_id, p_user, 'P', one_proc.display_name,
         one_proc.context_type_name, one_proc.context_name,
         one_proc.parent_node_id, v_status, '', '', '', one_proc.comments);

Line: 1811


      INSERT INTO az_monitor_reports
       (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
         CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
          STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
      VALUES
        (one_task.node_id, p_user, 'T', '',
         one_task.context_type_name, one_task.context_name,
         one_task.parent_node_id, v_status, one_task.begin_date,
         one_task.end_date, one_task.duration,NULL);

Line: 1825


      INSERT INTO az_monitor_reports
       (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
         CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
          STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
      VALUES
        (one_proc.node_id, p_user, 'P', one_proc.display_name,
         one_proc.context_type_name, one_proc.context_name,
         one_proc.parent_node_id, v_status, '', '', '', one_proc.comments);

Line: 1853


   * Populate the hierarchies based on the selected criteria into the
   * intermediate table.  Performs the following steps:
   *   1. If no status is chosen, get tasks, processes, and groups for both
   *      Active and Completed statuses based on the 'at most' duration search
   *      criterion into the intermediate table.
   *   2. Otherwise, get tasks, processes, and groups for the particular status
   *      based on the 'at most' duration search criterion into
   *      the intermediate table.
   *-----------------------------------------------------------------------*/
  PROCEDURE get_user_trees_by_atmost(p_user       IN VARCHAR2,
                                     p_status     IN VARCHAR2,
                                     p_duration   IN NUMBER)
                                     IS

                       /* cursors for at most case with one status (A or C) */

    CURSOR atmost_tasks_cursor IS
      SELECT atv.item_type||'.'||atv.root_activity||'.'||atv.context_id||'.'||
               TO_CHAR(TO_NUMBER(atv.item_key), '00000') node_id,
             apv.context_type_name,
             atv.context_name,
             TO_CHAR(apv.display_order, '0000')||'.'||apv.item_type||'.'||
               apv.process_name||'.'||apv.context_id parent_node_id,
             atv.status,
             atv.assigned_user,
             atv.begin_date,
             atv.end_date,
             atv.duration
      FROM   az_tasks_v atv,
             az_processes_all_v apv
      WHERE  atv.assigned_user = p_user
      AND    atv.status = p_status
      AND    atv.duration <= p_duration
      AND    atv.item_type = apv.item_type
      AND    atv.root_activity = apv.process_name
      AND    atv.context_id = apv.context_id
      AND    apv.process_type = g_current_mode;

Line: 1892


      SELECT DISTINCT TO_CHAR(apv.display_order, '0000')||'.'||apv.item_type
               ||'.'||apv.process_name||'.'||apv.context_id node_id,
             apv.display_name,
             apv.context_type_name,
             apv.context_name,
             TO_CHAR(ag.display_order, '0000')||'.'||apv.parent_id
               parent_node_id,
             apv.status,
             apv.comments
      FROM   az_processes_all_v apv,
     	     az_groups ag
      WHERE  apv.parent_id = ag.group_id
      AND    apv.process_type = g_current_mode
      AND    ag.process_type = apv.process_type
      AND    EXISTS(
             SELECT 1
             FROM   az_tasks_v atv
             WHERE  apv.item_type = atv.item_type
	     AND    apv.process_name = atv.root_activity
	     AND    apv.context_id = atv.context_id
	     AND    atv.assigned_user = p_user
	     AND    atv.status = p_status
	     AND    atv.duration <= p_duration);

Line: 1917


      SELECT DISTINCT apv.parent_id
      FROM   az_processes_all_v apv
      WHERE  EXISTS(
             SELECT 1
             FROM   az_tasks_v atv
             WHERE  apv.item_type = atv.item_type
	     AND    apv.process_name = atv.root_activity
	     AND    apv.context_id = atv.context_id
	     AND    atv.status = p_status
	     AND    atv.assigned_user = p_user
	     AND    atv.duration <= p_duration
	     AND    apv.process_type = g_current_mode);

Line: 1933


      SELECT atv.item_type||'.'||atv.root_activity||'.'||atv.context_id||'.'||
               TO_CHAR(TO_NUMBER(atv.item_key), '00000') node_id,
             apv.context_type_name,
             atv.context_name,
             TO_CHAR(apv.display_order, '0000')||'.'||apv.item_type||'.'||
               apv.process_name||'.'||apv.context_id parent_node_id,
             atv.status,
             atv.assigned_user,
             atv.begin_date,
             atv.end_date,
             atv.duration
      FROM   az_tasks_v atv,
             az_processes_all_v apv
      WHERE  atv.assigned_user = p_user
      AND    atv.duration <= p_duration
      AND    atv.item_type = apv.item_type
      AND    atv.root_activity = apv.process_name
      AND    atv.context_id = apv.context_id
      AND    apv.process_type = g_current_mode;

Line: 1954


      SELECT DISTINCT TO_CHAR(apv.display_order, '0000')||'.'||apv.item_type
               ||'.'||apv.process_name||'.'||apv.context_id node_id,
             apv.display_name,
             apv.context_type_name,
             apv.context_name,
             TO_CHAR(ag.display_order, '0000')||'.'||apv.parent_id
               parent_node_id,
             apv.status,
             apv.comments
      FROM   az_processes_all_v apv,
     	     az_groups ag
      WHERE  apv.parent_id = ag.group_id
      AND    apv.process_type = g_current_mode
      AND    ag.process_type = apv.process_type
      AND    EXISTS(
             SELECT 1
             FROM   az_tasks_v atv
             WHERE  apv.item_type = atv.item_type
	     AND    apv.process_name = atv.root_activity
	     AND    apv.context_id = atv.context_id
	     AND    atv.assigned_user = p_user
	     AND    atv.duration <= p_duration);

Line: 1978


      SELECT DISTINCT apv.parent_id
      FROM   az_processes_all_v apv
      WHERE  EXISTS(
             SELECT 1
             FROM   az_tasks_v atv
             WHERE  apv.item_type = atv.item_type
	     AND    apv.process_name = atv.root_activity
	     AND    apv.context_id = atv.context_id
	     AND    atv.assigned_user = p_user
	     AND    atv.duration <= p_duration
	     AND    apv.process_type = g_current_mode);

Line: 1999


      INSERT INTO az_monitor_reports
       (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
         CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
          STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
      VALUES
         (one_task.node_id, p_user, 'T', '',
         one_task.context_type_name, one_task.context_name,
         one_task.parent_node_id, v_status, one_task.begin_date,
         one_task.end_date, one_task.duration,NULL);

Line: 2013


      INSERT INTO az_monitor_reports
       (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
         CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
          STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
      VALUES
        (one_proc.node_id, p_user, 'P', one_proc.display_name,
         one_proc.context_type_name, one_proc.context_name,
         one_proc.parent_node_id, v_status, '', '', '', one_proc.comments);

Line: 2033


      INSERT INTO az_monitor_reports
       (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
         CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
          STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
      VALUES
        (one_task.node_id, p_user, 'T', '',
         one_task.context_type_name, one_task.context_name,
         one_task.parent_node_id, v_status, one_task.begin_date,
         one_task.end_date, one_task.duration,NULL);

Line: 2047


      INSERT INTO az_monitor_reports
       (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
         CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
          STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
      VALUES
        (one_proc.node_id, p_user, 'P', one_proc.display_name,
         one_proc.context_type_name, one_proc.context_name,
         one_proc.parent_node_id, v_status, '', '', '',one_proc.comments);

Line: 2075


   * Populate the hierarchies based on the selected criteria into the
   * intermediate table.  Performs the following steps:
   *   1. If no status is chosen, get tasks, processes, and groups for both
   *      Active and Completed statuses based on the start and end period into
   *      the intermediate table.
   *   2. Otherwise, get tasks, processes, and groups for the particular status
   *      based on the start and end period into the intermediate table.
   *-----------------------------------------------------------------------*/
  PROCEDURE get_user_trees_by_period(p_user       IN VARCHAR2,
                                     p_status     IN VARCHAR2,
                                     p_startdate  IN DATE,
                                     p_enddate    IN DATE)
                                     IS

                         /* cursors for period case with one status (A or C) */

    CURSOR period_tasks_cursor IS
      SELECT atv.item_type||'.'||atv.root_activity||'.'||atv.context_id||'.'||
               TO_CHAR(TO_NUMBER(atv.item_key), '00000') node_id,
             apv.context_type_name,
             atv.context_name,
             TO_CHAR(apv.display_order, '0000')||'.'||apv.item_type||'.'||
               apv.process_name||'.'||apv.context_id parent_node_id,
             atv.status,
             atv.begin_date,
             atv.end_date,
             atv.duration
      FROM   az_tasks_v atv,
             az_processes_all_v apv
      WHERE  atv.assigned_user = p_user
      AND    atv.status = p_status
      AND    ((atv.begin_date >= p_startdate AND atv.begin_date <= p_enddate)
      OR      (atv.end_date >= p_startdate AND atv.end_date <= p_enddate)
      OR      (atv.begin_date <= p_startdate AND
              (atv.end_date >= p_enddate OR atv.end_date IS NULL)))
      AND    atv.item_type = apv.item_type
      AND    atv.root_activity = apv.process_name
      AND    atv.context_id = apv.context_id
      AND    apv.process_type = g_current_mode;

Line: 2116


      SELECT DISTINCT TO_CHAR(apv.display_order, '0000')||'.'||apv.item_type
               ||'.'||apv.process_name||'.'||apv.context_id node_id,
             apv.display_name,
             apv.context_type_name,
             apv.context_name,
             TO_CHAR(ag.display_order, '0000')||'.'||apv.parent_id
               parent_node_id,
             apv.status,
             apv.comments
      FROM   az_processes_all_v apv,
     	     az_groups ag
      WHERE  apv.parent_id = ag.group_id
      AND    apv.process_type = g_current_mode
      AND    ag.process_type = apv.process_type
      AND    EXISTS(
             SELECT 1
             FROM   az_tasks_v atv
             WHERE  apv.item_type = atv.item_type
	     AND    apv.process_name = atv.root_activity
	     AND    apv.context_id = atv.context_id
	     AND    atv.assigned_user = p_user
	     AND    atv.status = p_status
	     AND    ((atv.begin_date >= p_startdate AND atv.begin_date <= p_enddate)
	     OR      (atv.end_date >= p_startdate AND atv.end_date <= p_enddate)
	     OR      (atv.begin_date <= p_startdate AND
                     (atv.end_date >= p_enddate OR atv.end_date IS NULL))));

Line: 2144


      SELECT DISTINCT apv.parent_id
      FROM   az_processes_all_v apv
      WHERE  EXISTS(
             SELECT 1
             FROM   az_tasks_v atv
             WHERE  apv.item_type = atv.item_type
	     AND    apv.process_name = atv.root_activity
	     AND    apv.context_id = atv.context_id
	     AND    atv.status = p_status
	     AND    atv.assigned_user = p_user
	     AND    ((atv.begin_date >= p_startdate AND atv.begin_date <= p_enddate)
	     OR      (atv.end_date >= p_startdate AND atv.end_date <= p_enddate)
	     OR      (atv.begin_date <= p_startdate AND
                     (atv.end_date >= p_enddate OR atv.end_date IS NULL)))
	     AND    apv.process_type = g_current_mode);

Line: 2163


      SELECT atv.item_type||'.'||atv.root_activity||'.'||atv.context_id||'.'||
               TO_CHAR(TO_NUMBER(atv.item_key), '00000') node_id,
             apv.context_type_name,
             atv.context_name,
             TO_CHAR(apv.display_order, '0000')||'.'||apv.item_type||'.'||
               apv.process_name||'.'||apv.context_id parent_node_id,
             atv.status,
             atv.begin_date,
             atv.end_date,
             atv.duration
      FROM   az_tasks_v atv,
             az_processes_all_v apv
      WHERE  atv.assigned_user = p_user
      AND    ((atv.begin_date >= p_startdate AND atv.begin_date <= p_enddate)
      OR      (atv.end_date >= p_startdate AND atv.end_date <= p_enddate)
      OR      (atv.begin_date <= p_startdate AND
              (atv.end_date >= p_enddate OR atv.end_date IS NULL)))
      AND    atv.item_type = apv.item_type
      AND    atv.root_activity = apv.process_name
      AND    atv.context_id = apv.context_id
      AND    apv.process_type = g_current_mode;

Line: 2186


      SELECT DISTINCT TO_CHAR(apv.display_order, '0000')||'.'||apv.item_type
               ||'.'||apv.process_name||'.'||apv.context_id node_id,
             apv.display_name,
             apv.context_type_name,
             apv.context_name,
             TO_CHAR(ag.display_order, '0000')||'.'||apv.parent_id
               parent_node_id,
             apv.status,
             apv.comments
      FROM   az_processes_all_v apv,
     	     az_groups ag
      WHERE  apv.parent_id = ag.group_id
      AND    apv.process_type = g_current_mode
      AND    ag.process_type = apv.process_type
      AND    EXISTS(
             SELECT 1
             FROM   az_tasks_v atv
             WHERE  apv.item_type = atv.item_type
	     AND    apv.process_name = atv.root_activity
	     AND    apv.context_id = atv.context_id
	     AND    atv.assigned_user = p_user
	     AND    ((atv.begin_date >= p_startdate AND atv.begin_date <= p_enddate)
	     OR      (atv.end_date >= p_startdate AND atv.end_date <= p_enddate)
	     OR      (atv.begin_date <= p_startdate AND
                     (atv.end_date >= p_enddate OR atv.end_date IS NULL))));

Line: 2213


      SELECT DISTINCT apv.parent_id
      FROM   az_processes_all_v apv
      WHERE  EXISTS(
             SELECT 1
             FROM   az_tasks_v atv
             WHERE  apv.item_type = atv.item_type
	     AND    apv.process_name = atv.root_activity
	     AND    apv.context_id = atv.context_id
	     AND    atv.assigned_user = p_user
	     AND    ((atv.begin_date >= p_startdate AND atv.begin_date <= p_enddate)
	     OR      (atv.end_date >= p_startdate AND atv.end_date <= p_enddate)
	     OR      (atv.begin_date <= p_startdate AND
                      (atv.end_date >= p_enddate OR atv.end_date IS NULL)))
	     AND    apv.process_type = g_current_mode);

Line: 2241


      INSERT INTO az_monitor_reports
       (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
         CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
          STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
      VALUES
        (one_task.node_id, p_user, 'T', '',
         one_task.context_type_name, one_task.context_name,
         one_task.parent_node_id, v_status, one_task.begin_date,
         one_task.end_date, one_task.duration,NULL);

Line: 2255


      INSERT INTO az_monitor_reports
       (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
         CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
          STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
      VALUES
        (one_proc.node_id, p_user, 'P', one_proc.display_name,
         one_proc.context_type_name, one_proc.context_name,
         one_proc.parent_node_id, v_status, '', '', '', one_proc.comments);

Line: 2275


      INSERT INTO az_monitor_reports
       (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
         CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
          STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
      VALUES
        (one_task.node_id, p_user, 'T', '',
         one_task.context_type_name, one_task.context_name,
         one_task.parent_node_id, v_status, one_task.begin_date,
         one_task.end_date, one_task.duration, NULL);

Line: 2289


      INSERT INTO az_monitor_reports
       (NODE_ID, ASSIGNED_USER, NODE_TYPE, DISPLAY_NAME,
         CONTEXT_TYPE_NAME, CONTEXT_NAME, PARENT_NODE_ID,
          STATUS_CODE_NAME, START_DATE, END_DATE, DURATION, COMMENTS)
      VALUES
        (one_proc.node_id, p_user, 'P', one_proc.display_name,
         one_proc.context_type_name, one_proc.context_name,
         one_proc.parent_node_id, v_status, '', '', '', one_proc.comments);

Line: 2389


   *      implementation report and passes the user selected phase; Cancel

Line: 2395


      SELECT   DISTINCT phase
      FROM     az_product_phases_v
      ORDER BY phase;

Line: 2419


    htp.p('');

Line: 2447


   *   4. Print Table opening tag and header based on selected phase.
   *   4. If the parameter is null, get all valid phases, and
   *      a. for each phase, get the processes into the intermediate table.
   *      b. for each phase, retrieve the trees from the intermediate table.
   *         for each row retrieved, print the Table Row and Table Data.
   *   5. If the parameter is not null, get the processes for the specified
   *      phase into the intermediate table, and retrieve the trees from the
   *      intermediate table. For each row retrieved, print the Table Row and
   *      Table Data.
   *   6. Print HTML Table closing tag.
   *   7. Print links to related reports.
   *-----------------------------------------------------------------------*/
  PROCEDURE implementation_report(p_phase IN VARCHAR2) IS
    v_phase      NUMBER;

Line: 2463


      SELECT   DISTINCT phase
      FROM     az_product_phases_v
      ORDER BY phase;

Line: 2468


      SELECT     phase,
                 LPAD(g_blank, g_indent*(LEVEL-1))||display_name hierarchy,
                 node_type,
                 description,
                 node_id,
                 parent_node_id,
                 LEVEL
      FROM       az_planning_reports
      WHERE 	 phase = x_phase
      START WITH parent_node_id IS NULL
      CONNECT BY PRIOR node_id = parent_node_id
      AND	 PRIOR phase = phase;

Line: 2493


    print_time_stamp('Start Insert into temp table');

Line: 2502


    print_time_stamp('End Insert into temp table');

Line: 2893


**	the report and the selected phase parameter at the left.
**
*/
PROCEDURE print_ipr_report_parameters (p_phase IN VARCHAR2) IS

BEGIN
  htp.p('');
Line: 2947

     	SELECT DISTINCT appv.phase,
	    		appv.application_short_name short_name,
		       	appv.application_name name
	FROM      az_product_phases_v appv
      	ORDER BY 1, 3;
Line: 2954

	SELECT DISTINCT appv.phase,
	    		appv.application_short_name short_name,
		       	appv.application_name name
	FROM      az_product_phases_v appv
      	WHERE    appv.phase = x_phase
      	ORDER BY 1, 3;
Line: 3146

**	This procedure is responsible for selecting the available Process Groups,
**	counts the number of processes available for each and  populates the
**	passed array with the data to be used by the calling function
**	(print_planning_reports_summary).
**
*/
PROCEDURE populate_process_groups_array (
				p_phase IN NUMBER,
				process_groups IN OUT NOCOPY PlanProcessGroups) IS

  CURSOR all_phases IS
	SELECT  phase,
		display_name,
		node_type,
		parent_node_id,
		node_id
	FROM       az_planning_reports
	START WITH parent_node_id IS NULL
	CONNECT BY PRIOR node_id = parent_node_id
	AND	 PRIOR phase = phase;
Line: 3168

	SELECT  phase,
		display_name,
		node_type,
		parent_node_id,
		node_id
	FROM	az_planning_reports
	WHERE 	phase = x_phase
	START WITH parent_node_id IS NULL
	CONNECT BY PRIOR node_id = parent_node_id
	AND	 PRIOR phase = phase;
Line: 3410

   * of products that have been selected by the user.
   *-----------------------------------------------------------------------*/
  PROCEDURE print_pp_jscripts IS

  BEGIN
   htp.p('