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_ANALYSIS_OPTION_PUB

Line 132: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type

128: /**************************************************************************/
129: FUNCTION get_number_of_child
130: ( p_Kpi_id IN NUMBER--BSC_KPIS_B.indicator%TYPE
131: , p_group_count IN NUMBER
132: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
133: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
134: )RETURN NUMBER IS
135: l_count NUMBER;
136: BEGIN

Line 133: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type

129: FUNCTION get_number_of_child
130: ( p_Kpi_id IN NUMBER--BSC_KPIS_B.indicator%TYPE
131: , p_group_count IN NUMBER
132: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
133: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
134: )RETURN NUMBER IS
135: l_count NUMBER;
136: BEGIN
137: IF (p_Anal_Opt_Tbl(p_group_count + 1).Bsc_dependency_flag = 1) THEN

Line 221: , x_Anal_Opt_Tbl IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type

217:
218: /*******************************************************************************/
219: PROCEDURE Store_Anal_Opt_Grp_Count
220: ( p_kpi_id IN NUMBER
221: , x_Anal_Opt_Tbl IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
222: ) IS
223: l_count NUMBER ;
224:
225: CURSOR c_anal_grp_opt_count IS

Line 778: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

774: --: This procedure is part of the Analysis Option API.
775:
776: procedure Create_Analysis_Options(
777: p_commit IN varchar2 -- := FND_API.G_FALSE
778: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
779: ,x_return_status OUT NOCOPY varchar2
780: ,x_msg_count OUT NOCOPY number
781: ,x_msg_data OUT NOCOPY varchar2
782: ) is

Line 785: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

781: ,x_msg_data OUT NOCOPY varchar2
782: ) is
783:
784: l_count number;
785: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
786: begin
787: FND_MSG_PUB.Initialize;
788: x_return_status := FND_API.G_RET_STS_SUCCESS;
789: SAVEPOINT CreateBSCAnaOptPVT;

Line 933: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

929: -- added code to retrive Short_Name as well.
930: procedure Retrieve_Analysis_Options
931: (
932: p_commit IN varchar2 -- := FND_API.G_FALSE
933: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
934: , x_Anal_Opt_Rec IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
935: , p_data_source IN VARCHAR2
936: , x_return_status OUT NOCOPY varchar2
937: , x_msg_count OUT NOCOPY number

Line 934: , x_Anal_Opt_Rec IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

930: procedure Retrieve_Analysis_Options
931: (
932: p_commit IN varchar2 -- := FND_API.G_FALSE
933: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
934: , x_Anal_Opt_Rec IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
935: , p_data_source IN VARCHAR2
936: , x_return_status OUT NOCOPY varchar2
937: , x_msg_count OUT NOCOPY number
938: , x_msg_data OUT NOCOPY varchar2

Line 1080: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

1076:
1077: procedure Update_Analysis_Options
1078: (
1079: p_commit IN varchar2 -- := FND_API.G_FALSE
1080: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
1081: , p_data_source IN VARCHAR2
1082: , x_return_status OUT NOCOPY VARCHAR2
1083: , x_msg_count OUT NOCOPY NUMBER
1084: , x_msg_data OUT NOCOPY VARCHAR2

Line 1086: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

1082: , x_return_status OUT NOCOPY VARCHAR2
1083: , x_msg_count OUT NOCOPY NUMBER
1084: , x_msg_data OUT NOCOPY VARCHAR2
1085: ) IS
1086: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
1087: l_count number;
1088: begin
1089: FND_MSG_PUB.Initialize;
1090: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1301: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

1297: ************************************************************************************/
1298:
1299: PROCEDURE Delete_Analysis_Options
1300: ( p_commit IN varchar2 -- := FND_API.G_FALSE
1301: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
1302: , x_return_status OUT NOCOPY VARCHAR2
1303: , x_msg_count OUT NOCOPY NUMBER
1304: , x_msg_data OUT NOCOPY VARCHAR2
1305: ) IS

Line 1307: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

1303: , x_msg_count OUT NOCOPY NUMBER
1304: , x_msg_data OUT NOCOPY VARCHAR2
1305: ) IS
1306: l_Group_ID BSC_KPI_ANALYSIS_OPTIONS_B.Analysis_Group_Id%TYPE;
1307: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
1308: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
1309:
1310: l_AnaOpt_Delete BOOLEAN := TRUE;
1311: l_delete VARCHAR2(1);

Line 1447: BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Measures( p_commit

1443: AND option_id = l_Anal_Opt_Rec.Bsc_Analysis_Option_Id;
1444:
1445: END IF;
1446: END IF;
1447: BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Measures( p_commit
1448: ,l_Anal_Opt_Rec
1449: ,x_return_status
1450: ,x_msg_count
1451: ,x_msg_data);

Line 1535: BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Measures( p_commit

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;
1534: END IF;
1535: BSC_ANALYSIS_OPTION_PUB.Delete_Analysis_Measures( p_commit
1536: ,l_Anal_Opt_Rec
1537: ,x_return_status
1538: ,x_msg_count
1539: ,x_msg_data);

Line 1618: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

1614: --: This procedure is part of the Analysis Option API.
1615:
1616: procedure Create_Analysis_Measures(
1617: p_commit IN varchar2 -- := FND_API.G_FALSE
1618: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
1619: ,x_return_status OUT NOCOPY varchar2
1620: ,x_msg_count OUT NOCOPY number
1621: ,x_msg_data OUT NOCOPY varchar2
1622: ) is

Line 1791: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

1787:
1788: procedure Retrieve_Analysis_Measures
1789: (
1790: p_commit IN varchar2 -- := FND_API.G_FALSE
1791: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
1792: , x_Anal_Opt_Rec IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
1793: , x_return_status OUT NOCOPY varchar2
1794: , x_msg_count OUT NOCOPY number
1795: , x_msg_data OUT NOCOPY varchar2

Line 1792: , x_Anal_Opt_Rec IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

1788: procedure Retrieve_Analysis_Measures
1789: (
1790: p_commit IN varchar2 -- := FND_API.G_FALSE
1791: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
1792: , x_Anal_Opt_Rec IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
1793: , x_return_status OUT NOCOPY varchar2
1794: , x_msg_count OUT NOCOPY number
1795: , x_msg_data OUT NOCOPY varchar2
1796: ) is

Line 1917: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

1913:
1914: procedure Update_Analysis_Measures
1915: (
1916: p_commit IN varchar2 -- := FND_API.G_FALSE
1917: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
1918: , x_return_status OUT NOCOPY VARCHAR2
1919: , x_msg_count OUT NOCOPY NUMBER
1920: , x_msg_data OUT NOCOPY VARCHAR2
1921: ) is

Line 1922: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

1918: , x_return_status OUT NOCOPY VARCHAR2
1919: , x_msg_count OUT NOCOPY NUMBER
1920: , x_msg_data OUT NOCOPY VARCHAR2
1921: ) is
1922: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
1923: l_count number;
1924: l_source BSC_SYS_DATASETS_B.SOURCE%TYPE;
1925: l_sname BSC_KPIS_B.SHORT_NAME%TYPE;
1926: l_kpi_measure_id BSC_KPI_ANALYSIS_MEASURES_B.KPI_MEASURE_ID%TYPE;

Line 2202: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

2198: --need to be deleted
2199:
2200: procedure Delete_Analysis_Measures(
2201: p_commit IN varchar2 -- := FND_API.G_FALSE
2202: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
2203: ,x_return_status OUT NOCOPY varchar2
2204: ,x_msg_count OUT NOCOPY number
2205: ,x_msg_data OUT NOCOPY varchar2
2206: ) is

Line 2720: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type

2716: /**************************************************************************/
2717: PROCEDURE Initialize_Anal_Opt_Tbl
2718: (
2719: p_Kpi_id IN BSC_KPIS_B.indicator%TYPE
2720: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
2721: , p_max_group_count IN NUMBER
2722: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
2723: , p_Anal_Det_Opt_Tbl IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Det_Tbl_Type
2724: )IS

Line 2722: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type

2718: (
2719: p_Kpi_id IN BSC_KPIS_B.indicator%TYPE
2720: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
2721: , p_max_group_count IN NUMBER
2722: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
2723: , p_Anal_Det_Opt_Tbl IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Det_Tbl_Type
2724: )IS
2725: l_group_count NUMBER;
2726: l_option_id BSC_KPI_ANALYSIS_OPTIONS_B.Option_Id%TYPE;

Line 2723: , p_Anal_Det_Opt_Tbl IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Det_Tbl_Type

2719: p_Kpi_id IN BSC_KPIS_B.indicator%TYPE
2720: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
2721: , p_max_group_count IN NUMBER
2722: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
2723: , p_Anal_Det_Opt_Tbl IN OUT NOCOPY BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Det_Tbl_Type
2724: )IS
2725: l_group_count NUMBER;
2726: l_option_id BSC_KPI_ANALYSIS_OPTIONS_B.Option_Id%TYPE;
2727: l_parent_option_id BSC_KPI_ANALYSIS_OPTIONS_B.Parent_Option_Id%TYPE;

Line 2859: p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type

2855: /*******************************************************************************/
2856:
2857: FUNCTION Validate_If_single_Anal_Opt
2858: (
2859: p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
2860:
2861: )RETURN BOOLEAN
2862: IS
2863: l_Anal_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type;

Line 2863: l_Anal_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type;

2859: p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
2860:
2861: )RETURN BOOLEAN
2862: IS
2863: l_Anal_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type;
2864: l_count NUMBER;
2865:
2866: BEGIN
2867: l_Anal_Opt_Tbl := p_Anal_Opt_Tbl;

Line 2894: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type

2890:
2891: PROCEDURE Delete_Ana_Opt_Mult_Groups
2892: ( p_commit IN VARCHAR2:=FND_API.G_FALSE
2893: , p_Kpi_id IN BSC_KPIS_B.indicator%TYPE
2894: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
2895: , p_max_group_count IN NUMBER
2896: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
2897: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
2898: , x_return_status OUT NOCOPY VARCHAR2

Line 2896: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type

2892: ( p_commit IN VARCHAR2:=FND_API.G_FALSE
2893: , p_Kpi_id IN BSC_KPIS_B.indicator%TYPE
2894: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
2895: , p_max_group_count IN NUMBER
2896: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
2897: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
2898: , x_return_status OUT NOCOPY VARCHAR2
2899: , x_msg_count OUT NOCOPY NUMBER
2900: , x_msg_data OUT NOCOPY VARCHAR2

Line 2897: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

2893: , p_Kpi_id IN BSC_KPIS_B.indicator%TYPE
2894: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
2895: , p_max_group_count IN NUMBER
2896: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
2897: , p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
2898: , x_return_status OUT NOCOPY VARCHAR2
2899: , x_msg_count OUT NOCOPY NUMBER
2900: , x_msg_data OUT NOCOPY VARCHAR2
2901: )IS

Line 2903: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

2899: , x_msg_count OUT NOCOPY NUMBER
2900: , x_msg_data OUT NOCOPY VARCHAR2
2901: )IS
2902: l_count NUMBER;
2903: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
2904: l_Source VARCHAR2(3) := 'BSC';
2905: l_parent_option_id BSC_KPI_ANALYSIS_OPTIONS_B.Parent_Option_Id%TYPE;
2906: l_Anal_Det_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Det_Tbl_Type;
2907: l_anal_opt_name VARCHAR2(3000);

Line 2906: l_Anal_Det_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Det_Tbl_Type;

2902: l_count NUMBER;
2903: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
2904: l_Source VARCHAR2(3) := 'BSC';
2905: l_parent_option_id BSC_KPI_ANALYSIS_OPTIONS_B.Parent_Option_Id%TYPE;
2906: l_Anal_Det_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Det_Tbl_Type;
2907: l_anal_opt_name VARCHAR2(3000);
2908: BEGIN
2909: FND_MSG_PUB.Initialize;
2910: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3110: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type

3106:
3107: PROCEDURE Synch_Kpi_Anal_Group
3108: ( p_commit IN VARCHAR2:=FND_API.G_FALSE
3109: , p_Kpi_Id IN BSC_KPIS_B.indicator%TYPE
3110: , p_Anal_Opt_Tbl IN BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type
3111: , x_return_status OUT NOCOPY VARCHAR2
3112: , x_msg_count OUT NOCOPY NUMBER
3113: , x_msg_data OUT NOCOPY VARCHAR2
3114: )IS

Line 3115: l_Anal_Grp_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type;

3111: , x_return_status OUT NOCOPY VARCHAR2
3112: , x_msg_count OUT NOCOPY NUMBER
3113: , x_msg_data OUT NOCOPY VARCHAR2
3114: )IS
3115: l_Anal_Grp_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type;
3116: l_Anal_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type;
3117: l_count NUMBER;
3118: l_old_group_count NUMBER;
3119: l_new_group_count NUMBER;

Line 3116: l_Anal_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type;

3112: , x_msg_count OUT NOCOPY NUMBER
3113: , x_msg_data OUT NOCOPY VARCHAR2
3114: )IS
3115: l_Anal_Grp_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type;
3116: l_Anal_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Tbl_Type;
3117: l_count NUMBER;
3118: l_old_group_count NUMBER;
3119: l_new_group_count NUMBER;
3120: l_group_count NUMBER;

Line 3241: SET SHORT_NAME = BSC_ANALYSIS_OPTION_PUB.C_BSC_UNDERSCORE || cUSN.INDICATOR || '_' || cUSN.OPTION_ID

3237:
3238:
3239: FOR cUSN IN c_Update_Short_Names LOOP
3240: UPDATE BSC_KPI_ANALYSIS_OPTIONS_B
3241: SET SHORT_NAME = BSC_ANALYSIS_OPTION_PUB.C_BSC_UNDERSCORE || cUSN.INDICATOR || '_' || cUSN.OPTION_ID
3242: WHERE INDICATOR = cUSN.INDICATOR
3243: AND OPTION_ID = cUSN.OPTION_ID
3244: AND ANALYSIS_GROUP_ID = 0
3245: AND SHORT_NAME IS NOT NULL;

Line 3538: p_Bsc_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

3534: RAISE;
3535: END Validate_Custom_Measure;
3536:
3537: PROCEDURE delete_extra_series(
3538: p_Bsc_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
3539: , x_return_status OUT NOCOPY VARCHAR2
3540: , x_msg_count OUT NOCOPY NUMBER
3541: , x_msg_data OUT NOCOPY VARCHAR2
3542: ) IS

Line 3543: l_Bsc_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

3539: , x_return_status OUT NOCOPY VARCHAR2
3540: , x_msg_count OUT NOCOPY NUMBER
3541: , x_msg_data OUT NOCOPY VARCHAR2
3542: ) IS
3543: l_Bsc_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
3544: BEGIN
3545: x_return_status := FND_API.G_RET_STS_SUCCESS;
3546: FND_MSG_PUB.Initialize;
3547: --DBMS_OUTPUT.PUT_LINE('in private delte');

Line 3590: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';

3586: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
3587: WHEN NO_DATA_FOUND THEN
3588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3589: IF (x_msg_data IS NOT NULL) THEN
3590: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
3591: ELSE
3592: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
3593: END IF;
3594: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 3592: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';

3588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3589: IF (x_msg_data IS NOT NULL) THEN
3590: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
3591: ELSE
3592: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
3593: END IF;
3594: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
3595: WHEN OTHERS THEN
3596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3598: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';

3594: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
3595: WHEN OTHERS THEN
3596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3597: IF (x_msg_data IS NOT NULL) THEN
3598: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
3599: ELSE
3600: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
3601: END IF;
3602: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 3600: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';

3596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3597: IF (x_msg_data IS NOT NULL) THEN
3598: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
3599: ELSE
3600: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PUB.Delete_Ana_Opt_Mult_Groups ';
3601: END IF;
3602: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
3603: END delete_extra_series;
3604:

Line 3610: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

3606: ************************************************************************************/
3607:
3608: procedure Delete_Data_Series(
3609: p_commit IN varchar2 -- := FND_API.G_FALSE
3610: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
3611: ,x_return_status OUT NOCOPY varchar2
3612: ,x_msg_count OUT NOCOPY number
3613: ,x_msg_data OUT NOCOPY varchar2
3614: ) is

Line 3626: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

3622: AND analysis_option2 = p_Anal_Opt_Rec.Bsc_Option_Group2
3623: AND SERIES_ID > p_Anal_Opt_Rec.Bsc_Dataset_Series_Id
3624: ORDER BY SERIES_ID;
3625:
3626: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
3627: l_new_series_id number;
3628:
3629: l_Count NUMBER;
3630:

Line 3759: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type

3755: p_Anal_Opt_Rec.Bsc_Dataset_New_Series_Id;
3756: ----------------------------------------------------------------------------*/
3757: procedure Swap_Data_Series_Id(
3758: p_commit IN varchar2 -- := FND_API.G_FALSE
3759: ,p_Anal_Opt_Rec IN BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type
3760: ,x_return_status OUT NOCOPY varchar2
3761: ,x_msg_count OUT NOCOPY number
3762: ,x_msg_data OUT NOCOPY varchar2
3763: ) is

Line 3776: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;

3772: AND analysis_option2 = p_Anal_Opt_Rec.Bsc_Option_Group2
3773: AND SERIES_ID = p_Anal_Opt_Rec.Bsc_Dataset_New_Series_Id;
3774:
3775: l_temp_data_series_id number;
3776: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
3777: l_temp_value number := -999;
3778:
3779: BEGIN
3780: FND_MSG_PUB.Initialize;

Line 4220: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type

4216: PROCEDURE Set_Default_Analysis_Option
4217: (
4218: p_commit IN VARCHAR2
4219: , p_obj_id IN BSC_KPIS_B.indicator%TYPE
4220: , p_Anal_Opt_Comb_Tbl IN BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
4221: , p_Anal_Grp_Id IN BSC_KPIS_B.ind_group_id%TYPE
4222: , x_return_status OUT NOCOPY VARCHAR2
4223: , x_msg_count OUT NOCOPY NUMBER
4224: , x_msg_data OUT NOCOPY VARCHAR2

Line 4228: l_Anal_Opt_Comb_Tbl BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type;

4224: , x_msg_data OUT NOCOPY VARCHAR2
4225: )IS
4226: l_anal_grp_id BSC_KPIS_B.ind_group_id%TYPE;
4227: l_default_value BSC_KPI_ANALYSIS_GROUPS.default_value%TYPE;
4228: l_Anal_Opt_Comb_Tbl BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type;
4229: BEGIN
4230: SAVEPOINT SetDftAnalOption;
4231: x_return_status := FND_API.G_RET_STS_SUCCESS;
4232: FND_MSG_PUB.Initialize;

Line 4241: SET default_value = BSC_ANALYSIS_OPTION_PUB.c_ANAL_SERIES_DISABLED

4237: l_default_value := l_Anal_Opt_Comb_Tbl(l_anal_grp_id);
4238:
4239:
4240: UPDATE bsc_kpi_analysis_groups
4241: SET default_value = BSC_ANALYSIS_OPTION_PUB.c_ANAL_SERIES_DISABLED
4242: WHERE indicator = p_obj_id;
4243:
4244: IF(l_anal_grp_id>=0)THEN
4245: WHILE (l_anal_grp_id>=0) LOOP

Line 4256: SET default_value = BSC_ANALYSIS_OPTION_PUB.c_ANAL_SERIES_DISABLED

4252: END LOOP;
4253: END IF;
4254:
4255: UPDATE bsc_kpi_analysis_measures_b
4256: SET default_value = BSC_ANALYSIS_OPTION_PUB.c_ANAL_SERIES_DISABLED
4257: WHERE indicator = p_obj_id
4258: AND analysis_option0 = l_Anal_Opt_Comb_Tbl(0)
4259: AND analysis_option1 = l_Anal_Opt_Comb_Tbl(1)
4260: AND analysis_option2 = l_Anal_Opt_Comb_Tbl(2);

Line 4263: SET default_value = BSC_ANALYSIS_OPTION_PUB.c_ANAL_SERIES_ENABLED

4259: AND analysis_option1 = l_Anal_Opt_Comb_Tbl(1)
4260: AND analysis_option2 = l_Anal_Opt_Comb_Tbl(2);
4261:
4262: UPDATE bsc_kpi_analysis_measures_b
4263: SET default_value = BSC_ANALYSIS_OPTION_PUB.c_ANAL_SERIES_ENABLED
4264: WHERE indicator = p_obj_id
4265: AND analysis_option0 = l_Anal_Opt_Comb_Tbl(0)
4266: AND analysis_option1 = l_Anal_Opt_Comb_Tbl(1)
4267: AND analysis_option2 = l_Anal_Opt_Comb_Tbl(2)