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.

[Home] [Help]

APPS.AZW_HIER dependencies on AZ_GROUPS

Line 70: FROM az_groups

66: BEGIN
67:
68: SELECT COUNT(*)
69: INTO v_cnt
70: FROM az_groups
71: WHERE hierarchy_parent_id = p_group_id
72: AND process_type = g_current_mode;
73:
74: IF (v_cnt > 0) THEN

Line 91: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_groups');

87: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
88: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
89: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
90: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.group_hierarchy_tree_not_found');
91: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_groups');
92: APP_EXCEPTION.RAISE_EXCEPTION;
93: END group_hierarchy_tree_not_found;
94:
95:

Line 105: v_group_id az_groups.group_id%TYPE DEFAULT NULL;

101: --
102:
103: PROCEDURE get_leaf_nodes(p_process_group IN VARCHAR2) IS
104:
105: v_group_id az_groups.group_id%TYPE DEFAULT NULL;
106:
107: CURSOR leaf_node_cursor IS
108: SELECT group_id
109: FROM az_groups

Line 109: FROM az_groups

105: v_group_id az_groups.group_id%TYPE DEFAULT NULL;
106:
107: CURSOR leaf_node_cursor IS
108: SELECT group_id
109: FROM az_groups
110: WHERE hierarchy_parent_id is not null
111: START WITH group_id = p_process_group
112: AND process_type = g_current_mode
113: CONNECT BY PRIOR group_id = hierarchy_parent_id

Line 426: v_node_id az_groups.group_id%TYPE;

422: p_sort_by VARCHAR2(40);
423:
424: /*
425: Reduced the size of the following ... in the data base they are 240
426: v_node_id az_groups.group_id%TYPE;
427: v_hierarchy_parent_id az_groups.hierarchy_parent_id%TYPE;
428: */
429: v_node_id VARCHAR2(60);
430: v_hierarchy_parent_id VARCHAR2(60);

Line 427: v_hierarchy_parent_id az_groups.hierarchy_parent_id%TYPE;

423:
424: /*
425: Reduced the size of the following ... in the data base they are 240
426: v_node_id az_groups.group_id%TYPE;
427: v_hierarchy_parent_id az_groups.hierarchy_parent_id%TYPE;
428: */
429: v_node_id VARCHAR2(60);
430: v_hierarchy_parent_id VARCHAR2(60);
431:

Line 432: v_display_order az_groups.display_order%TYPE;

428: */
429: v_node_id VARCHAR2(60);
430: v_hierarchy_parent_id VARCHAR2(60);
431:
432: v_display_order az_groups.display_order%TYPE;
433: v_lookup_code az_groups.lookup_code%TYPE;
434: v_rollup_flag VARCHAR2(1);
435: v_group_rollup_flag VARCHAR2(1);
436: v_application_id az_groups.application_id%TYPE;

Line 433: v_lookup_code az_groups.lookup_code%TYPE;

429: v_node_id VARCHAR2(60);
430: v_hierarchy_parent_id VARCHAR2(60);
431:
432: v_display_order az_groups.display_order%TYPE;
433: v_lookup_code az_groups.lookup_code%TYPE;
434: v_rollup_flag VARCHAR2(1);
435: v_group_rollup_flag VARCHAR2(1);
436: v_application_id az_groups.application_id%TYPE;
437:

Line 436: v_application_id az_groups.application_id%TYPE;

432: v_display_order az_groups.display_order%TYPE;
433: v_lookup_code az_groups.lookup_code%TYPE;
434: v_rollup_flag VARCHAR2(1);
435: v_group_rollup_flag VARCHAR2(1);
436: v_application_id az_groups.application_id%TYPE;
437:
438: CURSOR group_hierarchy_tree_cursor IS
439: SELECT SUBSTR(group_id, 1, 60),
440: SUBSTR(hierarchy_parent_id, 1, 60),

Line 442: FROM az_groups

438: CURSOR group_hierarchy_tree_cursor IS
439: SELECT SUBSTR(group_id, 1, 60),
440: SUBSTR(hierarchy_parent_id, 1, 60),
441: lookup_code, display_order, application_id
442: FROM az_groups
443: WHERE hierarchy_parent_id = process_group
444: AND process_type = g_current_mode
445: ORDER BY 1;
446:

Line 592: v_node_id az_groups.group_id%TYPE;

588: p_task_total_days_op VARCHAR2(5);
589: p_sort_by VARCHAR2(40);
590: /*
591: Reduced the size of the following to 60 ... in the data base they are 240 ... too large
592: v_node_id az_groups.group_id%TYPE;
593: */
594: v_node_id VARCHAR2(60);
595:
596: v_display_order az_groups.display_order%TYPE;

Line 596: v_display_order az_groups.display_order%TYPE;

592: v_node_id az_groups.group_id%TYPE;
593: */
594: v_node_id VARCHAR2(60);
595:
596: v_display_order az_groups.display_order%TYPE;
597: v_application_id az_groups.application_id%TYPE;
598: v_lookup_code az_groups.lookup_code%TYPE;
599: v_rollup_flag VARCHAR2(1);
600: v_group_rollup_flag VARCHAR2(1);

Line 597: v_application_id az_groups.application_id%TYPE;

593: */
594: v_node_id VARCHAR2(60);
595:
596: v_display_order az_groups.display_order%TYPE;
597: v_application_id az_groups.application_id%TYPE;
598: v_lookup_code az_groups.lookup_code%TYPE;
599: v_rollup_flag VARCHAR2(1);
600: v_group_rollup_flag VARCHAR2(1);
601:

Line 598: v_lookup_code az_groups.lookup_code%TYPE;

594: v_node_id VARCHAR2(60);
595:
596: v_display_order az_groups.display_order%TYPE;
597: v_application_id az_groups.application_id%TYPE;
598: v_lookup_code az_groups.lookup_code%TYPE;
599: v_rollup_flag VARCHAR2(1);
600: v_group_rollup_flag VARCHAR2(1);
601:
602: BEGIN

Line 623: FROM az_groups

619:
620: BEGIN
621: SELECT lookup_code, application_id, display_order
622: INTO v_lookup_code, v_application_id, v_display_order
623: FROM az_groups
624: WHERE group_id = v_node_id
625: AND process_type = g_current_mode;
626:
627: EXCEPTION

Line 635: fnd_message.set_token('AZW_ERROR_STMT','select lookup_code ... from az_groups');

631: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
632: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
633: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
634: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy');
635: fnd_message.set_token('AZW_ERROR_STMT','select lookup_code ... from az_groups');
636: APP_EXCEPTION.RAISE_EXCEPTION;
637: END;
638:
639: IF group_hierarchy_tree_not_found(v_node_id) THEN

Line 875: v_node_id az_groups.group_id%TYPE;

871: PROCEDURE get_all_group_hierarchy
872: IS
873:
874: /*
875: v_node_id az_groups.group_id%TYPE;
876: v_dependency_parent_id az_groups.dependency_parent_id%TYPE;
877: v_hierarchy_parent_id az_groups.hierarchy_parent_id%TYPE;
878: */
879: v_node_id VARCHAR2(60);

Line 876: v_dependency_parent_id az_groups.dependency_parent_id%TYPE;

872: IS
873:
874: /*
875: v_node_id az_groups.group_id%TYPE;
876: v_dependency_parent_id az_groups.dependency_parent_id%TYPE;
877: v_hierarchy_parent_id az_groups.hierarchy_parent_id%TYPE;
878: */
879: v_node_id VARCHAR2(60);
880: v_dependency_parent_id VARCHAR2(60);

Line 877: v_hierarchy_parent_id az_groups.hierarchy_parent_id%TYPE;

873:
874: /*
875: v_node_id az_groups.group_id%TYPE;
876: v_dependency_parent_id az_groups.dependency_parent_id%TYPE;
877: v_hierarchy_parent_id az_groups.hierarchy_parent_id%TYPE;
878: */
879: v_node_id VARCHAR2(60);
880: v_dependency_parent_id VARCHAR2(60);
881: v_hierarchy_parent_id VARCHAR2(60);

Line 883: v_display_order az_groups.display_order%TYPE;

879: v_node_id VARCHAR2(60);
880: v_dependency_parent_id VARCHAR2(60);
881: v_hierarchy_parent_id VARCHAR2(60);
882:
883: v_display_order az_groups.display_order%TYPE;
884: v_application_id az_groups.application_id%TYPE;
885: v_lookup_code az_groups.lookup_code%TYPE;
886:
887: CURSOR root_group_hierarchy_cursor IS

Line 884: v_application_id az_groups.application_id%TYPE;

880: v_dependency_parent_id VARCHAR2(60);
881: v_hierarchy_parent_id VARCHAR2(60);
882:
883: v_display_order az_groups.display_order%TYPE;
884: v_application_id az_groups.application_id%TYPE;
885: v_lookup_code az_groups.lookup_code%TYPE;
886:
887: CURSOR root_group_hierarchy_cursor IS
888: SELECT SUBSTR(group_id, 1, 60),

Line 885: v_lookup_code az_groups.lookup_code%TYPE;

881: v_hierarchy_parent_id VARCHAR2(60);
882:
883: v_display_order az_groups.display_order%TYPE;
884: v_application_id az_groups.application_id%TYPE;
885: v_lookup_code az_groups.lookup_code%TYPE;
886:
887: CURSOR root_group_hierarchy_cursor IS
888: SELECT SUBSTR(group_id, 1, 60),
889: SUBSTR(dependency_parent_id, 1, 60),

Line 891: FROM az_groups

887: CURSOR root_group_hierarchy_cursor IS
888: SELECT SUBSTR(group_id, 1, 60),
889: SUBSTR(dependency_parent_id, 1, 60),
890: display_order, application_id, lookup_code
891: FROM az_groups
892: WHERE hierarchy_parent_id is null
893: AND process_type = g_current_mode
894: ORDER BY 1;
895:

Line 900: FROM az_groups

896: CURSOR group_hierarchy_cursor IS
897: SELECT SUBSTR(group_id, 1, 60),
898: SUBSTR(hierarchy_parent_id, 1, 60),
899: display_order, application_id, lookup_code
900: FROM az_groups
901: WHERE hierarchy_parent_id is not null
902: AND process_type = g_current_mode
903: ORDER BY 1;
904:

Line 1486: p_process_group az_groups.group_id%TYPE;

1482: IS
1483:
1484: msg message_tbl_t;
1485: i BINARY_INTEGER DEFAULT 0;
1486: p_process_group az_groups.group_id%TYPE;
1487: p_process_status VARCHAR2(20);
1488: p_process_phase NUMBER(3);
1489: p_assigned_user VARCHAR2(30);
1490: p_task_status VARCHAR2(10);

Line 1802: v_application_id az_groups.application_id%TYPE;

1798:
1799:
1800: FUNCTION validContextType( ctx_type IN VARCHAR2,p_node_id VARCHAR2) RETURN BOOLEAN IS
1801: v_count PLS_INTEGER := 0;
1802: v_application_id az_groups.application_id%TYPE;
1803:
1804: CURSOR get_subgroup_c IS
1805: select group_id from az_groups
1806: where

Line 1805: select group_id from az_groups

1801: v_count PLS_INTEGER := 0;
1802: v_application_id az_groups.application_id%TYPE;
1803:
1804: CURSOR get_subgroup_c IS
1805: select group_id from az_groups
1806: where
1807: hierarchy_parent_id = p_node_id
1808: and process_type = g_current_mode;
1809: