[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;
12732: ) is
12733:
12734: ------------------------------------------------------------------------------
12735: -- Given the sql id from ams_list_select_actions it will retrieve the
12736: -- sql_srtings from ams_discoverer_sql for a particular worksheet_name and
12737: -- workbook_name.
12738: ------------------------------------------------------------------------------
12739: cursor cur_sql is
12740: SELECT query, primary_key, source_object_name
12880: ) is
12881:
12882: ------------------------------------------------------------------------------
12883: -- Given the sql id from ams_list_select_actions it will retrieve the
12884: -- sql_srtings from ams_discoverer_sql for a particular worksheet_name and
12885: -- workbook_name.
12886: ------------------------------------------------------------------------------
12887: l_sql_string sql_string;
12888: l_where_string sql_string;
12979: ) is
12980:
12981: ------------------------------------------------------------------------------
12982: -- Given the sql id from ams_list_select_actions it will retrieve the
12983: -- sql_srtings from ams_discoverer_sql for a particular worksheet_name and
12984: -- workbook_name.
12985: ------------------------------------------------------------------------------
12986: cursor cur_diwb(l_incl_object_id in number ) is
12987: SELECT sql_string
12984: -- workbook_name.
12985: ------------------------------------------------------------------------------
12986: cursor cur_diwb(l_incl_object_id in number ) is
12987: SELECT sql_string
12988: FROM ams_discoverer_sql
12989: WHERE (workbook_name, worksheet_name )
12990: IN
12991: ( SELECT workbook_name, worksheet_name
12992: FROM ams_discoverer_sql
12988: FROM ams_discoverer_sql
12989: WHERE (workbook_name, worksheet_name )
12990: IN
12991: ( SELECT workbook_name, worksheet_name
12992: FROM ams_discoverer_sql
12993: WHERE discoverer_sql_id = l_incl_object_id)
12994: ORDER BY sequence_order;
12995:
12996: l_sql_string sql_string;
13015: l_select_add_condition varchar2(2000);
13016: BEGIN
13017: write_to_act_log('Executing procedure process_run_total_diwb', 'LIST', g_list_header_id,'LOW');
13018:
13019: /* Populating l_sql_string with sql statements from ams_discoverer_sql
13020: l_sql_string is of table type of varchar2(2000)
13021: */
13022: open cur_diwb(p_incl_object_id);
13023: loop