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_UTIL dependencies on WF_ACTIVITIES

Line 14: act_itemtype wf_activities.item_type%TYPE;

10: procedure UpdateDocUrl(
11: p_itemtype in varchar2,
12: p_workflow in varchar2) IS
13: proc_version wf_process_activities.process_version%TYPE;
14: act_itemtype wf_activities.item_type%TYPE;
15: act_name wf_activities.name%TYPE;
16: act_type wf_activities.type%TYPE;
17: mesg_name wf_activities.message%TYPE;
18: app_short_name varchar2(30);

Line 15: act_name wf_activities.name%TYPE;

11: p_itemtype in varchar2,
12: p_workflow in varchar2) IS
13: proc_version wf_process_activities.process_version%TYPE;
14: act_itemtype wf_activities.item_type%TYPE;
15: act_name wf_activities.name%TYPE;
16: act_type wf_activities.type%TYPE;
17: mesg_name wf_activities.message%TYPE;
18: app_short_name varchar2(30);
19: target varchar2(255);

Line 16: act_type wf_activities.type%TYPE;

12: p_workflow in varchar2) IS
13: proc_version wf_process_activities.process_version%TYPE;
14: act_itemtype wf_activities.item_type%TYPE;
15: act_name wf_activities.name%TYPE;
16: act_type wf_activities.type%TYPE;
17: mesg_name wf_activities.message%TYPE;
18: app_short_name varchar2(30);
19: target varchar2(255);
20: url varchar2(255);

Line 17: mesg_name wf_activities.message%TYPE;

13: proc_version wf_process_activities.process_version%TYPE;
14: act_itemtype wf_activities.item_type%TYPE;
15: act_name wf_activities.name%TYPE;
16: act_type wf_activities.type%TYPE;
17: mesg_name wf_activities.message%TYPE;
18: app_short_name varchar2(30);
19: target varchar2(255);
20: url varchar2(255);
21:

Line 67: from wf_activities

63: FETCH c_act_c into act_itemtype, act_name;
64: while(c_act_c%FOUND) loop
65: BEGIN
66: select type into act_type
67: from wf_activities
68: where item_type = act_itemtype
69: and name = act_name
70: and end_date is NULL;
71: EXCEPTION

Line 79: fnd_message.set_token('AZW_ERROR_STMT','select type from wf_activities');

75: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
76: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
77: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
78: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
79: fnd_message.set_token('AZW_ERROR_STMT','select type from wf_activities');
80: APP_EXCEPTION.RAISE_EXCEPTION;
81: END;
82:
83: if (act_type = 'NOTICE') then

Line 86: from wf_activities

82:
83: if (act_type = 'NOTICE') then
84: BEGIN
85: select message into mesg_name
86: from wf_activities
87: where item_type = act_itemtype
88: and name = act_name
89: and end_date is NULL;
90: EXCEPTION

Line 98: fnd_message.set_token('AZW_ERROR_STMT','select message from wf_activities');

94: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
95: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
96: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
97: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
98: fnd_message.set_token('AZW_ERROR_STMT','select message from wf_activities');
99: APP_EXCEPTION.RAISE_EXCEPTION;
100: END;
101:
102: BEGIN