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_PROC dependencies on AZ_GROUPS

Line 34: g_current_mode az_groups.process_type%TYPE;

30: v_days VARCHAR2(8);
31: v_done VARCHAR2(8);
32: v_skip VARCHAR2(8);
33: v_new_task_key wf_items.item_key%TYPE;
34: g_current_mode az_groups.process_type%TYPE;
35:
36: PROCEDURE update_hierarchy_status(p_item_type IN VARCHAR2,
37: p_process_name IN VARCHAR2,
38: p_context_id IN VARCHAR2);

Line 50: v_parent_gr_id az_groups.group_id%TYPE;

46: --
47:
48: FUNCTION get_parent_group(p_parent_id IN VARCHAR2) RETURN VARCHAR2
49: IS
50: v_parent_gr_id az_groups.group_id%TYPE;
51: BEGIN
52: -- dbms_output.put_line(' getting parent for ' || p_parent_id);
53:
54: SELECT azg1.group_id

Line 56: FROM az_groups azg1, az_groups azg2

52: -- dbms_output.put_line(' getting parent for ' || p_parent_id);
53:
54: SELECT azg1.group_id
55: INTO v_parent_gr_id
56: FROM az_groups azg1, az_groups azg2
57: WHERE azg2.group_id = p_parent_id
58: AND azg1.process_type = azg2.process_type
59: AND azg1.process_type = g_current_mode
60: AND azg1.group_id = azg2.hierarchy_parent_id;

Line 76: fnd_message.set_token('AZW_ERROR_STMT','select group_id from az_groups');

72: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
73: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
74: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
75: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_parent_group');
76: fnd_message.set_token('AZW_ERROR_STMT','select group_id from az_groups');
77: APP_EXCEPTION.RAISE_EXCEPTION;
78: END get_parent_group;
79:
80:

Line 386: p_group_id az_groups.group_id%TYPE;

382: v_process_parent_id az_processes.parent_id%TYPE;
383: v_process_item_type az_processes.item_type%TYPE;
384: v_process_name az_processes.process_name%TYPE;
385: v_process_ctxt_id az_processes.context_id%TYPE;
386: p_group_id az_groups.group_id%TYPE;
387: v_group_color az_groups.color_code%TYPE;
388: p_node_id VARCHAR2(300);
389:
390: BEGIN

Line 387: v_group_color az_groups.color_code%TYPE;

383: v_process_item_type az_processes.item_type%TYPE;
384: v_process_name az_processes.process_name%TYPE;
385: v_process_ctxt_id az_processes.context_id%TYPE;
386: p_group_id az_groups.group_id%TYPE;
387: v_group_color az_groups.color_code%TYPE;
388: p_node_id VARCHAR2(300);
389:
390: BEGIN
391: p_node_id := node_id;

Line 423: FROM az_groups

419:
420: BEGIN
421: SELECT color_code
422: INTO v_group_color
423: FROM az_groups
424: WHERE group_id = v_process_parent_id
425: AND process_type = g_current_mode;
426:
427: RETURN v_group_color;

Line 435: fnd_message.set_token('AZW_ERROR_STMT','select color_code from az_groups');

431: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
432: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
433: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
434: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_group_color');
435: fnd_message.set_token('AZW_ERROR_STMT','select color_code from az_groups');
436: APP_EXCEPTION.RAISE_EXCEPTION;
437: END;
438: EXCEPTION
439: WHEN app_exception.application_exception THEN

Line 1681: v_parent_id az_groups.group_id%TYPE;

1677: -- all ancestors' complete status to 'N'.
1678: --
1679: PROCEDURE update_groups_status(p_group_id IN VARCHAR2) IS
1680:
1681: v_parent_id az_groups.group_id%TYPE;
1682: v_cnt NUMBER DEFAULT 0;
1683: v_total_kids NUMBER DEFAULT 0;
1684:
1685: BEGIN

Line 1689: FROM az_groups ag

1685: BEGIN
1686: BEGIN
1687: SELECT ag.hierarchy_parent_id
1688: INTO v_parent_id
1689: FROM az_groups ag
1690: WHERE ag.group_id = p_group_id
1691: AND ag.process_type = g_current_mode;
1692: EXCEPTION
1693: WHEN NO_DATA_FOUND THEN

Line 1700: fnd_message.set_token('AZW_ERROR_STMT','select hierarchy_parent_id from az_groups');

1696: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1697: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1698: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1699: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1700: fnd_message.set_token('AZW_ERROR_STMT','select hierarchy_parent_id from az_groups');
1701: APP_EXCEPTION.RAISE_EXCEPTION;
1702: END;
1703:
1704: WHILE (v_parent_id IS NOT NULL) LOOP

Line 1709: FROM az_groups ag

1705:
1706: BEGIN
1707: SELECT COUNT(*)
1708: INTO v_total_kids
1709: FROM az_groups ag
1710: WHERE ag.hierarchy_parent_id = v_parent_id
1711: AND ag.process_type = g_current_mode;
1712: EXCEPTION
1713: WHEN OTHERS THEN

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

1714: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1715: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1716: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1717: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1718: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into v_total_kids from az_groups');
1719: APP_EXCEPTION.RAISE_EXCEPTION;
1720: END;
1721:
1722: BEGIN

Line 1725: FROM az_groups ag

1721:
1722: BEGIN
1723: SELECT COUNT(*)
1724: INTO v_cnt
1725: FROM az_groups ag
1726: WHERE ag.hierarchy_parent_id = v_parent_id
1727: AND ag.process_type = g_current_mode
1728: AND ag.complete_flag <> 'Y';
1729: EXCEPTION

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

1731: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1732: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1733: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1734: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1735: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into v_cnt from az_groups');
1736: APP_EXCEPTION.RAISE_EXCEPTION;
1737: END;
1738:
1739: IF (v_total_kids <> 0 AND v_cnt = 0) THEN

Line 1741: UPDATE az_groups

1737: END;
1738:
1739: IF (v_total_kids <> 0 AND v_cnt = 0) THEN
1740: BEGIN
1741: UPDATE az_groups
1742: SET complete_flag = 'Y'
1743: WHERE group_id = v_parent_id
1744: AND process_type = g_current_mode;
1745: COMMIT;

Line 1752: fnd_message.set_token('AZW_ERROR_STMT','update az_groups set complete_flag = Y');

1748: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1749: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1750: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1751: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1752: fnd_message.set_token('AZW_ERROR_STMT','update az_groups set complete_flag = Y');
1753: APP_EXCEPTION.RAISE_EXCEPTION;
1754: END;
1755:
1756: BEGIN

Line 1759: FROM az_groups ag

1755:
1756: BEGIN
1757: SELECT ag.hierarchy_parent_id
1758: INTO v_parent_id
1759: FROM az_groups ag
1760: WHERE ag.group_id = v_parent_id
1761: AND ag.process_type = g_current_mode;
1762: EXCEPTION
1763: WHEN OTHERS THEN

Line 1768: fnd_message.set_token('AZW_ERROR_STMT','select hierarchy_parent_id from az_groups');

1764: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1765: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1766: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1767: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1768: fnd_message.set_token('AZW_ERROR_STMT','select hierarchy_parent_id from az_groups');
1769: APP_EXCEPTION.RAISE_EXCEPTION;
1770: END;
1771:
1772: ELSIF (v_total_kids <> 0 AND v_cnt <> 0) THEN

Line 1776: UPDATE az_groups

1772: ELSIF (v_total_kids <> 0 AND v_cnt <> 0) THEN
1773: WHILE (v_parent_id IS NOT NULL) LOOP
1774:
1775: BEGIN
1776: UPDATE az_groups
1777: SET complete_flag = 'N'
1778: WHERE group_id = v_parent_id
1779: AND process_type = g_current_mode;
1780: COMMIT;

Line 1787: fnd_message.set_token('AZW_ERROR_STMT','update az_groups set complete_flag = N');

1783: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1784: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1785: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1786: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1787: fnd_message.set_token('AZW_ERROR_STMT','update az_groups set complete_flag = N');
1788: APP_EXCEPTION.RAISE_EXCEPTION;
1789: END;
1790:
1791: BEGIN

Line 1794: FROM az_groups ag

1790:
1791: BEGIN
1792: SELECT ag.hierarchy_parent_id
1793: INTO v_parent_id
1794: FROM az_groups ag
1795: WHERE ag.group_id = v_parent_id
1796: AND ag.process_type = g_current_mode;
1797: EXCEPTION
1798: WHEN OTHERS THEN

Line 1803: fnd_message.set_token('AZW_ERROR_STMT','select hierarchy_parent_id from az_groups');

1799: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1800: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1801: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1802: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1803: fnd_message.set_token('AZW_ERROR_STMT','select hierarchy_parent_id from az_groups');
1804: APP_EXCEPTION.RAISE_EXCEPTION;
1805: END;
1806: END LOOP;
1807:

Line 1838: v_group_id az_groups.group_id%TYPE;

1834: PROCEDURE update_hierarchy_status(p_item_type IN VARCHAR2,
1835: p_process_name IN VARCHAR2,
1836: p_context_id IN VARCHAR2) IS
1837:
1838: v_group_id az_groups.group_id%TYPE;
1839: v_cnt NUMBER DEFAULT 0;
1840: v_status VARCHAR2(1);
1841:
1842: BEGIN

Line 1890: UPDATE az_groups ag

1886: v_status := 'N';
1887: END IF;
1888:
1889: BEGIN
1890: UPDATE az_groups ag
1891: SET ag.complete_flag = v_status
1892: WHERE ag.group_id = v_group_id
1893: AND ag.process_type = g_current_mode;
1894: COMMIT;

Line 1901: fnd_message.set_token('AZW_ERROR_STMT','update az_groups set complete_flag');

1897: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1898: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1899: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1900: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_hierarchy_status');
1901: fnd_message.set_token('AZW_ERROR_STMT','update az_groups set complete_flag');
1902: APP_EXCEPTION.RAISE_EXCEPTION;
1903: END;
1904:
1905: -- update groups complete status, starting with the leaf group id