APPS.IEX_STRY_CHECKLIST_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 53

      select sxref.strategy_temp_id TEMPLATE_ID,
          sxref.WORK_ITEM_TEMP_ID WORK_ITEM_TEMPLATE_ID,
          sxref.work_item_order ORDER_BY
       from iex_strategy_work_temp_xref sxref
       where sxref.strategy_temp_id = p_template_id;

Line: 59

    c_StrategySelect varchar2(1000) :=
	    ' select s.delinquency_id, ' ||
        ' s.object_id object_id, s.object_type object_type , s.object_version_number, ' ||
        ' t.check_list_temp_id ' ||
    	' from iex_strategies s, iex_strategy_templates_b t where ' ||
        ' s.strategy_id  = :pObjectID and s.strategy_template_id = t.strategy_temp_id ' ;

Line: 103

        IEX_DEBUG_PUB.LogMessage( debug_msg => c_StrategySelect || ' Start', print_date => 'Y');

Line: 106

        Execute Immediate c_StrategySelect into
                fDelinquencyID,  fObjectID,
                fObjectType, fStrategyVersionNumber, fCheckListTemplateID using  p_StrategyID;

Line: 288

    iex_debug_pub.logmessage( debug_msg => '2. Update Main Strategy ', print_date => 'Y');

Line: 291

    IEX_DEBUG_PUB.LogMessage('2. Update Main Strategy ');

Line: 293

    iex_strategy_pvt.update_strategy(
                P_Api_Version_Number=>2.0,
                p_commit =>  FND_API.G_FALSE,
                P_Init_Msg_List     =>FND_API.G_FALSE,
                p_strategy_rec => l_strategy2_rec,
                x_return_status=>l_return_status,
                x_msg_count=>l_msg_count,
                x_msg_data=>l_msg_data,
                xo_object_version_number => l_object_version_number
        );