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_HIER dependencies on AZ_PROCESSES

Line 14: context_name az_processes.context_name%TYPE,

10: display_name VARCHAR2(415),
11: parent_node_id VARCHAR2(300),
12: node_type VARCHAR2(1),
13: status VARCHAR2(30),
14: context_name az_processes.context_name%TYPE,
15: context_type az_processes.context_type%TYPE,
16: display_order az_processes.display_order%TYPE );
17:
18: TYPE hierarchy_tbl_t IS TABLE OF hierarchy_rec_t INDEX BY BINARY_INTEGER;

Line 15: context_type az_processes.context_type%TYPE,

11: parent_node_id VARCHAR2(300),
12: node_type VARCHAR2(1),
13: status VARCHAR2(30),
14: context_name az_processes.context_name%TYPE,
15: context_type az_processes.context_type%TYPE,
16: display_order az_processes.display_order%TYPE );
17:
18: TYPE hierarchy_tbl_t IS TABLE OF hierarchy_rec_t INDEX BY BINARY_INTEGER;
19:

Line 16: display_order az_processes.display_order%TYPE );

12: node_type VARCHAR2(1),
13: status VARCHAR2(30),
14: context_name az_processes.context_name%TYPE,
15: context_type az_processes.context_type%TYPE,
16: display_order az_processes.display_order%TYPE );
17:
18: TYPE hierarchy_tbl_t IS TABLE OF hierarchy_rec_t INDEX BY BINARY_INTEGER;
19:
20: hierarchy_table hierarchy_tbl_t;

Line 45: g_current_mode az_processes.process_type%TYPE ;

41: ctx_table OUT AZW_PROC.context_tbl_t);
42:
43: -- End: added by swarup for context sort
44:
45: g_current_mode az_processes.process_type%TYPE ;
46:
47: msg_delimiter VARCHAR2(1) := '^';
48: v_language_code fnd_languages.language_code%TYPE DEFAULT NULL;
49: v_language fnd_languages.nls_language%TYPE DEFAULT NULL;

Line 203: FROM az_processes azp,

199: azp.comments,
200: azp.parent_id,
201: azfpv.phase,
202: wav.display_name
203: FROM az_processes azp,
204: az_flow_phases_v azfpv,
205: wf_activities_vl wav
206: WHERE azfpv.item_type = azp.item_type
207: AND azfpv.process_name = azp.process_name

Line 227: FROM az_processes azp,

223: azp.comments,
224: azp.parent_id,
225: azfpv.phase,
226: wav.display_name
227: FROM az_processes azp,
228: az_flow_phases_v azfpv,
229: wf_activities_vl wav
230: WHERE azfpv.item_type = azp.item_type
231: AND azfpv.process_name = azp.process_name

Line 250: FROM az_processes azp,

246: azp.comments,
247: azp.parent_id,
248: azfpv.phase,
249: wav.display_name
250: FROM az_processes azp,
251: az_flow_phases_v azfpv,
252: wf_activities_vl wav,
253: az_webform_messages azm
254: WHERE azfpv.item_type = azp.item_type

Line 1034: az_processes azp,

1030: azp.parent_id,
1031: azfpv.phase,
1032: wav.display_name
1033: FROM wf_activities_vl wav,
1034: az_processes azp,
1035: az_flow_phases_v azfpv
1036: WHERE azfpv.item_type = azp.item_type
1037: AND azfpv.process_name = azp.process_name
1038: AND azp.process_type = g_current_mode

Line 1057: az_processes azp,

1053: azp.parent_id,
1054: azfpv.phase,
1055: wav.display_name
1056: FROM wf_activities_vl wav,
1057: az_processes azp,
1058: az_flow_phases_v azfpv
1059: WHERE azfpv.item_type = azp.item_type
1060: AND azfpv.process_name = azp.process_name
1061: AND azp.process_type = g_current_mode

Line 1204: v_item_type az_processes.item_type%TYPE;

1200: p_task_tot_days IN NUMBER,
1201: p_task_tot_days_op IN VARCHAR2,
1202: p_sort_by IN VARCHAR2)
1203: IS
1204: v_item_type az_processes.item_type%TYPE;
1205: v_item_type_p az_processes.item_type%TYPE;
1206: v_process_name az_processes.process_name%TYPE;
1207: v_parent_id az_processes.parent_id%TYPE;
1208: v_comments az_processes.comments%TYPE;

Line 1205: v_item_type_p az_processes.item_type%TYPE;

1201: p_task_tot_days_op IN VARCHAR2,
1202: p_sort_by IN VARCHAR2)
1203: IS
1204: v_item_type az_processes.item_type%TYPE;
1205: v_item_type_p az_processes.item_type%TYPE;
1206: v_process_name az_processes.process_name%TYPE;
1207: v_parent_id az_processes.parent_id%TYPE;
1208: v_comments az_processes.comments%TYPE;
1209: v_context_id az_processes.context_id%TYPE;

Line 1206: v_process_name az_processes.process_name%TYPE;

1202: p_sort_by IN VARCHAR2)
1203: IS
1204: v_item_type az_processes.item_type%TYPE;
1205: v_item_type_p az_processes.item_type%TYPE;
1206: v_process_name az_processes.process_name%TYPE;
1207: v_parent_id az_processes.parent_id%TYPE;
1208: v_comments az_processes.comments%TYPE;
1209: v_context_id az_processes.context_id%TYPE;
1210: v_status_code az_processes.status_code%TYPE;

Line 1207: v_parent_id az_processes.parent_id%TYPE;

1203: IS
1204: v_item_type az_processes.item_type%TYPE;
1205: v_item_type_p az_processes.item_type%TYPE;
1206: v_process_name az_processes.process_name%TYPE;
1207: v_parent_id az_processes.parent_id%TYPE;
1208: v_comments az_processes.comments%TYPE;
1209: v_context_id az_processes.context_id%TYPE;
1210: v_status_code az_processes.status_code%TYPE;
1211: v_context_type az_processes.context_type%TYPE;

Line 1208: v_comments az_processes.comments%TYPE;

1204: v_item_type az_processes.item_type%TYPE;
1205: v_item_type_p az_processes.item_type%TYPE;
1206: v_process_name az_processes.process_name%TYPE;
1207: v_parent_id az_processes.parent_id%TYPE;
1208: v_comments az_processes.comments%TYPE;
1209: v_context_id az_processes.context_id%TYPE;
1210: v_status_code az_processes.status_code%TYPE;
1211: v_context_type az_processes.context_type%TYPE;
1212: v_context_name az_processes.context_name%TYPE;

Line 1209: v_context_id az_processes.context_id%TYPE;

1205: v_item_type_p az_processes.item_type%TYPE;
1206: v_process_name az_processes.process_name%TYPE;
1207: v_parent_id az_processes.parent_id%TYPE;
1208: v_comments az_processes.comments%TYPE;
1209: v_context_id az_processes.context_id%TYPE;
1210: v_status_code az_processes.status_code%TYPE;
1211: v_context_type az_processes.context_type%TYPE;
1212: v_context_name az_processes.context_name%TYPE;
1213: v_display_order az_processes.display_order%TYPE;

Line 1210: v_status_code az_processes.status_code%TYPE;

1206: v_process_name az_processes.process_name%TYPE;
1207: v_parent_id az_processes.parent_id%TYPE;
1208: v_comments az_processes.comments%TYPE;
1209: v_context_id az_processes.context_id%TYPE;
1210: v_status_code az_processes.status_code%TYPE;
1211: v_context_type az_processes.context_type%TYPE;
1212: v_context_name az_processes.context_name%TYPE;
1213: v_display_order az_processes.display_order%TYPE;
1214:

Line 1211: v_context_type az_processes.context_type%TYPE;

1207: v_parent_id az_processes.parent_id%TYPE;
1208: v_comments az_processes.comments%TYPE;
1209: v_context_id az_processes.context_id%TYPE;
1210: v_status_code az_processes.status_code%TYPE;
1211: v_context_type az_processes.context_type%TYPE;
1212: v_context_name az_processes.context_name%TYPE;
1213: v_display_order az_processes.display_order%TYPE;
1214:
1215: v_status wf_item_activity_statuses.activity_status%TYPE;

Line 1212: v_context_name az_processes.context_name%TYPE;

1208: v_comments az_processes.comments%TYPE;
1209: v_context_id az_processes.context_id%TYPE;
1210: v_status_code az_processes.status_code%TYPE;
1211: v_context_type az_processes.context_type%TYPE;
1212: v_context_name az_processes.context_name%TYPE;
1213: v_display_order az_processes.display_order%TYPE;
1214:
1215: v_status wf_item_activity_statuses.activity_status%TYPE;
1216: v_task_status wf_item_activity_statuses.activity_status%TYPE;

Line 1213: v_display_order az_processes.display_order%TYPE;

1209: v_context_id az_processes.context_id%TYPE;
1210: v_status_code az_processes.status_code%TYPE;
1211: v_context_type az_processes.context_type%TYPE;
1212: v_context_name az_processes.context_name%TYPE;
1213: v_display_order az_processes.display_order%TYPE;
1214:
1215: v_status wf_item_activity_statuses.activity_status%TYPE;
1216: v_task_status wf_item_activity_statuses.activity_status%TYPE;
1217: v_dummy_begin_date wf_item_activity_statuses.begin_date%TYPE;

Line 1234: FROM az_processes;

1230: v_display_status wf_resources.text%TYPE;
1231:
1232: CURSOR az_item_types IS
1233: SELECT distinct item_type
1234: FROM az_processes;
1235:
1236: CURSOR az_tasks_cursor IS
1237: SELECT DISTINCT wfi.item_key,
1238: wfi.root_activity,

Line 1251: az_processes azp,

1247: FROM wf_item_attribute_values wiav1,
1248: wf_item_attribute_values wiav2,
1249: wf_item_activity_statuses wias,
1250: wf_process_activities wpa,
1251: az_processes azp,
1252: az_flow_phases_v azpfv,
1253: wf_items wfi
1254: WHERE wfi.item_type = azp.item_type
1255: AND wfi.root_activity = azp.process_name

Line 1555: -- AZW_PROC.populate_az_processes is now called from AZWIZARD.fmb within the

1551: hierarchy_table.delete;
1552: msg.delete;
1553: t_index := 0;
1554:
1555: -- AZW_PROC.populate_az_processes is now called from AZWIZARD.fmb within the
1556: -- WHEN_NEW_FORM_INSTANCE trigger instead.
1557: -- AZW_PROC.populate_az_processes; -- DONT REMOVE THIS !!!
1558:
1559: -- get groups, then get processes and then tasks

Line 1557: -- AZW_PROC.populate_az_processes; -- DONT REMOVE THIS !!!

1553: t_index := 0;
1554:
1555: -- AZW_PROC.populate_az_processes is now called from AZWIZARD.fmb within the
1556: -- WHEN_NEW_FORM_INSTANCE trigger instead.
1557: -- AZW_PROC.populate_az_processes; -- DONT REMOVE THIS !!!
1558:
1559: -- get groups, then get processes and then tasks
1560: IF (p_process_group = 'ALL') THEN
1561: IF (p_sort_by = 'PH' OR p_sort_by = 'C') THEN

Line 1813: FROM az_processes

1809:
1810: BEGIN
1811: SELECT count(distinct context_type)
1812: INTO v_count
1813: FROM az_processes
1814: WHERE context_type = ctx_type
1815: AND process_type = g_current_mode
1816: AND parent_id = p_node_id ;
1817:

Line 1895: * from az_processes table.

1891:
1892: /*---------------------------------------------------------------
1893: * get_context : private procedure
1894: * retrieves all distinct context_id, context_name
1895: * from az_processes table.
1896: * AZW_PROC.get_context fetches all the context_id, context_name
1897: * but this one fetches only those for which some processes exists.
1898: *--------------------------------------------------------------*/
1899:

Line 1905: FROM az_processes

1901: ctx_table OUT AZW_PROC.context_tbl_t) IS
1902:
1903: CURSOR ctx_cursor IS
1904: SELECT DISTINCT context_id, context_name
1905: FROM az_processes
1906: WHERE
1907: context_type = ctx_type
1908: ORDER BY context_name;
1909: i BINARY_INTEGER DEFAULT 0;

Line 1925: fnd_message.set_token('AZW_ERROR_STMT','cursor select from az_processes ');

1921: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1922: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1923: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1924: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_context');
1925: fnd_message.set_token('AZW_ERROR_STMT','cursor select from az_processes ');
1926: END get_context;
1927:
1928: END AZW_HIER;