APPS.AZW_GROUP dependencies on AZ_GROUPS

Line 32: FROM az_groups

28:
29: FUNCTION contains_processes ( node_id IN VARCHAR2 ) RETURN BOOLEAN IS
30: CURSOR sub_group_c IS
31: SELECT group_id
32: FROM az_groups
33: WHERE
34: hierarchy_parent_id = node_id
35: AND process_type = g_current_mode ;
36:

Line 38: v_node_id az_groups.group_id%TYPE;

34: hierarchy_parent_id = node_id
35: AND process_type = g_current_mode ;
36:
37: ret_val BOOLEAN DEFAULT TRUE;
38: v_node_id az_groups.group_id%TYPE;
39: child_count INTEGER DEFAULT 0;
40: BEGIN
41:
42: BEGIN

Line 170: FROM az_groups azg, fnd_product_installations fpi

166: BEGIN
167:
168: SELECT count(*)
169: INTO v_count_installed
170: FROM az_groups azg, fnd_product_installations fpi
171: WHERE fpi.application_id = azg.application_id
172: AND fpi.status = 'I'
173: AND azg.dependency_parent_id = p_group_id
174: AND process_type = g_current_mode;

Line 209: v_node_id az_groups.group_id%TYPE;

205: --
206:
207: PROCEDURE get_group_dependency (gd OUT dependency_tbl_t) IS
208:
209: v_node_id az_groups.group_id%TYPE;
210: v_parent_node_id az_groups.dependency_parent_id%TYPE;
211: v_display_order az_groups.display_order%TYPE;
212: v_application_id az_groups.application_id%TYPE;
213: v_lookup_code az_groups.lookup_code%TYPE;

Line 210: v_parent_node_id az_groups.dependency_parent_id%TYPE;

206:
207: PROCEDURE get_group_dependency (gd OUT dependency_tbl_t) IS
208:
209: v_node_id az_groups.group_id%TYPE;
210: v_parent_node_id az_groups.dependency_parent_id%TYPE;
211: v_display_order az_groups.display_order%TYPE;
212: v_application_id az_groups.application_id%TYPE;
213: v_lookup_code az_groups.lookup_code%TYPE;
214: v_color_code az_groups.color_code%TYPE;

Line 211: v_display_order az_groups.display_order%TYPE;

207: PROCEDURE get_group_dependency (gd OUT dependency_tbl_t) IS
208:
209: v_node_id az_groups.group_id%TYPE;
210: v_parent_node_id az_groups.dependency_parent_id%TYPE;
211: v_display_order az_groups.display_order%TYPE;
212: v_application_id az_groups.application_id%TYPE;
213: v_lookup_code az_groups.lookup_code%TYPE;
214: v_color_code az_groups.color_code%TYPE;
215: v_complete_flag az_groups.complete_flag%TYPE;

Line 212: v_application_id az_groups.application_id%TYPE;

208:
209: v_node_id az_groups.group_id%TYPE;
210: v_parent_node_id az_groups.dependency_parent_id%TYPE;
211: v_display_order az_groups.display_order%TYPE;
212: v_application_id az_groups.application_id%TYPE;
213: v_lookup_code az_groups.lookup_code%TYPE;
214: v_color_code az_groups.color_code%TYPE;
215: v_complete_flag az_groups.complete_flag%TYPE;
216: i BINARY_INTEGER DEFAULT 0;

Line 213: v_lookup_code az_groups.lookup_code%TYPE;

209: v_node_id az_groups.group_id%TYPE;
210: v_parent_node_id az_groups.dependency_parent_id%TYPE;
211: v_display_order az_groups.display_order%TYPE;
212: v_application_id az_groups.application_id%TYPE;
213: v_lookup_code az_groups.lookup_code%TYPE;
214: v_color_code az_groups.color_code%TYPE;
215: v_complete_flag az_groups.complete_flag%TYPE;
216: i BINARY_INTEGER DEFAULT 0;
217:

Line 214: v_color_code az_groups.color_code%TYPE;

210: v_parent_node_id az_groups.dependency_parent_id%TYPE;
211: v_display_order az_groups.display_order%TYPE;
212: v_application_id az_groups.application_id%TYPE;
213: v_lookup_code az_groups.lookup_code%TYPE;
214: v_color_code az_groups.color_code%TYPE;
215: v_complete_flag az_groups.complete_flag%TYPE;
216: i BINARY_INTEGER DEFAULT 0;
217:
218:

Line 215: v_complete_flag az_groups.complete_flag%TYPE;

211: v_display_order az_groups.display_order%TYPE;
212: v_application_id az_groups.application_id%TYPE;
213: v_lookup_code az_groups.lookup_code%TYPE;
214: v_color_code az_groups.color_code%TYPE;
215: v_complete_flag az_groups.complete_flag%TYPE;
216: i BINARY_INTEGER DEFAULT 0;
217:
218:
219: CURSOR dependency_cursor IS

Line 222: FROM az_groups

218:
219: CURSOR dependency_cursor IS
220: SELECT group_id, dependency_parent_id, display_order,
221: application_id, lookup_code, color_code, complete_flag
222: FROM az_groups
223: WHERE hierarchy_parent_id is null
224: AND process_type = g_current_mode
225: ORDER BY 1;
226: