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_ANALYSIS_OPTION_PVT dependencies on BSC_KPI_ANALYSIS_OPTIONS_TL

Line 23: | changed BSC_KPI_ANALYSIS_OPTIONS_TL to |

19: | This package creates a BSC Analysis Option. |
20: | |
21: | History: |
22: | 05-MAR-2003 ADEULGAO fixed MLS issue bug#2721899 |
23: | changed BSC_KPI_ANALYSIS_OPTIONS_TL to |
24: | BSC_KPI_ANALYSIS_OPTIONS_VL in select statement |
25: | 13-MAY-2003 PWALI Bug #2942895, SQL BIND COMPLIANCE |
26: | |
27: | 08-SEP-2003 kyadamak FIX THE BUG 3124010 |

Line 514: UPDATE BSC_KPI_ANALYSIS_OPTIONS_TL

510: WHERE Indicator = p_Kpi_Id
511: AND Analysis_Group_ID = p_group_Id
512: AND Option_Id = cd.Option_Id;
513:
514: UPDATE BSC_KPI_ANALYSIS_OPTIONS_TL
515: SET Option_ID = l_Count
516: WHERE Indicator = p_Kpi_Id
517: AND Analysis_Group_ID = p_group_Id
518: AND Option_Id = cd.Option_Id;

Line 534: UPDATE BSC_KPI_ANALYSIS_OPTIONS_TL

530: WHERE Indicator = p_Kpi_Id
531: AND Analysis_Group_ID = 2
532: AND Parent_Option_Id = ck.Parent_Option_Id;
533:
534: UPDATE BSC_KPI_ANALYSIS_OPTIONS_TL
535: SET parent_option_id = l_Count
536: WHERE Indicator = p_Kpi_Id
537: AND Analysis_Group_ID = 2
538: AND Parent_Option_Id = ck.Parent_Option_Id;

Line 548: UPDATE BSC_KPI_ANALYSIS_OPTIONS_TL

544: WHERE Indicator = p_Kpi_Id
545: AND Analysis_Group_ID = 2
546: AND Grandparent_Option_Id = cn1.GrandParent_Option_Id;
547:
548: UPDATE BSC_KPI_ANALYSIS_OPTIONS_TL
549: SET Grandparent_Option_Id = l_Count
550: WHERE Indicator = p_Kpi_Id
551: AND Analysis_Group_ID = 2
552: AND Grandparent_Option_Id = cn1.GrandParent_Option_Id;

Line 616: UPDATE BSC_KPI_ANALYSIS_OPTIONS_TL

612: AND Analysis_Group_ID = p_Group_Id
613: AND parent_option_id = p_Parent_Option_Id
614: AND Grandparent_Option_Id = p_Grand_Parent_Option_Id;
615:
616: UPDATE BSC_KPI_ANALYSIS_OPTIONS_TL
617: SET Option_ID = l_Count
618: WHERE Indicator = p_Kpi_Id
619: AND Analysis_Group_ID = p_group_Id
620: AND Option_Id = cd.Option_Id

Line 632: UPDATE BSC_KPI_ANALYSIS_OPTIONS_TL

628: WHERE Indicator = p_Kpi_Id
629: AND Analysis_Group_ID = 1
630: AND Parent_Option_Id = cm.Parent_Option_Id;
631:
632: UPDATE BSC_KPI_ANALYSIS_OPTIONS_TL
633: SET parent_option_id = l_Count
634: WHERE Indicator = p_Kpi_Id
635: AND Analysis_Group_ID = 1
636: AND Parent_Option_Id = cm.Parent_Option_Id;

Line 645: UPDATE BSC_KPI_ANALYSIS_OPTIONS_TL

641: WHERE Indicator = p_Kpi_Id
642: AND Analysis_Group_ID = 2
643: AND Parent_Option_Id = ck.Parent_Option_Id;
644:
645: UPDATE BSC_KPI_ANALYSIS_OPTIONS_TL
646: SET parent_option_id = l_Count
647: WHERE Indicator = p_Kpi_Id
648: AND Analysis_Group_ID = 2
649: AND Parent_Option_Id = ck.Parent_Option_Id;

Line 658: UPDATE BSC_KPI_ANALYSIS_OPTIONS_TL

654: WHERE Indicator = p_Kpi_Id
655: AND Analysis_Group_ID = 2
656: AND Grandparent_Option_Id = cn1.GrandParent_Option_Id;
657:
658: UPDATE BSC_KPI_ANALYSIS_OPTIONS_TL
659: SET Grandparent_Option_Id = l_Count
660: WHERE Indicator = p_Kpi_Id
661: AND Analysis_Group_ID = 2
662: AND Grandparent_Option_Id = cn1.GrandParent_Option_Id;

Line 673: UPDATE BSC_KPI_ANALYSIS_OPTIONS_TL

669: AND Analysis_Group_ID = p_Group_Id
670: AND parent_option_id = p_Parent_Option_Id
671: AND Grandparent_Option_Id = p_Grand_Parent_Option_Id;
672:
673: UPDATE BSC_KPI_ANALYSIS_OPTIONS_TL
674: SET Option_ID = l_Count
675: WHERE Indicator = p_Kpi_Id
676: AND Analysis_Group_ID = p_group_Id
677: AND Option_Id = cd.Option_Id

Line 689: UPDATE BSC_KPI_ANALYSIS_OPTIONS_TL

685: WHERE Indicator = p_Kpi_Id
686: AND Analysis_Group_ID = 1
687: AND parent_option_id = cm.Parent_Option_Id;
688:
689: UPDATE BSC_KPI_ANALYSIS_OPTIONS_TL
690: SET parent_option_id = l_Count
691: WHERE Indicator = p_Kpi_Id
692: AND Analysis_Group_ID = 1
693: AND parent_option_id = cm.Parent_Option_Id;

Line 704: UPDATE BSC_KPI_ANALYSIS_OPTIONS_TL

700: AND Analysis_Group_ID = p_Group_Id
701: AND parent_option_id = p_Parent_Option_Id
702: AND Grandparent_Option_Id = p_Grand_Parent_Option_Id;
703:
704: UPDATE BSC_KPI_ANALYSIS_OPTIONS_TL
705: SET Option_ID = l_Count
706: WHERE Indicator = p_Kpi_Id
707: AND Analysis_Group_ID = p_group_Id
708: AND Option_Id = cd.Option_Id

Line 841: g_db_object := 'BSC_KPI_ANALYSIS_OPTIONS_TL';

837: ,p_Anal_Opt_Rec.Bsc_User_Level2
838: ,p_Anal_Opt_Rec.Bsc_User_Level2_Default
839: ,p_Anal_Opt_Rec.Bsc_Option_Short_Name);
840:
841: g_db_object := 'BSC_KPI_ANALYSIS_OPTIONS_TL';
842:
843: -- Insert pertaining values into table bsc_kpi_analysis_options_tl.
844: INSERT INTO BSC_KPI_ANALYSIS_OPTIONS_TL( INDICATOR
845: ,ANALYSIS_GROUP_ID

Line 843: -- Insert pertaining values into table bsc_kpi_analysis_options_tl.

839: ,p_Anal_Opt_Rec.Bsc_Option_Short_Name);
840:
841: g_db_object := 'BSC_KPI_ANALYSIS_OPTIONS_TL';
842:
843: -- Insert pertaining values into table bsc_kpi_analysis_options_tl.
844: INSERT INTO BSC_KPI_ANALYSIS_OPTIONS_TL( INDICATOR
845: ,ANALYSIS_GROUP_ID
846: ,OPTION_ID
847: ,PARENT_OPTION_ID

Line 844: INSERT INTO BSC_KPI_ANALYSIS_OPTIONS_TL( INDICATOR

840:
841: g_db_object := 'BSC_KPI_ANALYSIS_OPTIONS_TL';
842:
843: -- Insert pertaining values into table bsc_kpi_analysis_options_tl.
844: INSERT INTO BSC_KPI_ANALYSIS_OPTIONS_TL( INDICATOR
845: ,ANALYSIS_GROUP_ID
846: ,OPTION_ID
847: ,PARENT_OPTION_ID
848: ,GRANDPARENT_OPTION_ID

Line 866: from BSC_KPI_ANALYSIS_OPTIONS_TL T

862: from FND_LANGUAGES L
863: where L.INSTALLED_FLAG in ('I', 'B')
864: and not exists
865: (select NULL
866: from BSC_KPI_ANALYSIS_OPTIONS_TL T
867: where T.indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
868: and T.analysis_group_id = p_Anal_Opt_Rec.Bsc_Analysis_Group_Id
869: and T.option_id = p_Anal_Opt_Rec.Bsc_Analysis_Option_Id
870: and T.parent_option_id = p_Anal_Opt_Rec.Bsc_Parent_Option_Id

Line 1189: update BSC_KPI_ANALYSIS_OPTIONS_TL

1185: and analysis_group_id = p_Anal_Opt_Rec.Bsc_Analysis_Group_Id
1186: and option_Id = p_Anal_Opt_Rec.Bsc_Analysis_Option_Id
1187: and parent_option_id = p_Anal_Opt_Rec.Bsc_Parent_Option_Id;
1188:
1189: update BSC_KPI_ANALYSIS_OPTIONS_TL
1190: set name = l_Anal_Opt_Rec.Bsc_Option_Name
1191: ,help = l_Anal_Opt_Rec.Bsc_Option_Help
1192: ,source_lang = userenv('LANG')
1193: where indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id

Line 1216: update BSC_KPI_ANALYSIS_OPTIONS_TL

1212: and option_Id = p_Anal_Opt_Rec.Bsc_Analysis_Option_Id
1213: and parent_option_id = p_Anal_Opt_Rec.Bsc_Parent_Option_Id
1214: and grandparent_option_id = p_Anal_Opt_Rec.Bsc_Grandparent_Option_Id;
1215:
1216: update BSC_KPI_ANALYSIS_OPTIONS_TL
1217: set name = l_Anal_Opt_Rec.Bsc_Option_Name
1218: ,help = l_Anal_Opt_Rec.Bsc_Option_Help
1219: ,source_lang = userenv('LANG')
1220: where indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id

Line 1241: update BSC_KPI_ANALYSIS_OPTIONS_TL

1237: where indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
1238: and analysis_group_id = p_Anal_Opt_Rec.Bsc_Analysis_Group_Id
1239: and option_Id = p_Anal_Opt_Rec.Bsc_Analysis_Option_Id;
1240:
1241: update BSC_KPI_ANALYSIS_OPTIONS_TL
1242: set name = l_Anal_Opt_Rec.Bsc_Option_Name
1243: ,help = l_Anal_Opt_Rec.Bsc_Option_Help
1244: ,source_lang = userenv('LANG')
1245: where indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id

Line 1413: DELETE FROM BSC_KPI_ANALYSIS_OPTIONS_TL

1409: AND option_id = l_Anal_Opt_Rec.Bsc_Analysis_Option_Id
1410: AND parent_option_id = l_Anal_Opt_Rec.Bsc_Parent_Option_Id
1411: AND grandparent_option_id = l_Anal_Opt_Rec.Bsc_Grandparent_Option_Id;
1412:
1413: DELETE FROM BSC_KPI_ANALYSIS_OPTIONS_TL
1414: WHERE indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
1415: AND analysis_group_id = NVL(l_Anal_Opt_Rec.Bsc_Analysis_Group_Id, 2)
1416: AND option_id = l_Anal_Opt_Rec.Bsc_Analysis_Option_Id
1417: AND parent_option_id = l_Anal_Opt_Rec.Bsc_Parent_Option_Id

Line 1428: DELETE FROM BSC_KPI_ANALYSIS_OPTIONS_TL

1424: AND analysis_group_id = NVL(l_Anal_Opt_Rec.Bsc_Analysis_Group_Id, 1)
1425: AND option_id = l_Anal_Opt_Rec.Bsc_Analysis_Option_Id
1426: AND parent_option_id = l_Anal_Opt_Rec.Bsc_Parent_Option_Id;
1427:
1428: DELETE FROM BSC_KPI_ANALYSIS_OPTIONS_TL
1429: WHERE indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
1430: AND analysis_group_id = NVL(l_Anal_Opt_Rec.Bsc_Analysis_Group_Id, 1)
1431: AND option_id = l_Anal_Opt_Rec.Bsc_Analysis_Option_Id
1432: AND parent_option_id = l_Anal_Opt_Rec.Bsc_Parent_Option_Id;

Line 1440: DELETE FROM BSC_KPI_ANALYSIS_OPTIONS_TL

1436: WHERE indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
1437: AND analysis_group_id = NVL(l_Anal_Opt_Rec.Bsc_Analysis_Group_Id, 0)
1438: AND option_id = l_Anal_Opt_Rec.Bsc_Analysis_Option_Id;
1439:
1440: DELETE FROM BSC_KPI_ANALYSIS_OPTIONS_TL
1441: WHERE indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
1442: AND analysis_group_id = NVL(l_Anal_Opt_Rec.Bsc_Analysis_Group_Id, 0)
1443: AND option_id = l_Anal_Opt_Rec.Bsc_Analysis_Option_Id;
1444:

Line 1504: delete from BSC_KPI_ANALYSIS_OPTIONS_TL

1500: and option_id = l_Anal_Opt_Rec.Bsc_Analysis_Option_Id
1501: and parent_option_id = l_Anal_Opt_Rec.Bsc_Parent_Option_Id
1502: and grandparent_option_id = l_Anal_Opt_Rec.Bsc_Grandparent_Option_Id;
1503:
1504: delete from BSC_KPI_ANALYSIS_OPTIONS_TL
1505: where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
1506: and analysis_group_id = NVL(l_Anal_Opt_Rec.Bsc_Analysis_Group_Id, 2)
1507: and option_id = l_Anal_Opt_Rec.Bsc_Analysis_Option_Id
1508: and parent_option_id = l_Anal_Opt_Rec.Bsc_Parent_Option_Id

Line 1518: delete from BSC_KPI_ANALYSIS_OPTIONS_TL

1514: and analysis_group_id = NVL(l_Anal_Opt_Rec.Bsc_Analysis_Group_Id, 1)
1515: and option_id = l_Anal_Opt_Rec.Bsc_Analysis_Option_Id
1516: and parent_option_id = l_Anal_Opt_Rec.Bsc_Parent_Option_Id;
1517:
1518: delete from BSC_KPI_ANALYSIS_OPTIONS_TL
1519: where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
1520: and analysis_group_id = NVL(l_Anal_Opt_Rec.Bsc_Analysis_Group_Id, 1)
1521: and option_id = l_Anal_Opt_Rec.Bsc_Analysis_Option_Id
1522: and parent_option_id = l_Anal_Opt_Rec.Bsc_Parent_Option_Id;

Line 1529: delete from BSC_KPI_ANALYSIS_OPTIONS_TL

1525: where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
1526: and analysis_group_id = NVL(l_Anal_Opt_Rec.Bsc_Analysis_Group_Id, 0)
1527: and option_id = l_Anal_Opt_Rec.Bsc_Analysis_Option_Id;
1528:
1529: delete from BSC_KPI_ANALYSIS_OPTIONS_TL
1530: where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
1531: and analysis_group_id = NVL(l_Anal_Opt_Rec.Bsc_Analysis_Group_Id, 0)
1532: and option_id = l_Anal_Opt_Rec.Bsc_Analysis_Option_Id;
1533: END IF;