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 385: FROM iex_strategies

381: l_strategy_Rec.status_code := p_status;
382:
383: BEGIN
384: select object_version_number INTO l_object_version_number
385: FROM iex_strategies
386: where strategy_id =p_strategy_id;
387: EXCEPTION
388: WHEN NO_DATA_FOUND THEN
389: -- IF PG_DEBUG < 10 THEN

Line 563: FROM iex_strategies

559: l_strategy_Rec.status_code := p_status;
560:
561: BEGIN
562: select object_version_number INTO l_object_version_number
563: FROM iex_strategies
564: where strategy_id =p_strategy_id;
565: EXCEPTION
566: WHEN NO_DATA_FOUND THEN
567: -- IF PG_DEBUG < 10 THEN

Line 897: FROM iex_strategies

893: l_strategy_Rec.next_work_item_id := p_work_item_id;
894:
895: BEGIN
896: select object_version_number INTO l_object_version_number
897: FROM iex_strategies
898: where strategy_id =p_strategy_id;
899: EXCEPTION
900: WHEN NO_DATA_FOUND THEN
901: -- IF PG_DEBUG < 10 THEN

Line 1289: from iex_strategies strat,

1285: wkitem.creation_date start_time,
1286: wkitem.execute_end end_time, -- snuthala 28/08/2008 bug #6745580
1287: wkitem.work_item_order wkitem_order,
1288: wkitem.escalated_yn escalated_yn
1289: from iex_strategies strat,
1290: iex_strategy_work_items wkitem,
1291: iex_stry_temp_work_items_b stry_temp_wkitem
1292: where wkitem.work_item_id=p_work_item_id
1293: AND wkitem.strategy_id = strat.strategy_id

Line 1460: from iex_strategies

1456: l_status varchar2(100) ;
1457:
1458: cursor c_status(p_strategy_id IN NUMBER) is
1459: select status_code
1460: from iex_strategies
1461: where strategy_id = p_strategy_id ;
1462:
1463: cursor c_object(p_strategy_id IN NUMBER) is
1464: select delinquency_id,object_id,object_type

Line 1465: from iex_strategies

1461: where strategy_id = p_strategy_id ;
1462:
1463: cursor c_object(p_strategy_id IN NUMBER) is
1464: select delinquency_id,object_id,object_type
1465: from iex_strategies
1466: where strategy_id = p_strategy_id ;
1467:
1468: BEGIN
1469:

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

1605: -- and next work item is not the same as the updated work item
1606: -- then the send signal has been successful and it has created
1607: -- the next work item . other wise, the send signal failed.
1608: -- id send signal is successful, commit , else rollback
1609: select count(*) INTO v_result from iex_strategies
1610: where strategy_id =p_strategy_work_item_rec.strategy_id
1611: and next_work_item_id =p_strategy_work_item_rec.work_item_id
1612: and status_code ='OPEN';
1613: