DBA Data[Home] [Help]

APPS.EDR_GENERAL_SUBS dependencies on WF_ENGINE

Line 53: l_event_name :=WF_ENGINE.GETITEMATTRTEXT(

49: l_no_approval_status VARCHAR2(20);
50: l_success_status VARCHAR2(20);
51: BEGIN
52: --Bug 4074173 : start
53: l_event_name :=WF_ENGINE.GETITEMATTRTEXT(
54: itemtype=>p_itemtype,
55: itemkey=>P_itemkey,
56: aname=>'EVENT_NAME');
57:

Line 58: l_event_key :=WF_ENGINE.GETITEMATTRTEXT(

54: itemtype=>p_itemtype,
55: itemkey=>P_itemkey,
56: aname=>'EVENT_NAME');
57:
58: l_event_key :=WF_ENGINE.GETITEMATTRTEXT(
59: itemtype=>p_itemtype,
60: itemkey=>P_itemkey,
61: aname=>'EVENT_KEY');
62:

Line 113: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'AUTHOR', l_author);

109:
110: --set the file author
111: EDR_FILE_UTIL_PUB.GET_AUTHOR_NAME(l_event_key, l_author);
112: wf_log_pkg.string(6, 'UPLOAD_XSL','author '||l_author);
113: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'AUTHOR', l_author);
114: wf_log_pkg.string(6, 'UPLOAD_XSL','author name set in the workflow');
115:
116: --set the file name
117: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'XSL_NAME', l_file_name);

Line 117: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'XSL_NAME', l_file_name);

113: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'AUTHOR', l_author);
114: wf_log_pkg.string(6, 'UPLOAD_XSL','author name set in the workflow');
115:
116: --set the file name
117: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'XSL_NAME', l_file_name);
118: wf_log_pkg.string(6, 'UPLOAD_XSL','file name set in the workflow');
119:
120: --set the version
121: EDR_FILE_UTIL_PUB.GET_VERSION_LABEL(l_event_key, l_version);

Line 124: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'VERSION', l_version);

120: --set the version
121: EDR_FILE_UTIL_PUB.GET_VERSION_LABEL(l_event_key, l_version);
122: l_version_num := l_version;
123: wf_log_pkg.string(6, 'UPLOAD_XSL','version num '||l_version_num);
124: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'VERSION', l_version);
125:
126:
127: --set the product name of the file owner product
128: EDR_FILE_UTIL_PUB.GET_ATTRIBUTE(l_event_key, 'ATTRIBUTE1', l_product);

Line 131: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'PRODUCT', l_product);

127: --set the product name of the file owner product
128: EDR_FILE_UTIL_PUB.GET_ATTRIBUTE(l_event_key, 'ATTRIBUTE1', l_product);
129: wf_log_pkg.string(6, 'UPLOAD_XSL','PRODUCT ' ||l_product);
130:
131: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'PRODUCT', l_product);
132:
133: --convert to lower case for upload to ecx repository
134: l_product := LOWER(l_product);
135:

Line 136: l_event_status := wf_engine.getitemattrtext(p_itemtype,p_itemkey,'FILE_STATUS');

132:
133: --convert to lower case for upload to ecx repository
134: l_product := LOWER(l_product);
135:
136: l_event_status := wf_engine.getitemattrtext(p_itemtype,p_itemkey,'FILE_STATUS');
137: wf_log_pkg.string(6, 'UPLOAD_XSL','event status' ||l_event_status);
138:
139:
140: --if the status is SUCCESS only then upload it to the database

Line 208: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'UPLOAD_STATUS', l_upload_status);

204: l_upload_status := fnd_message.get_string('EDR','EDR_FILES_XSL_FAILURE');
205: end if;
206: end if;
207:
208: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'UPLOAD_STATUS', l_upload_status);
209:
210: p_resultout := l_return_status;
211: END UPLOAD_STYLESHEET;
212: