APPS.AZW_GROUP dependencies on AZ_PROCESSES

Line 21: g_current_mode az_processes.process_type%TYPE DEFAULT 'IMP';

17: display_order NUMBER(5));
18:
19: TYPE dependency_tbl_t IS TABLE OF dependency_rec_t INDEX BY BINARY_INTEGER;
20:
21: g_current_mode az_processes.process_type%TYPE DEFAULT 'IMP';
22: --
23: -- get_installed_flag
24: --
25: -- Private function. Called by get_group_dependency.

Line 45: FROM az_processes azp

41:
42: BEGIN
43: SELECT count(*)
44: INTO child_count
45: FROM az_processes azp
46: WHERE azp.parent_id = node_id
47: AND azp.process_type = g_current_mode ;
48: EXCEPTION
49: WHEN app_exception.application_exception THEN

Line 56: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into child_count from az_processes');

52: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
53: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
54: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
55: fnd_message.set_token('AZW_ERROR_PROC','azw_group.contains_processes');
56: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into child_count from az_processes');
57: APP_EXCEPTION.RAISE_EXCEPTION;
58: END;
59:
60: --dbms_output.put_line('Here: '||child_count|| ' MODE: ' ||g_current_mode || ' P:'|| node_id);