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.JTF_FM_PROCESS_REQUEST_WF dependencies on WF_ENGINE

Line 47: wf_engine.SetItemUserKey ( ItemType => Item_Type,

43: x_msg_data IN OUT NOCOPY VARCHAR2,
44: x_return_status IN OUT NOCOPY VARCHAR2) is
45: begin
46: --intialise the workflow attributes
47: wf_engine.SetItemUserKey ( ItemType => Item_Type,
48: ItemKey => Item_Key,
49: UserKey => Item_User_Key);
50: wf_engine.SetItemAttrText ( itemtype => Item_Type,
51: itemkey => Item_Key,

Line 50: wf_engine.SetItemAttrText ( itemtype => Item_Type,

46: --intialise the workflow attributes
47: wf_engine.SetItemUserKey ( ItemType => Item_Type,
48: ItemKey => Item_Key,
49: UserKey => Item_User_Key);
50: wf_engine.SetItemAttrText ( itemtype => Item_Type,
51: itemkey => Item_Key,
52: aname => 'CONTENT_XML',
53: avalue => p_content_xml);
54: wf_engine.SetItemAttrText ( itemtype => Item_Type,

Line 54: wf_engine.SetItemAttrText ( itemtype => Item_Type,

50: wf_engine.SetItemAttrText ( itemtype => Item_Type,
51: itemkey => Item_Key,
52: aname => 'CONTENT_XML',
53: avalue => p_content_xml);
54: wf_engine.SetItemAttrText ( itemtype => Item_Type,
55: itemkey => Item_Key,
56: aname => 'API_VERSION',
57: avalue => p_api_version);
58: wf_engine.SetItemAttrText ( itemtype => Item_Type,

Line 58: wf_engine.SetItemAttrText ( itemtype => Item_Type,

54: wf_engine.SetItemAttrText ( itemtype => Item_Type,
55: itemkey => Item_Key,
56: aname => 'API_VERSION',
57: avalue => p_api_version);
58: wf_engine.SetItemAttrText ( itemtype => Item_Type,
59: itemkey => Item_Key,
60: aname => 'INIT_MSG_LIST',
61: avalue => p_init_msg_list);
62: wf_engine.SetItemAttrText ( itemtype => Item_Type,

Line 62: wf_engine.SetItemAttrText ( itemtype => Item_Type,

58: wf_engine.SetItemAttrText ( itemtype => Item_Type,
59: itemkey => Item_Key,
60: aname => 'INIT_MSG_LIST',
61: avalue => p_init_msg_list);
62: wf_engine.SetItemAttrText ( itemtype => Item_Type,
63: itemkey => Item_Key,
64: aname => 'COMMIT',
65: avalue => p_commit);
66: wf_engine.SetItemAttrText ( itemtype => Item_Type,

Line 66: wf_engine.SetItemAttrText ( itemtype => Item_Type,

62: wf_engine.SetItemAttrText ( itemtype => Item_Type,
63: itemkey => Item_Key,
64: aname => 'COMMIT',
65: avalue => p_commit);
66: wf_engine.SetItemAttrText ( itemtype => Item_Type,
67: itemkey => Item_Key,
68: aname => 'VALIDATION_LEVEL',
69: avalue => p_validation_level);
70: wf_engine.SetItemAttrText ( itemtype => Item_Type,

Line 70: wf_engine.SetItemAttrText ( itemtype => Item_Type,

66: wf_engine.SetItemAttrText ( itemtype => Item_Type,
67: itemkey => Item_Key,
68: aname => 'VALIDATION_LEVEL',
69: avalue => p_validation_level);
70: wf_engine.SetItemAttrText ( itemtype => Item_Type,
71: itemkey => Item_Key,
72: aname => 'TEMPLATE_ID',
73: avalue => p_template_id);
74: wf_engine.SetItemAttrText ( itemtype => Item_Type,

Line 74: wf_engine.SetItemAttrText ( itemtype => Item_Type,

70: wf_engine.SetItemAttrText ( itemtype => Item_Type,
71: itemkey => Item_Key,
72: aname => 'TEMPLATE_ID',
73: avalue => p_template_id);
74: wf_engine.SetItemAttrText ( itemtype => Item_Type,
75: itemkey => Item_Key,
76: aname => 'SUBJECT',
77: avalue => p_subject);
78: wf_engine.SetItemAttrText ( itemtype => Item_Type,

Line 78: wf_engine.SetItemAttrText ( itemtype => Item_Type,

74: wf_engine.SetItemAttrText ( itemtype => Item_Type,
75: itemkey => Item_Key,
76: aname => 'SUBJECT',
77: avalue => p_subject);
78: wf_engine.SetItemAttrText ( itemtype => Item_Type,
79: itemkey => Item_Key,
80: aname => 'PARTY_ID',
81: avalue => p_party_id);
82: wf_engine.SetItemAttrText ( itemtype => Item_Type,

Line 82: wf_engine.SetItemAttrText ( itemtype => Item_Type,

78: wf_engine.SetItemAttrText ( itemtype => Item_Type,
79: itemkey => Item_Key,
80: aname => 'PARTY_ID',
81: avalue => p_party_id);
82: wf_engine.SetItemAttrText ( itemtype => Item_Type,
83: itemkey => Item_Key,
84: aname => 'PARTY_NAME',
85: avalue => p_party_name);
86: wf_engine.SetItemAttrText ( itemtype => Item_Type,

Line 86: wf_engine.SetItemAttrText ( itemtype => Item_Type,

82: wf_engine.SetItemAttrText ( itemtype => Item_Type,
83: itemkey => Item_Key,
84: aname => 'PARTY_NAME',
85: avalue => p_party_name);
86: wf_engine.SetItemAttrText ( itemtype => Item_Type,
87: itemkey => Item_Key,
88: aname => 'PRIORITY',
89: avalue => p_priority);
90: wf_engine.SetItemAttrText ( itemtype => Item_Type,

Line 90: wf_engine.SetItemAttrText ( itemtype => Item_Type,

86: wf_engine.SetItemAttrText ( itemtype => Item_Type,
87: itemkey => Item_Key,
88: aname => 'PRIORITY',
89: avalue => p_priority);
90: wf_engine.SetItemAttrText ( itemtype => Item_Type,
91: itemkey => Item_Key,
92: aname => 'SOURCE_CODE_ID',
93: avalue => p_source_code_id);
94: wf_engine.SetItemAttrText ( itemtype => Item_Type,

Line 94: wf_engine.SetItemAttrText ( itemtype => Item_Type,

90: wf_engine.SetItemAttrText ( itemtype => Item_Type,
91: itemkey => Item_Key,
92: aname => 'SOURCE_CODE_ID',
93: avalue => p_source_code_id);
94: wf_engine.SetItemAttrText ( itemtype => Item_Type,
95: itemkey => Item_Key,
96: aname => 'SOURCE_CODE',
97: avalue => p_source_code);
98: wf_engine.SetItemAttrText ( itemtype => Item_Type,

Line 98: wf_engine.SetItemAttrText ( itemtype => Item_Type,

94: wf_engine.SetItemAttrText ( itemtype => Item_Type,
95: itemkey => Item_Key,
96: aname => 'SOURCE_CODE',
97: avalue => p_source_code);
98: wf_engine.SetItemAttrText ( itemtype => Item_Type,
99: itemkey => Item_Key,
100: aname => 'OBJECT_TYPE',
101: avalue => p_object_type);
102: wf_engine.SetItemAttrText ( itemtype => Item_Type,

Line 102: wf_engine.SetItemAttrText ( itemtype => Item_Type,

98: wf_engine.SetItemAttrText ( itemtype => Item_Type,
99: itemkey => Item_Key,
100: aname => 'OBJECT_TYPE',
101: avalue => p_object_type);
102: wf_engine.SetItemAttrText ( itemtype => Item_Type,
103: itemkey => Item_Key,
104: aname => 'OBJECT_ID',
105: avalue => p_object_id);
106: wf_engine.SetItemAttrText ( itemtype => Item_Type,

Line 106: wf_engine.SetItemAttrText ( itemtype => Item_Type,

102: wf_engine.SetItemAttrText ( itemtype => Item_Type,
103: itemkey => Item_Key,
104: aname => 'OBJECT_ID',
105: avalue => p_object_id);
106: wf_engine.SetItemAttrText ( itemtype => Item_Type,
107: itemkey => Item_Key,
108: aname => 'ORDER_ID',
109: avalue => p_order_id);
110: wf_engine.SetItemAttrText ( itemtype => Item_Type,

Line 110: wf_engine.SetItemAttrText ( itemtype => Item_Type,

106: wf_engine.SetItemAttrText ( itemtype => Item_Type,
107: itemkey => Item_Key,
108: aname => 'ORDER_ID',
109: avalue => p_order_id);
110: wf_engine.SetItemAttrText ( itemtype => Item_Type,
111: itemkey => Item_Key,
112: aname => 'DOC_ID',
113: avalue => p_doc_id);
114: wf_engine.SetItemAttrText ( itemtype => Item_Type,

Line 114: wf_engine.SetItemAttrText ( itemtype => Item_Type,

110: wf_engine.SetItemAttrText ( itemtype => Item_Type,
111: itemkey => Item_Key,
112: aname => 'DOC_ID',
113: avalue => p_doc_id);
114: wf_engine.SetItemAttrText ( itemtype => Item_Type,
115: itemkey => Item_Key,
116: aname => 'DOC_REF',
117: avalue => p_doc_ref);
118: wf_engine.SetItemAttrText ( itemtype => Item_Type,

Line 118: wf_engine.SetItemAttrText ( itemtype => Item_Type,

114: wf_engine.SetItemAttrText ( itemtype => Item_Type,
115: itemkey => Item_Key,
116: aname => 'DOC_REF',
117: avalue => p_doc_ref);
118: wf_engine.SetItemAttrText ( itemtype => Item_Type,
119: itemkey => Item_Key,
120: aname => 'SERVER_ID',
121: avalue => p_server_id);
122: wf_engine.SetItemAttrText ( itemtype => Item_Type,

Line 122: wf_engine.SetItemAttrText ( itemtype => Item_Type,

118: wf_engine.SetItemAttrText ( itemtype => Item_Type,
119: itemkey => Item_Key,
120: aname => 'SERVER_ID',
121: avalue => p_server_id);
122: wf_engine.SetItemAttrText ( itemtype => Item_Type,
123: itemkey => Item_Key,
124: aname => 'QUEUE_RESPONSE',
125: avalue => p_queue_response);
126: wf_engine.SetItemAttrText ( itemtype => Item_Type,

Line 126: wf_engine.SetItemAttrText ( itemtype => Item_Type,

122: wf_engine.SetItemAttrText ( itemtype => Item_Type,
123: itemkey => Item_Key,
124: aname => 'QUEUE_RESPONSE',
125: avalue => p_queue_response);
126: wf_engine.SetItemAttrText ( itemtype => Item_Type,
127: itemkey => Item_Key,
128: aname => 'EXTENDED_HEADER',
129: avalue => p_extended_header);
130: wf_engine.SetItemAttrText ( itemtype => Item_Type,

Line 130: wf_engine.SetItemAttrText ( itemtype => Item_Type,

126: wf_engine.SetItemAttrText ( itemtype => Item_Type,
127: itemkey => Item_Key,
128: aname => 'EXTENDED_HEADER',
129: avalue => p_extended_header);
130: wf_engine.SetItemAttrText ( itemtype => Item_Type,
131: itemkey => Item_Key,
132: aname => 'CONTENT_ID',
133: avalue => p_content_id);
134: wf_engine.SetItemAttrText ( itemtype => Item_Type,

Line 134: wf_engine.SetItemAttrText ( itemtype => Item_Type,

130: wf_engine.SetItemAttrText ( itemtype => Item_Type,
131: itemkey => Item_Key,
132: aname => 'CONTENT_ID',
133: avalue => p_content_id);
134: wf_engine.SetItemAttrText ( itemtype => Item_Type,
135: itemkey => Item_Key,
136: aname => 'REQUEST_ID',
137: avalue => p_request_id);
138: wf_engine.SetItemAttrText ( itemtype => Item_Type,

Line 138: wf_engine.SetItemAttrText ( itemtype => Item_Type,

134: wf_engine.SetItemAttrText ( itemtype => Item_Type,
135: itemkey => Item_Key,
136: aname => 'REQUEST_ID',
137: avalue => p_request_id);
138: wf_engine.SetItemAttrText ( itemtype => Item_Type,
139: itemkey => Item_Key,
140: aname => 'RESULT',
141: avalue => x_result);
142: wf_engine.SetItemAttrText ( itemtype => Item_Type,

Line 142: wf_engine.SetItemAttrText ( itemtype => Item_Type,

138: wf_engine.SetItemAttrText ( itemtype => Item_Type,
139: itemkey => Item_Key,
140: aname => 'RESULT',
141: avalue => x_result);
142: wf_engine.SetItemAttrText ( itemtype => Item_Type,
143: itemkey => Item_Key,
144: aname => 'MSG_COUNT',
145: avalue => x_msg_count);
146: wf_engine.SetItemAttrText ( itemtype => Item_Type,

Line 146: wf_engine.SetItemAttrText ( itemtype => Item_Type,

142: wf_engine.SetItemAttrText ( itemtype => Item_Type,
143: itemkey => Item_Key,
144: aname => 'MSG_COUNT',
145: avalue => x_msg_count);
146: wf_engine.SetItemAttrText ( itemtype => Item_Type,
147: itemkey => Item_Key,
148: aname => 'MSG_DATA',
149: avalue => x_msg_data);
150: wf_engine.SetItemAttrText ( itemtype => Item_Type,

Line 150: wf_engine.SetItemAttrText ( itemtype => Item_Type,

146: wf_engine.SetItemAttrText ( itemtype => Item_Type,
147: itemkey => Item_Key,
148: aname => 'MSG_DATA',
149: avalue => x_msg_data);
150: wf_engine.SetItemAttrText ( itemtype => Item_Type,
151: itemkey => Item_Key,
152: aname => 'USER_ID',
153: avalue => p_user_id);
154: /*wf_engine.SetItemAttrText ( itemtype => Item_Type,

Line 154: /*wf_engine.SetItemAttrText ( itemtype => Item_Type,

150: wf_engine.SetItemAttrText ( itemtype => Item_Type,
151: itemkey => Item_Key,
152: aname => 'USER_ID',
153: avalue => p_user_id);
154: /*wf_engine.SetItemAttrText ( itemtype => Item_Type,
155: itemkey => Item_Key,
156: aname => 'RETURN_STATUS',
157: avalue => x_return_status);*/
158: wf_engine.StartProcess ( itemtype => Item_Type,

Line 158: wf_engine.StartProcess ( itemtype => Item_Type,

154: /*wf_engine.SetItemAttrText ( itemtype => Item_Type,
155: itemkey => Item_Key,
156: aname => 'RETURN_STATUS',
157: avalue => x_return_status);*/
158: wf_engine.StartProcess ( itemtype => Item_Type,
159: itemkey => Item_Key );
160: wf_engine.ItemStatus (itemtype => Item_Type,
161: itemkey => Item_Key,
162: status => x_return_status,

Line 160: wf_engine.ItemStatus (itemtype => Item_Type,

156: aname => 'RETURN_STATUS',
157: avalue => x_return_status);*/
158: wf_engine.StartProcess ( itemtype => Item_Type,
159: itemkey => Item_Key );
160: wf_engine.ItemStatus (itemtype => Item_Type,
161: itemkey => Item_Key,
162: status => x_return_status,
163: result => x_result);
164: --dbms_output.put_line('after item status status '||x_return_status||' '||'result->'||x_result);

Line 208: l_api_version := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'API_VERSION' );

204: l_msg_index_out number;
205: begin
206: IF funcmode = 'RUN' then
207: --dbms_output.put_line('Submit_fulfillment_request(JTFFMWF1) ' || itemkey);
208: l_api_version := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'API_VERSION' );
209: l_init_msg_list := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'INIT_MSG_LIST' );
210: l_commit := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'COMMIT' );
211: l_validation_level := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'VALIDATION_LEVEL' );
212: l_subject := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SUBJECT' );

Line 209: l_init_msg_list := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'INIT_MSG_LIST' );

205: begin
206: IF funcmode = 'RUN' then
207: --dbms_output.put_line('Submit_fulfillment_request(JTFFMWF1) ' || itemkey);
208: l_api_version := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'API_VERSION' );
209: l_init_msg_list := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'INIT_MSG_LIST' );
210: l_commit := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'COMMIT' );
211: l_validation_level := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'VALIDATION_LEVEL' );
212: l_subject := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SUBJECT' );
213: l_template_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'TEMPLATE_ID' );

Line 210: l_commit := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'COMMIT' );

206: IF funcmode = 'RUN' then
207: --dbms_output.put_line('Submit_fulfillment_request(JTFFMWF1) ' || itemkey);
208: l_api_version := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'API_VERSION' );
209: l_init_msg_list := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'INIT_MSG_LIST' );
210: l_commit := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'COMMIT' );
211: l_validation_level := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'VALIDATION_LEVEL' );
212: l_subject := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SUBJECT' );
213: l_template_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'TEMPLATE_ID' );
214: l_party_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PARTY_ID' );

Line 211: l_validation_level := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'VALIDATION_LEVEL' );

207: --dbms_output.put_line('Submit_fulfillment_request(JTFFMWF1) ' || itemkey);
208: l_api_version := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'API_VERSION' );
209: l_init_msg_list := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'INIT_MSG_LIST' );
210: l_commit := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'COMMIT' );
211: l_validation_level := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'VALIDATION_LEVEL' );
212: l_subject := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SUBJECT' );
213: l_template_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'TEMPLATE_ID' );
214: l_party_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PARTY_ID' );
215: l_party_name := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PARTY_NAME' );

Line 212: l_subject := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SUBJECT' );

208: l_api_version := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'API_VERSION' );
209: l_init_msg_list := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'INIT_MSG_LIST' );
210: l_commit := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'COMMIT' );
211: l_validation_level := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'VALIDATION_LEVEL' );
212: l_subject := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SUBJECT' );
213: l_template_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'TEMPLATE_ID' );
214: l_party_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PARTY_ID' );
215: l_party_name := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PARTY_NAME' );
216: l_priority := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PRIORITY' );

Line 213: l_template_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'TEMPLATE_ID' );

209: l_init_msg_list := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'INIT_MSG_LIST' );
210: l_commit := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'COMMIT' );
211: l_validation_level := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'VALIDATION_LEVEL' );
212: l_subject := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SUBJECT' );
213: l_template_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'TEMPLATE_ID' );
214: l_party_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PARTY_ID' );
215: l_party_name := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PARTY_NAME' );
216: l_priority := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PRIORITY' );
217: l_source_code_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SOURCE_CODE_ID' );

Line 214: l_party_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PARTY_ID' );

210: l_commit := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'COMMIT' );
211: l_validation_level := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'VALIDATION_LEVEL' );
212: l_subject := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SUBJECT' );
213: l_template_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'TEMPLATE_ID' );
214: l_party_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PARTY_ID' );
215: l_party_name := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PARTY_NAME' );
216: l_priority := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PRIORITY' );
217: l_source_code_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SOURCE_CODE_ID' );
218: l_source_code := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SOURCE_CODE' );

Line 215: l_party_name := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PARTY_NAME' );

211: l_validation_level := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'VALIDATION_LEVEL' );
212: l_subject := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SUBJECT' );
213: l_template_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'TEMPLATE_ID' );
214: l_party_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PARTY_ID' );
215: l_party_name := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PARTY_NAME' );
216: l_priority := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PRIORITY' );
217: l_source_code_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SOURCE_CODE_ID' );
218: l_source_code := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SOURCE_CODE' );
219: l_object_type := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'OBJECT_TYPE' );

Line 216: l_priority := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PRIORITY' );

212: l_subject := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SUBJECT' );
213: l_template_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'TEMPLATE_ID' );
214: l_party_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PARTY_ID' );
215: l_party_name := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PARTY_NAME' );
216: l_priority := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PRIORITY' );
217: l_source_code_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SOURCE_CODE_ID' );
218: l_source_code := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SOURCE_CODE' );
219: l_object_type := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'OBJECT_TYPE' );
220: l_object_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'OBJECT_ID' );

Line 217: l_source_code_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SOURCE_CODE_ID' );

213: l_template_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'TEMPLATE_ID' );
214: l_party_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PARTY_ID' );
215: l_party_name := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PARTY_NAME' );
216: l_priority := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PRIORITY' );
217: l_source_code_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SOURCE_CODE_ID' );
218: l_source_code := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SOURCE_CODE' );
219: l_object_type := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'OBJECT_TYPE' );
220: l_object_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'OBJECT_ID' );
221: l_order_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'ORDER_ID' );

Line 218: l_source_code := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SOURCE_CODE' );

214: l_party_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PARTY_ID' );
215: l_party_name := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PARTY_NAME' );
216: l_priority := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PRIORITY' );
217: l_source_code_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SOURCE_CODE_ID' );
218: l_source_code := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SOURCE_CODE' );
219: l_object_type := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'OBJECT_TYPE' );
220: l_object_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'OBJECT_ID' );
221: l_order_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'ORDER_ID' );
222: l_doc_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'DOC_ID' );

Line 219: l_object_type := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'OBJECT_TYPE' );

215: l_party_name := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PARTY_NAME' );
216: l_priority := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PRIORITY' );
217: l_source_code_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SOURCE_CODE_ID' );
218: l_source_code := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SOURCE_CODE' );
219: l_object_type := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'OBJECT_TYPE' );
220: l_object_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'OBJECT_ID' );
221: l_order_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'ORDER_ID' );
222: l_doc_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'DOC_ID' );
223: l_doc_ref := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'DOC_REF' );

Line 220: l_object_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'OBJECT_ID' );

216: l_priority := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'PRIORITY' );
217: l_source_code_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SOURCE_CODE_ID' );
218: l_source_code := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SOURCE_CODE' );
219: l_object_type := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'OBJECT_TYPE' );
220: l_object_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'OBJECT_ID' );
221: l_order_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'ORDER_ID' );
222: l_doc_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'DOC_ID' );
223: l_doc_ref := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'DOC_REF' );
224: l_server_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SERVER_ID' );

Line 221: l_order_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'ORDER_ID' );

217: l_source_code_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SOURCE_CODE_ID' );
218: l_source_code := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SOURCE_CODE' );
219: l_object_type := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'OBJECT_TYPE' );
220: l_object_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'OBJECT_ID' );
221: l_order_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'ORDER_ID' );
222: l_doc_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'DOC_ID' );
223: l_doc_ref := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'DOC_REF' );
224: l_server_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SERVER_ID' );
225: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'QUEUE_RESPONSE' );

Line 222: l_doc_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'DOC_ID' );

218: l_source_code := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SOURCE_CODE' );
219: l_object_type := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'OBJECT_TYPE' );
220: l_object_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'OBJECT_ID' );
221: l_order_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'ORDER_ID' );
222: l_doc_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'DOC_ID' );
223: l_doc_ref := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'DOC_REF' );
224: l_server_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SERVER_ID' );
225: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'QUEUE_RESPONSE' );
226: l_extended_header := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'EXTENDED_HEADER' );

Line 223: l_doc_ref := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'DOC_REF' );

219: l_object_type := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'OBJECT_TYPE' );
220: l_object_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'OBJECT_ID' );
221: l_order_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'ORDER_ID' );
222: l_doc_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'DOC_ID' );
223: l_doc_ref := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'DOC_REF' );
224: l_server_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SERVER_ID' );
225: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'QUEUE_RESPONSE' );
226: l_extended_header := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'EXTENDED_HEADER' );
227: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'REQUEST_ID' );

Line 224: l_server_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SERVER_ID' );

220: l_object_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'OBJECT_ID' );
221: l_order_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'ORDER_ID' );
222: l_doc_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'DOC_ID' );
223: l_doc_ref := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'DOC_REF' );
224: l_server_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SERVER_ID' );
225: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'QUEUE_RESPONSE' );
226: l_extended_header := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'EXTENDED_HEADER' );
227: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'REQUEST_ID' );
228: l_content_xml :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'CONTENT_XML' );

Line 225: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'QUEUE_RESPONSE' );

221: l_order_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'ORDER_ID' );
222: l_doc_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'DOC_ID' );
223: l_doc_ref := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'DOC_REF' );
224: l_server_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SERVER_ID' );
225: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'QUEUE_RESPONSE' );
226: l_extended_header := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'EXTENDED_HEADER' );
227: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'REQUEST_ID' );
228: l_content_xml :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'CONTENT_XML' );
229: l_msg_count :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'MSG_COUNT' );

Line 226: l_extended_header := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'EXTENDED_HEADER' );

222: l_doc_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'DOC_ID' );
223: l_doc_ref := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'DOC_REF' );
224: l_server_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SERVER_ID' );
225: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'QUEUE_RESPONSE' );
226: l_extended_header := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'EXTENDED_HEADER' );
227: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'REQUEST_ID' );
228: l_content_xml :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'CONTENT_XML' );
229: l_msg_count :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'MSG_COUNT' );
230: l_msg_data :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'MSG_DATA' );

Line 227: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'REQUEST_ID' );

223: l_doc_ref := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'DOC_REF' );
224: l_server_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SERVER_ID' );
225: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'QUEUE_RESPONSE' );
226: l_extended_header := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'EXTENDED_HEADER' );
227: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'REQUEST_ID' );
228: l_content_xml :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'CONTENT_XML' );
229: l_msg_count :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'MSG_COUNT' );
230: l_msg_data :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'MSG_DATA' );
231: l_user_id :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'USER_ID' );

Line 228: l_content_xml :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'CONTENT_XML' );

224: l_server_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'SERVER_ID' );
225: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'QUEUE_RESPONSE' );
226: l_extended_header := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'EXTENDED_HEADER' );
227: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'REQUEST_ID' );
228: l_content_xml :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'CONTENT_XML' );
229: l_msg_count :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'MSG_COUNT' );
230: l_msg_data :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'MSG_DATA' );
231: l_user_id :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'USER_ID' );
232: l_result :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'RESULT' );

Line 229: l_msg_count :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'MSG_COUNT' );

225: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'QUEUE_RESPONSE' );
226: l_extended_header := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'EXTENDED_HEADER' );
227: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'REQUEST_ID' );
228: l_content_xml :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'CONTENT_XML' );
229: l_msg_count :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'MSG_COUNT' );
230: l_msg_data :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'MSG_DATA' );
231: l_user_id :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'USER_ID' );
232: l_result :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'RESULT' );
233: --l_return_status :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'RETURN_STATUS' );

Line 230: l_msg_data :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'MSG_DATA' );

226: l_extended_header := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'EXTENDED_HEADER' );
227: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'REQUEST_ID' );
228: l_content_xml :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'CONTENT_XML' );
229: l_msg_count :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'MSG_COUNT' );
230: l_msg_data :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'MSG_DATA' );
231: l_user_id :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'USER_ID' );
232: l_result :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'RESULT' );
233: --l_return_status :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'RETURN_STATUS' );
234: --dbms_output.put_line('before Submitting request'||'Result'||l_result|| 'return status '||l_return_status);

Line 231: l_user_id :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'USER_ID' );

227: l_request_id := wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'REQUEST_ID' );
228: l_content_xml :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'CONTENT_XML' );
229: l_msg_count :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'MSG_COUNT' );
230: l_msg_data :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'MSG_DATA' );
231: l_user_id :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'USER_ID' );
232: l_result :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'RESULT' );
233: --l_return_status :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'RETURN_STATUS' );
234: --dbms_output.put_line('before Submitting request'||'Result'||l_result|| 'return status '||l_return_status);
235: --if l_return_status ='S' and l_result = 'SUCCESS' then

Line 232: l_result :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'RESULT' );

228: l_content_xml :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'CONTENT_XML' );
229: l_msg_count :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'MSG_COUNT' );
230: l_msg_data :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'MSG_DATA' );
231: l_user_id :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'USER_ID' );
232: l_result :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'RESULT' );
233: --l_return_status :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'RETURN_STATUS' );
234: --dbms_output.put_line('before Submitting request'||'Result'||l_result|| 'return status '||l_return_status);
235: --if l_return_status ='S' and l_result = 'SUCCESS' then
236: if l_result = 'SUCCESS' then

Line 233: --l_return_status :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'RETURN_STATUS' );

229: l_msg_count :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'MSG_COUNT' );
230: l_msg_data :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'MSG_DATA' );
231: l_user_id :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'USER_ID' );
232: l_result :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'RESULT' );
233: --l_return_status :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'RETURN_STATUS' );
234: --dbms_output.put_line('before Submitting request'||'Result'||l_result|| 'return status '||l_return_status);
235: --if l_return_status ='S' and l_result = 'SUCCESS' then
236: if l_result = 'SUCCESS' then
237: --dbms_output.put_line('entering submit request api');

Line 267: wf_engine.SetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'RESULT',avalue => resultout );

263: ELSE
264: resultout := 'COMPLETE:FAIL';
265: END IF;
266: end if ;
267: wf_engine.SetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'RESULT',avalue => resultout );
268: --dbms_output.put_line('Result out from submit_fulfill_request->'||resultout);
269: end if;
270: exception
271: when others then

Line 285: l_result :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'RESULT' );

281: l_result varchar2(100);
282: begin
283: IF funcmode = 'RUN' then
284: --dbms_output.put_line('Entered into check result node');
285: l_result :=wf_engine.GetItemAttrText( itemtype => itemtype, itemkey => itemkey, aname => 'RESULT' );
286: --dbms_output.put_line(l_result);
287: if l_result = 'COMPLETE:SUCCESS' then
288: resultout :='COMPLETE:SUCCESS';
289: else