23: IS
24: l_api_name CONSTANT VARCHAR2(30) := 'Create_strategy';
25: l_api_version_number CONSTANT NUMBER := 2.0;
26: l_return_status_full VARCHAR2(1);
27: v_strategy_id iex_strategies.strategy_id%TYPE;
28: v_object_version_number iex_strategies.object_version_number%TYPE;
29: v_rowid VARCHAR2(24);
30: v_strategy_level iex_strategies.strategy_level%TYPE;
31:
26: l_return_status_full VARCHAR2(1);
27: v_strategy_id iex_strategies.strategy_id%TYPE;
28: v_object_version_number iex_strategies.object_version_number%TYPE;
29: v_rowid VARCHAR2(24);
30: v_strategy_level iex_strategies.strategy_level%TYPE;
31:
32:
33: Cursor c2 is SELECT IEX_STRATEGIES_S.nextval from dual;
34: Cursor c3 is SELECT strategy_level from iex_strategy_templates_b
29: v_rowid VARCHAR2(24);
30: v_strategy_level iex_strategies.strategy_level%TYPE;
31:
32:
33: Cursor c2 is SELECT IEX_STRATEGIES_S.nextval from dual;
34: Cursor c3 is SELECT strategy_level from iex_strategy_templates_b
35: where strategy_temp_id = p_STRATEGY_rec.STRATEGY_TEMPLATE_ID;
36: BEGIN
37: