[Home] [Help]
3726: x_include_sql OUT NOCOPY varchar2
3727: ) is
3728:
3729: ------------------------------------------------------------------------------
3730: -- Given the sql id from ams_list_select_actions it will retrieve the
3731: -- sql_srtings from ams_discoverer_sql for a particular worksheet_name and
3732: -- workbook_name.
3733: ------------------------------------------------------------------------------
3734: l_sql_string AMS_LISTGENERATION_PKG.sql_string;
4453:
4454:
4455: CURSOR c_select_actions(p_header_id IN number) IS
4456: SELECT LIST_SELECT_ACTION_ID
4457: FROM ams_list_select_actions WHERE action_used_by_id=p_header_id;
4458:
4459: CURSOR fetch_list_select_actions(p_header_id NUMBER) IS
4460: SELECT incl_object_id,rank,order_number,description,list_action_type
4461: ,no_of_rows_requested,no_of_rows_available,no_of_rows_used
4459: CURSOR fetch_list_select_actions(p_header_id NUMBER) IS
4460: SELECT incl_object_id,rank,order_number,description,list_action_type
4461: ,no_of_rows_requested,no_of_rows_available,no_of_rows_used
4462: ,distribution_pct,no_of_rows_targeted,incl_object_name,arc_incl_object_from,arc_action_used_by
4463: FROM ams_list_select_actions
4464: WHERE action_used_by_id =p_header_id
4465: order by order_number;
4466:
4467: l_return_status VARCHAR2(1);
4599: RAISE FND_API.g_exc_unexpected_error;
4600: END IF;
4601:
4602: -------------VBCHANGE--------------------
4603: UPDATE ams_list_select_actions SET incl_object_name = l_list_actions_rec.incl_object_name
4604: WHERE list_select_action_id = l_action_id;
4605: -------------- x_query_id := l_action_rec.incl_object_id;------------VBCHANGE---------
4606: IF (AMS_DEBUG_HIGH_ON) THEN
4607: AMS_Utility_PVT.debug_message('copy_selections done creation');