APPS.IEX_STRY_UTL_PUB dependencies on IEX_STRATEGIES

Line 99: FROM iex_strategies

95: x_work_item_tab OUT NOCOPY work_item_tab_type) IS
96:
97: CURSOR c_get_strategy_template_id(c_strategy_id NUMBER) IS
98: SELECT strategy_template_id
99: FROM iex_strategies
100: WHERE strategy_id =c_strategy_id;
101:
102:
103: CURSOR c_get_work_items(c_strategy_id NUMBER, c_template_id NUMBER) IS

Line 379: FROM iex_strategies

375: l_strategy_Rec.status_code := p_status;
376:
377: BEGIN
378: select object_version_number INTO l_object_version_number
379: FROM iex_strategies
380: where strategy_id =p_strategy_id;
381: EXCEPTION
382: WHEN NO_DATA_FOUND THEN
383: -- IF PG_DEBUG < 10 THEN

Line 557: FROM iex_strategies

553: l_strategy_Rec.status_code := p_status;
554:
555: BEGIN
556: select object_version_number INTO l_object_version_number
557: FROM iex_strategies
558: where strategy_id =p_strategy_id;
559: EXCEPTION
560: WHEN NO_DATA_FOUND THEN
561: -- IF PG_DEBUG < 10 THEN

Line 891: FROM iex_strategies

887: l_strategy_Rec.next_work_item_id := p_work_item_id;
888:
889: BEGIN
890: select object_version_number INTO l_object_version_number
891: FROM iex_strategies
892: where strategy_id =p_strategy_id;
893: EXCEPTION
894: WHEN NO_DATA_FOUND THEN
895: -- IF PG_DEBUG < 10 THEN

Line 1279: from iex_strategies strat,

1275: wkitem.creation_date start_time,
1276: wkitem.execute_end end_time, -- snuthala 28/08/2008 bug #6745580
1277: wkitem.work_item_order wkitem_order,
1278: wkitem.escalated_yn escalated_yn
1279: from iex_strategies strat,
1280: iex_strategy_work_items wkitem,
1281: iex_stry_temp_work_items_b stry_temp_wkitem
1282: where wkitem.work_item_id=p_work_item_id
1283: AND wkitem.strategy_id = strat.strategy_id

Line 1441: from iex_strategies

1437: l_status varchar2(100) ;
1438:
1439: cursor c_status(p_strategy_id IN NUMBER) is
1440: select status_code
1441: from iex_strategies
1442: where strategy_id = p_strategy_id ;
1443:
1444: cursor c_object(p_strategy_id IN NUMBER) is
1445: select delinquency_id,object_id,object_type

Line 1446: from iex_strategies

1442: where strategy_id = p_strategy_id ;
1443:
1444: cursor c_object(p_strategy_id IN NUMBER) is
1445: select delinquency_id,object_id,object_type
1446: from iex_strategies
1447: where strategy_id = p_strategy_id ;
1448:
1449: BEGIN
1450:

Line 1590: select count(*) INTO v_result from iex_strategies

1586: -- and next work item is not the same as the updated work item
1587: -- then the send signal has been successful and it has created
1588: -- the next work item . other wise, the send signal failed.
1589: -- id send signal is successful, commit , else rollback
1590: select count(*) INTO v_result from iex_strategies
1591: where strategy_id =p_strategy_work_item_rec.strategy_id
1592: and next_work_item_id =p_strategy_work_item_rec.work_item_id
1593: and status_code ='OPEN';
1594: