eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_OBJ_ANALYSIS_OPTIONS_PUB dependencies on BSC_APPS

Line 1447: BSC_APPS.Execute_Immediate(l_sql);

1443: END IF;
1444: END IF;
1445:
1446: l_sql := 'DELETE FROM bsc_kpi_analysis_options_b ' || l_criteria;
1447: BSC_APPS.Execute_Immediate(l_sql);
1448:
1449: l_sql := 'DELETE FROM bsc_kpi_analysis_options_tl ' || l_criteria;
1450: BSC_APPS.Execute_Immediate(l_sql);
1451:

Line 1450: BSC_APPS.Execute_Immediate(l_sql);

1446: l_sql := 'DELETE FROM bsc_kpi_analysis_options_b ' || l_criteria;
1447: BSC_APPS.Execute_Immediate(l_sql);
1448:
1449: l_sql := 'DELETE FROM bsc_kpi_analysis_options_tl ' || l_criteria;
1450: BSC_APPS.Execute_Immediate(l_sql);
1451:
1452: OPEN c_Ana_Opt_Count;
1453: FETCH c_Ana_Opt_Count INTO l_Ana_Opt_Count;
1454: CLOSE c_Ana_Opt_Count;

Line 1600: BSC_APPS.Execute_Immediate(l_sql);

1596: END IF;
1597: END IF;
1598:
1599: l_sql := 'DELETE FROM bsc_kpi_analysis_measures_b ' || l_criteria;
1600: BSC_APPS.Execute_Immediate(l_sql);
1601:
1602: l_sql := 'DELETE FROM bsc_kpi_analysis_measures_tl ' || l_criteria;
1603: BSC_APPS.Execute_Immediate(l_sql);
1604:

Line 1603: BSC_APPS.Execute_Immediate(l_sql);

1599: l_sql := 'DELETE FROM bsc_kpi_analysis_measures_b ' || l_criteria;
1600: BSC_APPS.Execute_Immediate(l_sql);
1601:
1602: l_sql := 'DELETE FROM bsc_kpi_analysis_measures_tl ' || l_criteria;
1603: BSC_APPS.Execute_Immediate(l_sql);
1604:
1605: BSC_ANALYSIS_OPTION_PUB.Cascade_Deletion_Color_Props (
1606: p_commit => p_commit
1607: ,p_Anal_Opt_Rec => p_Anal_Opt_Rec

Line 1618: BSC_APPS.Execute_Immediate(l_sql);

1614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1615: END IF;
1616:
1617: l_sql := 'DELETE FROM bsc_kpi_subtitles_tl ' || l_criteria;
1618: BSC_APPS.Execute_Immediate(l_sql);
1619:
1620: IF FND_API.To_Boolean( p_commit ) THEN
1621: COMMIT;
1622: END IF;

Line 1707: BSC_APPS.Execute_Immediate(l_sql);

1703:
1704: IF l_option_id <> l_cur_index THEN
1705: l_sql := 'UPDATE bsc_kpi_analysis_measures_b SET analysis_option'|| p_Anal_Opt_Rec.Bsc_Analysis_Group_Id || '=' || l_cur_index;
1706: l_sql := l_sql || l_criteria_measures;
1707: BSC_APPS.Execute_Immediate(l_sql);
1708:
1709: l_sql := 'UPDATE bsc_kpi_analysis_measures_tl SET analysis_option'|| p_Anal_Opt_Rec.Bsc_Analysis_Group_Id || '=' || l_cur_index;
1710: l_sql := l_sql || l_criteria_measures;
1711: BSC_APPS.Execute_Immediate(l_sql);

Line 1711: BSC_APPS.Execute_Immediate(l_sql);

1707: BSC_APPS.Execute_Immediate(l_sql);
1708:
1709: l_sql := 'UPDATE bsc_kpi_analysis_measures_tl SET analysis_option'|| p_Anal_Opt_Rec.Bsc_Analysis_Group_Id || '=' || l_cur_index;
1710: l_sql := l_sql || l_criteria_measures;
1711: BSC_APPS.Execute_Immediate(l_sql);
1712:
1713: l_sql := 'UPDATE bsc_kpi_subtitles_tl SET analysis_option'|| p_Anal_Opt_Rec.Bsc_Analysis_Group_Id || '=' || l_cur_index;
1714: l_sql := l_sql || l_criteria_measures;
1715: BSC_APPS.Execute_Immediate(l_sql);

Line 1715: BSC_APPS.Execute_Immediate(l_sql);

1711: BSC_APPS.Execute_Immediate(l_sql);
1712:
1713: l_sql := 'UPDATE bsc_kpi_subtitles_tl SET analysis_option'|| p_Anal_Opt_Rec.Bsc_Analysis_Group_Id || '=' || l_cur_index;
1714: l_sql := l_sql || l_criteria_measures;
1715: BSC_APPS.Execute_Immediate(l_sql);
1716:
1717: l_sql := 'UPDATE bsc_kpi_analysis_options_b SET option_id='|| l_cur_index;
1718: l_sql := l_sql || l_criteria_options || ' AND option_id = ' || l_option_id;
1719: BSC_APPS.Execute_Immediate(l_sql);

Line 1719: BSC_APPS.Execute_Immediate(l_sql);

1715: BSC_APPS.Execute_Immediate(l_sql);
1716:
1717: l_sql := 'UPDATE bsc_kpi_analysis_options_b SET option_id='|| l_cur_index;
1718: l_sql := l_sql || l_criteria_options || ' AND option_id = ' || l_option_id;
1719: BSC_APPS.Execute_Immediate(l_sql);
1720:
1721: l_sql := 'UPDATE bsc_kpi_analysis_options_tl SET option_id='|| l_cur_index;
1722: l_sql := l_sql || l_criteria_options || ' AND option_id = ' || l_option_id;
1723: BSC_APPS.Execute_Immediate(l_sql);

Line 1723: BSC_APPS.Execute_Immediate(l_sql);

1719: BSC_APPS.Execute_Immediate(l_sql);
1720:
1721: l_sql := 'UPDATE bsc_kpi_analysis_options_tl SET option_id='|| l_cur_index;
1722: l_sql := l_sql || l_criteria_options || ' AND option_id = ' || l_option_id;
1723: BSC_APPS.Execute_Immediate(l_sql);
1724:
1725: OPEN c_Max_Groups;
1726: FETCH c_Max_Groups INTO l_max_groups;
1727: CLOSE c_Max_Groups;

Line 1736: BSC_APPS.Execute_Immediate(l_sql);

1732: l_criteria_parent := l_criteria_parent || ' AND analysis_group_id = ' || (p_Anal_Opt_Rec.Bsc_Analysis_Group_Id + 1) ||' AND parent_option_id = ' || l_option_id;
1733:
1734: l_sql := 'UPDATE bsc_kpi_analysis_options_b SET parent_option_id = '|| l_cur_index ;
1735: l_sql := l_sql || l_criteria_parent;
1736: BSC_APPS.Execute_Immediate(l_sql);
1737:
1738: l_sql := 'UPDATE bsc_kpi_analysis_options_tl SET parent_option_id = '|| l_cur_index ;
1739: l_sql := l_sql || l_criteria_parent;
1740: BSC_APPS.Execute_Immediate(l_sql);

Line 1740: BSC_APPS.Execute_Immediate(l_sql);

1736: BSC_APPS.Execute_Immediate(l_sql);
1737:
1738: l_sql := 'UPDATE bsc_kpi_analysis_options_tl SET parent_option_id = '|| l_cur_index ;
1739: l_sql := l_sql || l_criteria_parent;
1740: BSC_APPS.Execute_Immediate(l_sql);
1741:
1742: END IF;
1743:
1744: IF (p_Anal_Opt_Rec.Bsc_Analysis_Group_Id + 2 <= l_max_groups) THEN

Line 1751: BSC_APPS.Execute_Immediate(l_sql);

1747: l_criteria_parent := l_criteria_parent || ' AND analysis_group_id = ' || (p_Anal_Opt_Rec.Bsc_Analysis_Group_Id + 1) ||' AND grandparent_option_id = ' || l_option_id;
1748:
1749: l_sql := 'UPDATE bsc_kpi_analysis_options_b SET grandparent_option_id = '|| l_cur_index ;
1750: l_sql := l_sql || l_criteria_parent;
1751: BSC_APPS.Execute_Immediate(l_sql);
1752:
1753: l_sql := 'UPDATE bsc_kpi_analysis_options_tl SET grandparent_option_id = '|| l_cur_index ;
1754: l_sql := l_sql || l_criteria_parent;
1755: BSC_APPS.Execute_Immediate(l_sql);

Line 1755: BSC_APPS.Execute_Immediate(l_sql);

1751: BSC_APPS.Execute_Immediate(l_sql);
1752:
1753: l_sql := 'UPDATE bsc_kpi_analysis_options_tl SET grandparent_option_id = '|| l_cur_index ;
1754: l_sql := l_sql || l_criteria_parent;
1755: BSC_APPS.Execute_Immediate(l_sql);
1756: END IF;
1757: END IF;
1758: l_cur_index := l_cur_index + 1;
1759: end loop;