DBA Data[Home] [Help]

APPS.IEX_WF_BAN_STATUS_PUB dependencies on IEX_STRATEGIES

Line 1297: from iex_strategies st

1293: p_disposition_code IN VARCHAR2)
1294: IS
1295: cursor c_get_strategy_id (l_bkrid number) is
1296: select st.strategy_id
1297: from iex_strategies st
1298: where st.status_code = 'OPEN'
1299: and st.jtf_object_type = 'IEX_BANKRUPTCY'
1300: and st.jtf_object_id = l_bkrid;
1301:

Line 1360: Update iex_strategies set status_code = 'CANCELLED'

1356: when others then
1357: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1358: IEX_DEBUG_PUB.logMessage('cancel_strategy_and_workflow: In others exception');
1359: END IF;
1360: Update iex_strategies set status_code = 'CANCELLED'
1361: where strategy_id = l_startegy_id;
1362:
1363: update iex_strategy_work_items
1364: set status_code = 'CANCELLED'