[Home] [Help]
3445: ) is
3446:
3447: ------------------------------------------------------------------------------
3448: -- Given the sql id from ams_list_select_actions it will retrieve the
3449: -- sql_srtings from ams_discoverer_sql for a particular worksheet_name and
3450: -- workbook_name.
3451: ------------------------------------------------------------------------------
3452: cursor cur_sql is
3453: SELECT query,primary_key, source_object_name
3591: ) is
3592:
3593: ------------------------------------------------------------------------------
3594: -- Given the sql id from ams_list_select_actions it will retrieve the
3595: -- sql_srtings from ams_discoverer_sql for a particular worksheet_name and
3596: -- workbook_name.
3597: ------------------------------------------------------------------------------
3598: --bmuthukr 4351740. this cursor should be used to pick the disc sql
3599: --since sql could be stored in more than one record this reqd.
3598: --bmuthukr 4351740. this cursor should be used to pick the disc sql
3599: --since sql could be stored in more than one record this reqd.
3600: cursor cur_diwb(l_incl_object_id in number ) is
3601: SELECT sql_string
3602: FROM ams_discoverer_sql
3603: WHERE (workbook_name, worksheet_name )
3604: IN
3605: ( SELECT workbook_name, worksheet_name
3606: FROM ams_discoverer_sql
3602: FROM ams_discoverer_sql
3603: WHERE (workbook_name, worksheet_name )
3604: IN
3605: ( SELECT workbook_name, worksheet_name
3606: FROM ams_discoverer_sql
3607: WHERE discoverer_sql_id = l_incl_object_id)
3608: ORDER BY sequence_order;
3609:
3610: l_sql_string sql_string;
3629: l_select_add_condition varchar2(2000);
3630: BEGIN
3631: write_to_act_log('Executing process_diwb since workbook has been included in list/target group selections.', 'LIST', g_list_header_id,'LOW');
3632:
3633: /* Populating l_sql_string with sql statements from ams_discoverer_sql
3634: l_sql_string is of table type of varchar2(2000)
3635: */
3636: open cur_diwb(p_incl_object_id);
3637: loop
3657: --
3658: l_counter := l_counter +1 ;
3659: end loop;
3660: close cur_diwb;
3661: write_to_act_log('Passing sql from ams_discoverer sql for this workbook to process_all_sql procedure', 'LIST', g_list_header_id,'LOW');
3662: process_all_sql(p_action_used_by_id => p_action_used_by_id ,
3663: p_incl_object_id => p_incl_object_id ,
3664: p_list_action_type => p_list_action_type ,
3665: p_list_select_action_id => p_list_select_action_id ,
3694: ) is
3695:
3696: ------------------------------------------------------------------------------
3697: -- Given the sql id from ams_list_select_actions it will retrieve the
3698: -- sql_srtings from ams_discoverer_sql for a particular worksheet_name and
3699: -- workbook_name.
3700: ------------------------------------------------------------------------------
3701: l_sql_string sql_string;
3702: l_where_string sql_string;
12631: ) is
12632:
12633: ------------------------------------------------------------------------------
12634: -- Given the sql id from ams_list_select_actions it will retrieve the
12635: -- sql_srtings from ams_discoverer_sql for a particular worksheet_name and
12636: -- workbook_name.
12637: ------------------------------------------------------------------------------
12638: cursor cur_sql is
12639: SELECT query, primary_key, source_object_name
12779: ) is
12780:
12781: ------------------------------------------------------------------------------
12782: -- Given the sql id from ams_list_select_actions it will retrieve the
12783: -- sql_srtings from ams_discoverer_sql for a particular worksheet_name and
12784: -- workbook_name.
12785: ------------------------------------------------------------------------------
12786: l_sql_string sql_string;
12787: l_where_string sql_string;
12878: ) is
12879:
12880: ------------------------------------------------------------------------------
12881: -- Given the sql id from ams_list_select_actions it will retrieve the
12882: -- sql_srtings from ams_discoverer_sql for a particular worksheet_name and
12883: -- workbook_name.
12884: ------------------------------------------------------------------------------
12885: cursor cur_diwb(l_incl_object_id in number ) is
12886: SELECT sql_string
12883: -- workbook_name.
12884: ------------------------------------------------------------------------------
12885: cursor cur_diwb(l_incl_object_id in number ) is
12886: SELECT sql_string
12887: FROM ams_discoverer_sql
12888: WHERE (workbook_name, worksheet_name )
12889: IN
12890: ( SELECT workbook_name, worksheet_name
12891: FROM ams_discoverer_sql
12887: FROM ams_discoverer_sql
12888: WHERE (workbook_name, worksheet_name )
12889: IN
12890: ( SELECT workbook_name, worksheet_name
12891: FROM ams_discoverer_sql
12892: WHERE discoverer_sql_id = l_incl_object_id)
12893: ORDER BY sequence_order;
12894:
12895: l_sql_string sql_string;
12914: l_select_add_condition varchar2(2000);
12915: BEGIN
12916: write_to_act_log('Executing procedure process_run_total_diwb', 'LIST', g_list_header_id,'LOW');
12917:
12918: /* Populating l_sql_string with sql statements from ams_discoverer_sql
12919: l_sql_string is of table type of varchar2(2000)
12920: */
12921: open cur_diwb(p_incl_object_id);
12922: loop