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_PMF_UI_WRAPPER dependencies on BSC_KPI_PUB

Line 221: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

217:
218: TYPE Recdc_value IS REF CURSOR;
219: dc_value Recdc_value;
220:
221: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
222:
223: l_sql varchar2(1000);
224:
225: l_kpi_id number;

Line 369: BSC_KPI_PUB.Update_Kpi_Time_Stamp( FND_API.G_FALSE

365: end if;
366:
367: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id := p_kpi_id;
368:
369: BSC_KPI_PUB.Update_Kpi_Time_Stamp( FND_API.G_FALSE
370: ,l_Bsc_Kpi_Entity_Rec
371: ,x_return_status
372: ,x_msg_count
373: ,x_msg_data);

Line 393: BSC_KPI_PUB.Update_Kpi_Time_Stamp( FND_API.G_FALSE

389: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_GROUPS', p_kpi_id, l_kpi_id);
390: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_SETS_TL', p_kpi_id, l_kpi_id);
391: BSC_DESIGNER_PVT.Duplicate_Record_by_Indicator('BSC_KPI_DIM_LEVEL_PROPERTIES', p_kpi_id, l_kpi_id);
392:
393: BSC_KPI_PUB.Update_Kpi_Time_Stamp( FND_API.G_FALSE
394: ,l_Bsc_Kpi_Entity_Rec
395: ,x_return_status
396: ,x_msg_count
397: ,x_msg_data);

Line 830: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

826: ,p_kpi_name IN varchar2
827: ,p_kpi_help IN varchar2
828: ) is
829:
830: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
831:
832: l_commit varchar2(10);
833:
834:

Line 842: BSC_KPI_PUB.Initialize_Kpi_Entity_Rec(

838: SAVEPOINT BSCCreateKPIWrapper;
839: l_commit := FND_API.G_FALSE;
840:
841: --Call procedure to initialize Kpi Entity Rec
842: BSC_KPI_PUB.Initialize_Kpi_Entity_Rec(
843: p_Bsc_Kpi_Entity_Rec => l_Bsc_Kpi_Entity_Rec
844: ,x_Bsc_Kpi_Entity_Rec => l_Bsc_Kpi_Entity_Rec
845: ,x_return_status => x_return_status
846: ,x_msg_count => x_msg_count

Line 859: BSC_KPI_PUB.Create_Kpi( p_commit => l_commit

855: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Help := p_kpi_help;
856: l_Bsc_Kpi_Entity_Rec.Bsc_Responsibility_Id := p_responsibility_id;
857:
858:
859: BSC_KPI_PUB.Create_Kpi( p_commit => l_commit
860: ,p_Bsc_Kpi_Entity_Rec => l_Bsc_Kpi_Entity_Rec
861: ,x_return_status => x_return_status
862: ,x_msg_count => x_msg_count
863: ,x_msg_data => x_msg_data);

Line 933: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

929: ,x_msg_count OUT NOCOPY NUMBER
930: ,x_msg_data OUT NOCOPY VARCHAR2
931: ) is
932:
933: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
934: l_Bsc_Kpi_Entity_Rec_Out BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
935: l_commit varchar2(10);
936:
937: begin

Line 934: l_Bsc_Kpi_Entity_Rec_Out BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

930: ,x_msg_data OUT NOCOPY VARCHAR2
931: ) is
932:
933: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
934: l_Bsc_Kpi_Entity_Rec_Out BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
935: l_commit varchar2(10);
936:
937: begin
938: FND_MSG_PUB.Initialize;

Line 944: BSC_KPI_PUB.Initialize_Kpi_Entity_Rec(

940: SAVEPOINT BSCCreateKPIWrapper;
941: l_commit := FND_API.G_FALSE; --local commit flag.
942:
943: --Call procedure to initialize Kpi Entity Rec
944: BSC_KPI_PUB.Initialize_Kpi_Entity_Rec(
945: p_Bsc_Kpi_Entity_Rec => l_Bsc_Kpi_Entity_Rec
946: ,x_Bsc_Kpi_Entity_Rec => l_Bsc_Kpi_Entity_Rec
947: ,x_return_status => x_return_status
948: ,x_msg_count => x_msg_count

Line 971: BSC_KPI_PUB.Create_Kpi( p_commit => l_commit

967: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Indicator_Type := BSC_BIS_KPI_CRUD_PUB.C_SINGLE_BAR_INDICATOR;
968: END IF;
969:
970:
971: BSC_KPI_PUB.Create_Kpi( p_commit => l_commit
972: ,p_Bsc_Kpi_Entity_Rec => l_Bsc_Kpi_Entity_Rec
973: ,x_Bsc_Kpi_Entity_Rec => l_Bsc_Kpi_Entity_Rec_Out
974: ,x_return_status => x_return_status
975: ,x_msg_count => x_msg_count

Line 1046: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

1042: ,p_kpi_name IN varchar2 DEFAULT null
1043: ,p_kpi_help IN varchar2 DEFAULT null
1044: ) is
1045:
1046: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
1047:
1048: TYPE Recdc_value IS REF CURSOR;
1049: dc_value Recdc_value;
1050:

Line 1721: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

1717: ,p_option_help IN varchar2 DEFAULT null
1718: ) is
1719:
1720: l_Bsc_Option_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
1721: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
1722:
1723: l_commit varchar2(10);
1724:
1725: begin

Line 1754: BSC_KPI_PUB.Update_Kpi_Time_Stamp( FND_API.G_FALSE

1750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1751: END IF;
1752:
1753: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id := p_kpi_id;
1754: BSC_KPI_PUB.Update_Kpi_Time_Stamp( FND_API.G_FALSE
1755: ,l_Bsc_Kpi_Entity_Rec
1756: ,x_return_status
1757: ,x_msg_count
1758: ,x_msg_data);

Line 1812: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

1808: TYPE Recdc_opt1 IS REF CURSOR;
1809: dc_opt1 Recdc_opt1;
1810:
1811: l_Bsc_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
1812: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
1813: l_Bsc_Dim_Set_Rec_Type BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
1814:
1815: l_commit varchar2(10);
1816: l_opt_sql varchar2(1000);

Line 1888: BSC_KPI_PUB.Update_Kpi_Time_Stamp( FND_API.G_FALSE

1884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1885: END IF;
1886:
1887: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id := p_kpi_id;
1888: BSC_KPI_PUB.Update_Kpi_Time_Stamp( FND_API.G_FALSE
1889: ,l_Bsc_Kpi_Entity_Rec
1890: ,x_return_status
1891: ,x_msg_count
1892: ,x_msg_data);

Line 2046: l_Bsc_Kpi_Entity BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

2042: ,x_msg_count OUT NOCOPY NUMBER
2043: ,x_msg_data OUT NOCOPY VARCHAR2
2044: ) is
2045:
2046: l_Bsc_Kpi_Entity BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
2047: l_Bsc_Tab_Entity_Rec BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec;
2048: l_commit VARCHAR2(10);
2049: l_count NUMBER;
2050: l_Tab_Id BSC_TABS_B.Tab_Id%TYPE;

Line 2095: BSC_KPI_PUB.Delete_Kpi( FND_API.G_FALSE

2091: l_Tabs_Tbl_Type(l_Row_Count).Bsc_tab_id := cd.Tab_Id;
2092: l_Row_Count := l_Row_Count + 1;
2093: END LOOP;
2094:
2095: BSC_KPI_PUB.Delete_Kpi( FND_API.G_FALSE
2096: ,l_Bsc_Kpi_Entity
2097: ,x_return_status
2098: ,x_msg_count
2099: ,x_msg_data);

Line 2295: l_Bsc_Kpi_Entity BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

2291: ,x_msg_data OUT NOCOPY varchar2
2292: ) is
2293:
2294: l_Bsc_Tab_Entity BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec;
2295: l_Bsc_Kpi_Entity BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
2296: l_commit varchar2(10);
2297:
2298: CURSOR c_Share_Ind IS
2299: SELECT DISTINCT K.Indicator

Line 2317: BSC_KPI_PUB.Delete_Kpi

2313: FOR cd_Share_Ind IN c_Share_Ind LOOP
2314: -- call the procedure to delete share kpi from scorecard;
2315: -- Master Kpi will not be deleted.
2316: l_Bsc_Kpi_Entity.Bsc_Kpi_Id := cd_Share_Ind.Indicator;
2317: BSC_KPI_PUB.Delete_Kpi
2318: ( p_commit => FND_API.G_FALSE
2319: , p_Bsc_Kpi_Entity_Rec => l_Bsc_Kpi_Entity
2320: , x_return_status => x_return_status
2321: , x_msg_count => x_msg_count

Line 2442: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

2438: ,x_msg_data IN OUT NOCOPY varchar2
2439: ,p_time_stamp IN varchar2 := NULL
2440: ) is
2441:
2442: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
2443: l_Bsc_Tab_Entity_Rec BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec;
2444:
2445: l_commit varchar2(10);
2446: l_option_ids varchar2(300);

Line 2563: BSC_KPI_PUB.Create_Master_Kpi( FND_API.G_FALSE

2559:
2560:
2561:
2562:
2563: BSC_KPI_PUB.Create_Master_Kpi( FND_API.G_FALSE
2564: ,l_Bsc_Kpi_Entity_Rec
2565: ,x_return_status
2566: ,x_msg_count
2567: ,x_msg_data);

Line 2579: BSC_KPI_PUB.Create_Shared_Kpi( FND_API.G_FALSE

2575: --DBMS_OUTPUT.PUT_LINE('BSC_PMF_UI_WRAPPER.Assign_KPI - Flag 8');
2576: --DBMS_OUTPUT.PUT_LINE('l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Source_Ind -'||l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Source_Ind );
2577:
2578:
2579: BSC_KPI_PUB.Create_Shared_Kpi( FND_API.G_FALSE
2580: ,l_Bsc_Kpi_Entity_Rec
2581: ,x_return_status
2582: ,x_msg_count
2583: ,x_msg_data);

Line 2737: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

2733: ,x_msg_data OUT NOCOPY varchar2
2734: ,p_time_stamp IN varchar2 := NULL
2735: ) is
2736:
2737: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
2738: l_Bsc_Kpi_Group_Rec BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec;
2739: l_Bsc_Option_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
2740: l_Bsc_Tab_Entity_Rec BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec;
2741:

Line 2831: BSC_KPI_PUB.Delete_Kpi( FND_API.G_FALSE

2827: END IF;
2828: -- Delete the Share KPI
2829:
2830:
2831: BSC_KPI_PUB.Delete_Kpi( FND_API.G_FALSE
2832: ,l_Bsc_Kpi_Entity_Rec
2833: ,x_return_status
2834: ,x_msg_count
2835: ,x_msg_data);

Line 2863: BSC_KPI_PUB.Delete_Kpi_In_Tab( FND_API.G_FALSE

2859: end if;
2860: -- if l_kpi_count is 0 there are no shared KPIs. Delete Master from Tab. Reset flag.
2861: IF l_kpi_count = 0 then
2862:
2863: BSC_KPI_PUB.Delete_Kpi_In_Tab( FND_API.G_FALSE
2864: ,l_Bsc_Kpi_Entity_Rec
2865: ,x_return_status
2866: ,x_msg_count
2867: ,x_msg_data);

Line 2872: BSC_KPI_PUB.Update_Kpi_Time_Stamp( FND_API.G_FALSE

2868: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
2869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2870: END IF;
2871:
2872: BSC_KPI_PUB.Update_Kpi_Time_Stamp( FND_API.G_FALSE
2873: ,l_Bsc_Kpi_Entity_Rec
2874: ,x_return_status
2875: ,x_msg_count
2876: ,x_msg_data);

Line 2903: BSC_KPI_PUB.Delete_Kpi_Defaults( FND_API.G_FALSE

2899: WHERE source_indicator = l_Master_KPI_id );
2900:
2901: -- Once the shared KPI obtained then delete master KPI.
2902: -- call the public version of Delete_Kpi_Defaults.
2903: BSC_KPI_PUB.Delete_Kpi_Defaults( FND_API.G_FALSE
2904: , l_Bsc_Kpi_Entity_Rec
2905: , x_return_status
2906: , x_msg_count
2907: , x_msg_data);

Line 2944: BSC_KPI_PUB.move_master_kpi

2940: SET source_indicator = NULL
2941: WHERE indicator = l_kpi_id;
2942:
2943: ELSE
2944: BSC_KPI_PUB.move_master_kpi
2945: (
2946: p_master_kpi => l_Master_KPI_id
2947: ,x_return_status => x_return_status
2948: ,x_msg_count => x_msg_count

Line 3277: l_Bsc_kpi_Entity_Rec BSC_KPI_PUB.Bsc_kpi_Entity_Rec;

3273: ,p_time_stamp_to_check IN varchar2 /* := null */
3274:
3275: ) IS
3276:
3277: l_Bsc_kpi_Entity_Rec BSC_KPI_PUB.Bsc_kpi_Entity_Rec;
3278: l_time_stamp varchar(200);
3279: Begin
3280: FND_MSG_PUB.Initialize;
3281: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3308: BSC_KPI_PUB.Assign_Analysis_Option(

3304: ,x_msg_data );
3305: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
3306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3307: END IF;
3308: BSC_KPI_PUB.Assign_Analysis_Option(
3309: l_Bsc_kpi_Entity_Rec
3310: ,x_return_status
3311: ,x_msg_count
3312: ,x_msg_data );

Line 3316: BSC_KPI_PUB.Update_Kpi_Time_Stamp(

3312: ,x_msg_data );
3313: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
3314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3315: END IF ;
3316: BSC_KPI_PUB.Update_Kpi_Time_Stamp(
3317: FND_API.G_FALSE
3318: ,l_Bsc_kpi_Entity_Rec
3319: ,x_return_status
3320: ,x_msg_count

Line 3376: l_Bsc_kpi_Entity_Rec BSC_KPI_PUB.Bsc_kpi_Entity_Rec;

3372: ,p_commit IN varchar2 /* := FND_API.G_TRUE */
3373: ,p_time_stamp_to_check IN varchar2 /* := null */
3374:
3375: ) IS
3376: l_Bsc_kpi_Entity_Rec BSC_KPI_PUB.Bsc_kpi_Entity_Rec;
3377: l_time_stamp varchar(200);
3378:
3379:
3380: Begin

Line 3408: BSC_KPI_PUB.Unassign_Analysis_Option(

3404: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
3405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3406: END IF ;
3407:
3408: BSC_KPI_PUB.Unassign_Analysis_Option(
3409: l_Bsc_kpi_Entity_Rec
3410: ,x_return_status
3411: ,x_msg_count
3412: ,x_msg_data );

Line 3417: BSC_KPI_PUB.Update_Kpi_Time_Stamp(

3413: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
3414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3415: END IF;
3416:
3417: BSC_KPI_PUB.Update_Kpi_Time_Stamp(
3418: FND_API.G_FALSE
3419: ,l_Bsc_kpi_Entity_Rec
3420: ,x_return_status
3421: ,x_msg_count

Line 3471: l_Bsc_kpi_Entity_Rec BSC_KPI_PUB.Bsc_kpi_Entity_Rec;

3467: ,p_parent_option_id IN number
3468: ,p_grandparent_Option_id IN number
3469: ) return varchar2 IS
3470:
3471: l_Bsc_kpi_Entity_Rec BSC_KPI_PUB.Bsc_kpi_Entity_Rec;
3472: x_return_status varchar2(3000);
3473: x_msg_count number;
3474: x_msg_data varchar2(3000);
3475: temp varchar2(5);

Line 3500: temp := BSC_KPI_PUB.Is_Analysis_Option_Selected(

3496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3497: END IF;
3498:
3499: -- Call main function
3500: temp := BSC_KPI_PUB.Is_Analysis_Option_Selected(
3501: l_Bsc_kpi_Entity_Rec
3502: ,x_return_status
3503: ,x_msg_count
3504: ,x_msg_data );

Line 3527: l_Bsc_kpi_Entity_Rec BSC_KPI_PUB.Bsc_kpi_Entity_Rec;

3523: ,p_parent_option_id IN number
3524: ,p_grandparent_Option_id IN number
3525: ) return varchar2 IS
3526:
3527: l_Bsc_kpi_Entity_Rec BSC_KPI_PUB.Bsc_kpi_Entity_Rec;
3528: x_return_status varchar2(3000);
3529: x_msg_count number;
3530: x_msg_data varchar2(3000);
3531: temp varchar2(5);

Line 3568: temp := BSC_KPI_PUB.Is_Leaf_Analysis_Option(

3564: and parent_option_id = p_parent_option_id
3565: and grandparent_option_id = p_grandparent_option_id;
3566:
3567: if l_count <> 0 then
3568: temp := BSC_KPI_PUB.Is_Leaf_Analysis_Option(
3569: l_Bsc_kpi_Entity_Rec
3570: ,x_return_status
3571: ,x_msg_count
3572: ,x_msg_data );

Line 3599: ,p_Bsc_kpi_Entity_Rec OUT NOCOPY BSC_KPI_PUB.Bsc_kpi_Entity_Rec

3595: ,p_analysis_group_id IN number
3596: ,p_option_id IN number
3597: ,p_parent_option_id IN number
3598: ,p_grandparent_option_id IN number
3599: ,p_Bsc_kpi_Entity_Rec OUT NOCOPY BSC_KPI_PUB.Bsc_kpi_Entity_Rec
3600: ,x_return_status OUT NOCOPY varchar2
3601: ,x_msg_count OUT NOCOPY number
3602: ,x_msg_data OUT NOCOPY varchar2
3603: ) IS

Line 4927: l_time_stamp := BSC_KPI_PUB.get_KPI_Time_Stamp(p_kpi_id);

4923: p_kpi_id IN number
4924: ) return varchar2 is
4925: l_time_stamp date;
4926: begin
4927: l_time_stamp := BSC_KPI_PUB.get_KPI_Time_Stamp(p_kpi_id);
4928: return TO_CHAR(l_time_stamp , g_time_stamp_format );
4929:
4930: EXCEPTION
4931: WHEN OTHERS THEN

Line 5197: ,l_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

5193:
5194: PROCEDURE Update_Obj_Cal_properties (
5195: p_commit IN VARCHAR2
5196: ,p_calendar_id IN NUMBER
5197: ,l_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
5198: ,l_periodicities_tbl IN BSC_BIS_LOCKS_PUB.t_numberTable
5199: ,l_current_periods IN BSC_BIS_LOCKS_PUB.t_numberTable
5200: ,l_Dft_periodicity_id IN NUMBER
5201: ,l_action_flag IN NUMBER

Line 5227: BSC_KPI_PUB.Create_Kpi_Periodicity

5223: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Num_Years := 0;
5224: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Previous_Years := 0 ;
5225: END IF;
5226:
5227: BSC_KPI_PUB.Create_Kpi_Periodicity
5228: ( p_commit => p_commit
5229: , p_Bsc_Kpi_Entity_Rec => l_Bsc_Kpi_Entity_Rec
5230: , x_return_status => x_return_status
5231: , x_msg_count => x_msg_count

Line 5300: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

5296: ,x_msg_count OUT NOCOPY NUMBER
5297: ,x_msg_data OUT NOCOPY VARCHAR2
5298: ) IS
5299: l_Max_Periods NUMBER := 0;
5300: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
5301:
5302: CURSOR c_share_kpis IS
5303: SELECT
5304: indicator

Line 5353: BSC_KPI_PUB.Update_Kpi_Periodicity (

5349: END IF;
5350:
5351: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id := p_Indicator;
5352: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Periodicity_Id := cd.periodicity_id;
5353: BSC_KPI_PUB.Update_Kpi_Periodicity (
5354: p_commit => FND_API.G_FALSE
5355: ,p_Bsc_Kpi_Entity_Rec => l_Bsc_Kpi_Entity_Rec
5356: ,x_return_status => x_return_status
5357: ,x_msg_count => x_msg_count

Line 5367: BSC_KPI_PUB.Update_Kpi_Periodicity (

5363:
5364: IF p_cascade_shared THEN
5365: FOR cd IN c_share_kpis LOOP
5366: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id := cd.Indicator;
5367: BSC_KPI_PUB.Update_Kpi_Periodicity (
5368: p_commit => FND_API.G_FALSE
5369: ,p_Bsc_Kpi_Entity_Rec => l_Bsc_Kpi_Entity_Rec
5370: ,x_return_status => x_return_status
5371: ,x_msg_count => x_msg_count

Line 5465: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

5461: l_count NUMBER;
5462: l_per_count NUMBER;
5463: l_cur_cal_id NUMBER;
5464: l_cur_periodicity_id NUMBER;
5465: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
5466: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
5467: l_sql varchar2(500);
5468: l_Dft_periodicity_id NUMBER ;
5469: l_periodicity_id NUMBER;

Line 5729: BSC_KPI_PUB.Initialize_Kpi_Entity_Rec

5725:
5726: -- If any chage then only do the operations
5727: -- l_action_flag null if no change, Color change on Default, prototype on calendar change or periodicity add/remove.
5728: IF (l_action_flag IS NOT NULL) THEN
5729: BSC_KPI_PUB.Initialize_Kpi_Entity_Rec
5730: ( p_Bsc_Kpi_Entity_Rec => l_Bsc_Kpi_Entity_Rec
5731: , x_Bsc_Kpi_Entity_Rec => l_Bsc_Kpi_Entity_Rec
5732: , x_return_status => x_return_status
5733: , x_msg_count => x_msg_count