APPS.IEX_STRY_API_PUB dependencies on IEX_STRATEGY_WORK_ITEMS

Line 296: iex_strategy_work_items_pvt.strategy_work_item_Rec_Type,

292: * if send signal fails, roolback the work item
293: **/
294:
295: PROCEDURE UPDATE_AND_SENDSIGNAL( P_strategy_work_item_Rec IN
296: iex_strategy_work_items_pvt.strategy_work_item_Rec_Type,
297: p_commit IN VARCHAR2,
298: x_return_status OUT NOCOPY VARCHAR2,
299: x_msg_count OUT NOCOPY NUMBER,
300: x_msg_data OUT NOCOPY VARCHAR2)IS

Line 316: select status_code INTO l_status_code from iex_strategy_work_items

312:
313: x_return_status := FND_API.G_RET_STS_SUCCESS;
314:
315: begin
316: select status_code INTO l_status_code from iex_strategy_work_items
317: where strategy_id = p_strategy_work_item_rec.strategy_id
318: and work_item_id = p_strategy_work_item_rec.work_item_id;
319:
320: if (l_status_code not in ('OPEN', 'ONHOLD','PRE-WAIT')) then --Added PRE-WAIT for bug#5474793 by schekuri on 21-Aug-2006

Line 337: iex_strategy_work_items_pvt.update_strategy_work_items(

333: end if;
334: return;
335: end;
336:
337: iex_strategy_work_items_pvt.update_strategy_work_items(
338: p_api_version_number => 2.0,
339: p_init_msg_list => FND_API.G_TRUE,
340: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
341: p_commit => p_commit,

Line 435: IEX_STRATEGY_WORK_ITEMS_PVT.STRATEGY_WORK_ITEM_REC_TYPE;

431: l_status varchar2(1) ;
432: l_version_number NUMBER;
433: v_result NUMBER;
434: l_strategy_work_item_rec
435: IEX_STRATEGY_WORK_ITEMS_PVT.STRATEGY_WORK_ITEM_REC_TYPE;
436: l_strategy_id number ;
437:
438: cursor c_work_item(p_work_item_id NUMBER) is
439: select object_version_number,strategy_id

Line 440: from iex_strategy_work_items

436: l_strategy_id number ;
437:
438: cursor c_work_item(p_work_item_id NUMBER) is
439: select object_version_number,strategy_id
440: from iex_strategy_work_items
441: where work_item_id = p_work_item_id ;
442:
443: BEGIN
444: -- IF PG_DEBUG < 10 THEN

Line 467: iex_strategy_work_items_pvt.update_strategy_work_items(

463: -- IF PG_DEBUG < 10 THEN
464: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
465: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'BEFORE CALLING UPDATE WORK ITEM PVT');
466: END IF;
467: iex_strategy_work_items_pvt.update_strategy_work_items(
468: p_api_version_number => 2.0,
469: p_init_msg_list => FND_API.G_TRUE,
470: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
471: p_commit => FND_API.G_FALSE,

Line 692: IEX_STRATEGY_WORK_ITEMS_PVT.STRATEGY_WORK_ITEM_REC_TYPE;

688: l_status varchar2(1) ;
689: l_version_number NUMBER;
690: v_result NUMBER;
691: l_strategy_work_item_rec
692: IEX_STRATEGY_WORK_ITEMS_PVT.STRATEGY_WORK_ITEM_REC_TYPE;
693: l_strategy_id number ;
694:
695: cursor c_work_item(p_work_item_id NUMBER) is
696: select object_version_number,strategy_id

Line 697: from iex_strategy_work_items

693: l_strategy_id number ;
694:
695: cursor c_work_item(p_work_item_id NUMBER) is
696: select object_version_number,strategy_id
697: from iex_strategy_work_items
698: where work_item_id = p_work_item_id ;
699:
700: BEGIN
701: -- IF PG_DEBUG < 10 THEN

Line 724: iex_strategy_work_items_pvt.update_strategy_work_items(

720: -- IF PG_DEBUG < 10 THEN
721: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
722: IEX_DEBUG_PUB.logmessage('UPDATE_WORKITEM: ' || 'BEFORE CALLING UPDATE WORK ITEM PVT');
723: END IF;
724: iex_strategy_work_items_pvt.update_strategy_work_items(
725: p_api_version_number => 2.0,
726: p_init_msg_list => FND_API.G_TRUE,
727: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
728: p_commit => FND_API.G_FALSE,

Line 898: UPDATE iex_strategy_work_items

894: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': l_uwq_complete_date: ' || l_uwq_complete_date);
895: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': updating promise details...');
896: END IF;
897: FORALL i in 1..nCount
898: UPDATE iex_strategy_work_items
899: SET uwq_status = p_uwq_status,
900: uwq_active_date = l_uwq_active_date,
901: uwq_complete_date = l_uwq_complete_date,
902: last_update_date = sysdate,