47: l_UName varchar2(50);
48: l_UProgram varchar2(50);
49: --commented out for bug 9929169
50: BEGIN
51: -- Standard Start of API savepoint
52: --SAVEPOINT LaunchProcess_PUB;
53: -- Standard call to check for call compatibility.
54: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
55: p_api_version_number,
49: --commented out for bug 9929169
50: BEGIN
51: -- Standard Start of API savepoint
52: --SAVEPOINT LaunchProcess_PUB;
53: -- Standard call to check for call compatibility.
54: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
55: p_api_version_number,
56: l_api_name,
57: G_PKG_NAME)
216: l_errret varchar2(100);
217: l_Error_Message VARCHAR2(2000);
218: l_call_status BOOLEAN;
219: BEGIN
220: -- Standard Start of API savepoint
221: SAVEPOINT ProcessRetry_PUB;
222: -- Standard call to check for call compatibility.
223: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
224: p_api_version_number,
218: l_call_status BOOLEAN;
219: BEGIN
220: -- Standard Start of API savepoint
221: SAVEPOINT ProcessRetry_PUB;
222: -- Standard call to check for call compatibility.
223: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
224: p_api_version_number,
225: l_api_name,
226: G_PKG_NAME)
267: l_return_status varchar2(10);
268: l_Error_Message VARCHAR2(2000);
269: l_msg_data varchar2(240);
270: BEGIN
271: -- Standard Start of API savepoint
272: SAVEPOINT StopWorkflow_PUB;
273: -- Standard call to check for call compatibility.
274: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
275: p_api_version_number,
269: l_msg_data varchar2(240);
270: BEGIN
271: -- Standard Start of API savepoint
272: SAVEPOINT StopWorkflow_PUB;
273: -- Standard call to check for call compatibility.
274: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
275: p_api_version_number,
276: l_api_name,
277: G_PKG_NAME)
332: where item_type=p_item_type
333: and activity_status = 'ERROR'
334: and begin_date<=to_date(p_end_date,'yyyy/mm/dd hh24:mi:ss');
335: BEGIN
336: -- Standard Start of API savepoint
337: SAVEPOINT PurgeWorkflow_PUB;
338: -- Standard call to check for call compatibility.
339: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
340: p_api_version_number,
334: and begin_date<=to_date(p_end_date,'yyyy/mm/dd hh24:mi:ss');
335: BEGIN
336: -- Standard Start of API savepoint
337: SAVEPOINT PurgeWorkflow_PUB;
338: -- Standard call to check for call compatibility.
339: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
340: p_api_version_number,
341: l_api_name,
342: G_PKG_NAME)