DBA Data[Home] [Help]

APPS.IEX_WF_BAN_STATUS_PUB dependencies on IEX_STRATEGIES

Line 1571: from iex_strategies st

1567: p_disposition_code IN VARCHAR2)
1568: IS
1569: cursor c_get_strategy_id (l_bkrid number) is
1570: select st.strategy_id
1571: from iex_strategies st
1572: where st.status_code = 'OPEN'
1573: and st.jtf_object_type = 'IEX_BANKRUPTCY'
1574: and st.jtf_object_id = l_bkrid;
1575:

Line 1634: Update iex_strategies set status_code = 'CANCELLED'

1630: when others then
1631: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1632: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: In others exception');
1633: END IF;
1634: Update iex_strategies set status_code = 'CANCELLED'
1635: where strategy_id = l_startegy_id;
1636:
1637: update iex_strategy_work_items
1638: set status_code = 'CANCELLED'