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

Line 56: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

52: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_KPI_PVT';
53:
54: procedure Create_Kpi(
55: p_commit IN varchar2 := FND_API.G_FALSE
56: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
57: ,x_return_status OUT NOCOPY varchar2
58: ,x_msg_count OUT NOCOPY number
59: ,x_msg_data OUT NOCOPY varchar2
60: ) is

Line 62: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

58: ,x_msg_count OUT NOCOPY number
59: ,x_msg_data OUT NOCOPY varchar2
60: ) is
61:
62: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
63:
64: l_db_object VARCHAR2(30);
65: l_count NUMBER;
66: l_No_Ind NUMBER;

Line 110: AND PROTOTYPE_FLAG <> BSC_KPI_PUB.DELETE_KPI_FLAG;

106: IF l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Short_Name IS NOT NULL THEN
107: SELECT COUNT(1) INTO l_Count
108: FROM BSC_KPIS_B
109: WHERE SHORT_NAME = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Short_Name
110: AND PROTOTYPE_FLAG <> BSC_KPI_PUB.DELETE_KPI_FLAG;
111:
112: IF l_Count <> 0 THEN
113: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
114: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.GET_LOOKUP_VALUE('BSC_UI_BUILDER', 'MEASURE_SHORT_NAME'));

Line 184: ,l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Publish_Flag

180: ,l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Color_Flag
181: ,l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Prototype_Color
182: ,l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Share_Flag
183: ,l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Source_Ind
184: ,l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Publish_Flag
185: ,l_Bsc_Kpi_Entity_Rec.Created_By
186: ,sysdate
187: ,l_Bsc_Kpi_Entity_Rec.Last_Updated_By
188: ,sysdate

Line 287: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

283:
284:
285: procedure Retrieve_Kpi(
286: p_commit IN varchar2 := FND_API.G_FALSE
287: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
288: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
289: ,x_return_status OUT NOCOPY varchar2
290: ,x_msg_count OUT NOCOPY number
291: ,x_msg_data OUT NOCOPY varchar2

Line 288: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

284:
285: procedure Retrieve_Kpi(
286: p_commit IN varchar2 := FND_API.G_FALSE
287: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
288: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
289: ,x_return_status OUT NOCOPY varchar2
290: ,x_msg_count OUT NOCOPY number
291: ,x_msg_data OUT NOCOPY varchar2
292: ) is

Line 343: ,x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Publish_Flag

339: ,x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Color_Flag
340: ,x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Prototype_Color
341: ,x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Share_Flag
342: ,x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Source_Ind
343: ,x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Publish_Flag
344: ,x_Bsc_Kpi_Entity_Rec.Created_By
345: ,x_Bsc_Kpi_Entity_Rec.Creation_Date
346: ,x_Bsc_Kpi_Entity_Rec.Last_Updated_By
347: ,x_Bsc_Kpi_Entity_Rec.Last_Update_Date

Line 411: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

407: ************************************************************************************/
408:
409: procedure Update_Kpi(
410: p_commit IN varchar2 := FND_API.G_FALSE
411: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
412: ,x_return_status OUT NOCOPY varchar2
413: ,x_msg_count OUT NOCOPY number
414: ,x_msg_data OUT NOCOPY varchar2
415: ) is

Line 417: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

413: ,x_msg_count OUT NOCOPY number
414: ,x_msg_data OUT NOCOPY varchar2
415: ) is
416:
417: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
418:
419: l_count number;
420:
421: begin

Line 496: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Publish_Flag is not null then

492: end if;
493: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Source_Ind is not null then
494: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Source_Ind := p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Source_Ind;
495: end if;
496: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Publish_Flag is not null then
497: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Publish_Flag := p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Publish_Flag;
498: end if;
499: if p_Bsc_Kpi_Entity_Rec.Created_By is not null then
500: l_Bsc_Kpi_Entity_Rec.Created_By := p_Bsc_Kpi_Entity_Rec.Created_By;

Line 497: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Publish_Flag := p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Publish_Flag;

493: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Source_Ind is not null then
494: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Source_Ind := p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Source_Ind;
495: end if;
496: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Publish_Flag is not null then
497: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Publish_Flag := p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Publish_Flag;
498: end if;
499: if p_Bsc_Kpi_Entity_Rec.Created_By is not null then
500: l_Bsc_Kpi_Entity_Rec.Created_By := p_Bsc_Kpi_Entity_Rec.Created_By;
501: end if;

Line 553: ,publish_flag = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Publish_Flag

549: ,apply_color_flag = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Color_Flag
550: ,prototype_color = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Prototype_Color
551: ,share_flag = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Share_Flag
552: ,source_indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Source_Ind
553: ,publish_flag = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Publish_Flag
554: ,created_by = l_Bsc_Kpi_Entity_Rec.Created_By
555: ,creation_date = l_Bsc_Kpi_Entity_Rec.Creation_Date
556: ,last_updated_by = l_Bsc_Kpi_Entity_Rec.Last_Updated_By
557: ,last_update_date = l_Bsc_Kpi_Entity_Rec.Last_Update_Date

Line 627: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

623: ************************************************************************************/
624:
625: procedure Delete_Kpi(
626: p_commit IN varchar2 := FND_API.G_FALSE
627: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
628: ,x_return_status OUT NOCOPY varchar2
629: ,x_msg_count OUT NOCOPY number
630: ,x_msg_data OUT NOCOPY varchar2
631: ) is

Line 680: SET PROTOTYPE_FLAG = BSC_KPI_PUB.DELETE_KPI_FLAG

676: DELETE FROM BSC_KPIS_TL
677: WHERE INDICATOR = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
678: ELSE
679: UPDATE BSC_KPIS_B
680: SET PROTOTYPE_FLAG = BSC_KPI_PUB.DELETE_KPI_FLAG
681: WHERE INDICATOR = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
682: END IF;
683:
684: -- Added for Bug #3248729

Line 738: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

734: ************************************************************************************/
735:
736: procedure Create_Kpi_Defaults(
737: p_commit IN varchar2 := FND_API.G_FALSE
738: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
739: ,x_return_status OUT NOCOPY varchar2
740: ,x_msg_count OUT NOCOPY number
741: ,x_msg_data OUT NOCOPY varchar2
742: ) is

Line 744: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

740: ,x_msg_count OUT NOCOPY number
741: ,x_msg_data OUT NOCOPY varchar2
742: ) is
743:
744: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
745:
746: l_Bsc_Dim_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
747:
748: l_db_object varchar2(30);

Line 901: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

897: ************************************************************************************/
898:
899: procedure Retrieve_Kpi_Defaults(
900: p_commit IN varchar2 := FND_API.G_FALSE
901: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
902: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
903: ,x_return_status OUT NOCOPY varchar2
904: ,x_msg_count OUT NOCOPY number
905: ,x_msg_data OUT NOCOPY varchar2

Line 902: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

898:
899: procedure Retrieve_Kpi_Defaults(
900: p_commit IN varchar2 := FND_API.G_FALSE
901: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
902: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
903: ,x_return_status OUT NOCOPY varchar2
904: ,x_msg_count OUT NOCOPY number
905: ,x_msg_data OUT NOCOPY varchar2
906: ) is

Line 987: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

983: ************************************************************************************/
984:
985: procedure Update_Kpi_Defaults(
986: p_commit IN varchar2 := FND_API.G_FALSE
987: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
988: ,x_return_status OUT NOCOPY varchar2
989: ,x_msg_count OUT NOCOPY number
990: ,x_msg_data OUT NOCOPY varchar2
991: ) is

Line 1048: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

1044: ************************************************************************************/
1045:
1046: procedure Delete_Kpi_Defaults(
1047: p_commit IN varchar2 := FND_API.G_FALSE
1048: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
1049: ,x_return_status OUT NOCOPY varchar2
1050: ,x_msg_count OUT NOCOPY number
1051: ,x_msg_data OUT NOCOPY varchar2
1052: ) is

Line 1106: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

1102: ************************************************************************************/
1103:
1104: procedure Create_Kpi_Properties(
1105: p_commit IN varchar2 := FND_API.G_FALSE
1106: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
1107: ,x_return_status OUT NOCOPY varchar2
1108: ,x_msg_count OUT NOCOPY number
1109: ,x_msg_data OUT NOCOPY varchar2
1110: ) is

Line 1208: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

1204: ************************************************************************************/
1205:
1206: procedure Retrieve_Kpi_Properties(
1207: p_commit IN varchar2 := FND_API.G_FALSE
1208: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
1209: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
1210: ,x_return_status OUT NOCOPY varchar2
1211: ,x_msg_count OUT NOCOPY number
1212: ,x_msg_data OUT NOCOPY varchar2

Line 1209: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

1205:
1206: procedure Retrieve_Kpi_Properties(
1207: p_commit IN varchar2 := FND_API.G_FALSE
1208: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
1209: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
1210: ,x_return_status OUT NOCOPY varchar2
1211: ,x_msg_count OUT NOCOPY number
1212: ,x_msg_data OUT NOCOPY varchar2
1213: ) is

Line 1278: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

1274: ************************************************************************************/
1275:
1276: procedure Update_Kpi_Properties(
1277: p_commit IN varchar2 := FND_API.G_FALSE
1278: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
1279: ,x_return_status OUT NOCOPY varchar2
1280: ,x_msg_count OUT NOCOPY number
1281: ,x_msg_data OUT NOCOPY varchar2
1282: ) is

Line 1284: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

1280: ,x_msg_count OUT NOCOPY number
1281: ,x_msg_data OUT NOCOPY varchar2
1282: ) is
1283:
1284: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
1285:
1286: l_count number;
1287:
1288: begin

Line 1392: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

1388: ************************************************************************************/
1389:
1390: procedure Delete_Kpi_Properties(
1391: p_commit IN varchar2 := FND_API.G_FALSE
1392: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
1393: ,x_return_status OUT NOCOPY varchar2
1394: ,x_msg_count OUT NOCOPY number
1395: ,x_msg_data OUT NOCOPY varchar2
1396: ) is

Line 1477: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

1473: ************************************************************************************/
1474:
1475: procedure Create_Kpi_Analysis(
1476: p_commit IN varchar2 := FND_API.G_FALSE
1477: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
1478: ,x_return_status OUT NOCOPY varchar2
1479: ,x_msg_count OUT NOCOPY number
1480: ,x_msg_data OUT NOCOPY varchar2
1481: ) is

Line 1638: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

1634: ************************************************************************************/
1635:
1636: procedure Retrieve_Kpi_Analysis(
1637: p_commit IN varchar2 := FND_API.G_FALSE
1638: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
1639: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
1640: ,x_return_status OUT NOCOPY varchar2
1641: ,x_msg_count OUT NOCOPY number
1642: ,x_msg_data OUT NOCOPY varchar2

Line 1639: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

1635:
1636: procedure Retrieve_Kpi_Analysis(
1637: p_commit IN varchar2 := FND_API.G_FALSE
1638: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
1639: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
1640: ,x_return_status OUT NOCOPY varchar2
1641: ,x_msg_count OUT NOCOPY number
1642: ,x_msg_data OUT NOCOPY varchar2
1643: ) is

Line 1736: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

1732: ************************************************************************************/
1733:
1734: procedure Update_Kpi_Analysis(
1735: p_commit IN varchar2 := FND_API.G_FALSE
1736: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
1737: ,x_return_status OUT NOCOPY varchar2
1738: ,x_msg_count OUT NOCOPY number
1739: ,x_msg_data OUT NOCOPY varchar2
1740: ) is

Line 1742: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

1738: ,x_msg_count OUT NOCOPY number
1739: ,x_msg_data OUT NOCOPY varchar2
1740: ) is
1741:
1742: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
1743:
1744: l_count number;
1745:
1746: begin

Line 1892: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

1888: ************************************************************************************/
1889:
1890: procedure Delete_Kpi_Analysis(
1891: p_commit IN varchar2 := FND_API.G_FALSE
1892: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
1893: ,x_return_status OUT NOCOPY varchar2
1894: ,x_msg_count OUT NOCOPY number
1895: ,x_msg_data OUT NOCOPY varchar2
1896: ) is

Line 1999: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

1995: ************************************************************************************/
1996:
1997: procedure Delete_Objective_Color_Data(
1998: p_commit IN varchar2 := FND_API.G_FALSE
1999: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
2000: ,x_return_status OUT NOCOPY varchar2
2001: ,x_msg_count OUT NOCOPY number
2002: ,x_msg_data OUT NOCOPY varchar2
2003: ) is

Line 2113: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

2109: ************************************************************************************/
2110:
2111: procedure Create_Kpi_Periodicity(
2112: p_commit IN varchar2 := FND_API.G_FALSE
2113: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
2114: ,x_return_status OUT NOCOPY varchar2
2115: ,x_msg_count OUT NOCOPY number
2116: ,x_msg_data OUT NOCOPY varchar2
2117: ) is

Line 2119: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

2115: ,x_msg_count OUT NOCOPY number
2116: ,x_msg_data OUT NOCOPY varchar2
2117: ) is
2118:
2119: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
2120:
2121: l_db_object varchar2(30);
2122:
2123: l_count number;

Line 2263: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

2259: ************************************************************************************/
2260:
2261: procedure Retrieve_Kpi_Periodicity(
2262: p_commit IN varchar2 := FND_API.G_FALSE
2263: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
2264: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
2265: ,x_return_status OUT NOCOPY varchar2
2266: ,x_msg_count OUT NOCOPY number
2267: ,x_msg_data OUT NOCOPY varchar2

Line 2264: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

2260:
2261: procedure Retrieve_Kpi_Periodicity(
2262: p_commit IN varchar2 := FND_API.G_FALSE
2263: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
2264: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
2265: ,x_return_status OUT NOCOPY varchar2
2266: ,x_msg_count OUT NOCOPY number
2267: ,x_msg_data OUT NOCOPY varchar2
2268: ) is

Line 2352: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

2348: ************************************************************************************/
2349:
2350: procedure Update_Kpi_Periodicity(
2351: p_commit IN varchar2 := FND_API.G_FALSE
2352: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
2353: ,x_return_status OUT NOCOPY varchar2
2354: ,x_msg_count OUT NOCOPY number
2355: ,x_msg_data OUT NOCOPY varchar2
2356: ) is

Line 2358: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

2354: ,x_msg_count OUT NOCOPY number
2355: ,x_msg_data OUT NOCOPY varchar2
2356: ) is
2357:
2358: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
2359:
2360: l_count number;
2361:
2362: begin

Line 2506: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

2502: ************************************************************************************/
2503:
2504: procedure Delete_Kpi_Periodicity(
2505: p_commit IN varchar2 := FND_API.G_FALSE
2506: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
2507: ,x_return_status OUT NOCOPY varchar2
2508: ,x_msg_count OUT NOCOPY number
2509: ,x_msg_data OUT NOCOPY varchar2
2510: ) is

Line 2592: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

2588: ************************************************************************************/
2589:
2590: procedure Create_Kpi_Data_Tables(
2591: p_commit IN varchar2 := FND_API.G_FALSE
2592: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
2593: ,x_return_status OUT NOCOPY varchar2
2594: ,x_msg_count OUT NOCOPY number
2595: ,x_msg_data OUT NOCOPY varchar2
2596: ) is

Line 2698: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

2694: ************************************************************************************/
2695:
2696: procedure Retrieve_Kpi_Data_Tables(
2697: p_commit IN varchar2 := FND_API.G_FALSE
2698: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
2699: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
2700: ,x_return_status OUT NOCOPY varchar2
2701: ,x_msg_count OUT NOCOPY number
2702: ,x_msg_data OUT NOCOPY varchar2

Line 2699: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

2695:
2696: procedure Retrieve_Kpi_Data_Tables(
2697: p_commit IN varchar2 := FND_API.G_FALSE
2698: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
2699: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
2700: ,x_return_status OUT NOCOPY varchar2
2701: ,x_msg_count OUT NOCOPY number
2702: ,x_msg_data OUT NOCOPY varchar2
2703: ) is

Line 2770: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

2766: ************************************************************************************/
2767:
2768: procedure Update_Kpi_Data_Tables(
2769: p_commit IN varchar2 := FND_API.G_FALSE
2770: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
2771: ,x_return_status OUT NOCOPY varchar2
2772: ,x_msg_count OUT NOCOPY number
2773: ,x_msg_data OUT NOCOPY varchar2
2774: ) is

Line 2776: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

2772: ,x_msg_count OUT NOCOPY number
2773: ,x_msg_data OUT NOCOPY varchar2
2774: ) is
2775:
2776: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
2777:
2778: l_count number;
2779:
2780: begin

Line 2889: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

2885: ************************************************************************************/
2886:
2887: procedure Delete_Kpi_Data_Tables(
2888: p_commit IN varchar2 := FND_API.G_FALSE
2889: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
2890: ,x_return_status OUT NOCOPY varchar2
2891: ,x_msg_count OUT NOCOPY number
2892: ,x_msg_data OUT NOCOPY varchar2
2893: ) is

Line 2996: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

2992: ************************************************************************************/
2993:
2994: procedure Create_Kpi_Calculations(
2995: p_commit IN varchar2 := FND_API.G_FALSE
2996: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
2997: ,x_return_status OUT NOCOPY varchar2
2998: ,x_msg_count OUT NOCOPY number
2999: ,x_msg_data OUT NOCOPY varchar2
3000: ) is

Line 3105: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

3101: ************************************************************************************/
3102:
3103: procedure Retrieve_Kpi_Calculations(
3104: p_commit IN varchar2 := FND_API.G_FALSE
3105: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
3106: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
3107: ,x_return_status OUT NOCOPY varchar2
3108: ,x_msg_count OUT NOCOPY number
3109: ,x_msg_data OUT NOCOPY varchar2

Line 3106: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

3102:
3103: procedure Retrieve_Kpi_Calculations(
3104: p_commit IN varchar2 := FND_API.G_FALSE
3105: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
3106: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
3107: ,x_return_status OUT NOCOPY varchar2
3108: ,x_msg_count OUT NOCOPY number
3109: ,x_msg_data OUT NOCOPY varchar2
3110: ) is

Line 3181: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

3177: ************************************************************************************/
3178:
3179: procedure Update_Kpi_Calculations(
3180: p_commit IN varchar2 := FND_API.G_FALSE
3181: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
3182: ,x_return_status OUT NOCOPY varchar2
3183: ,x_msg_count OUT NOCOPY number
3184: ,x_msg_data OUT NOCOPY varchar2
3185: ) is

Line 3187: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

3183: ,x_msg_count OUT NOCOPY number
3184: ,x_msg_data OUT NOCOPY varchar2
3185: ) is
3186:
3187: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
3188:
3189: l_count number;
3190:
3191: begin

Line 3327: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

3323: ************************************************************************************/
3324:
3325: procedure Delete_Kpi_Calculations(
3326: p_commit IN varchar2 := FND_API.G_FALSE
3327: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
3328: ,x_return_status OUT NOCOPY varchar2
3329: ,x_msg_count OUT NOCOPY number
3330: ,x_msg_data OUT NOCOPY varchar2
3331: ) is

Line 3417: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

3413: ************************************************************************************/
3414:
3415: procedure Create_Kpi_User_Access(
3416: p_commit IN varchar2 := FND_API.G_FALSE
3417: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
3418: ,x_return_status OUT NOCOPY varchar2
3419: ,x_msg_count OUT NOCOPY number
3420: ,x_msg_data OUT NOCOPY varchar2
3421: ) is

Line 3533: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

3529: ************************************************************************************/
3530:
3531: procedure Retrieve_Kpi_User_Access(
3532: p_commit IN varchar2 := FND_API.G_FALSE
3533: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
3534: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
3535: ,x_return_status OUT NOCOPY varchar2
3536: ,x_msg_count OUT NOCOPY number
3537: ,x_msg_data OUT NOCOPY varchar2

Line 3534: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

3530:
3531: procedure Retrieve_Kpi_User_Access(
3532: p_commit IN varchar2 := FND_API.G_FALSE
3533: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
3534: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
3535: ,x_return_status OUT NOCOPY varchar2
3536: ,x_msg_count OUT NOCOPY number
3537: ,x_msg_data OUT NOCOPY varchar2
3538: ) is

Line 3615: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

3611: ************************************************************************************/
3612:
3613: procedure Update_Kpi_User_Access(
3614: p_commit IN varchar2 := FND_API.G_FALSE
3615: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
3616: ,x_return_status OUT NOCOPY varchar2
3617: ,x_msg_count OUT NOCOPY number
3618: ,x_msg_data OUT NOCOPY varchar2
3619: ) is

Line 3621: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

3617: ,x_msg_count OUT NOCOPY number
3618: ,x_msg_data OUT NOCOPY varchar2
3619: ) is
3620:
3621: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
3622:
3623: l_count number;
3624:
3625: begin

Line 3749: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

3745: ************************************************************************************/
3746:
3747: procedure Delete_Kpi_User_Access(
3748: p_commit IN varchar2 := FND_API.G_FALSE
3749: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
3750: ,x_return_status OUT NOCOPY varchar2
3751: ,x_msg_count OUT NOCOPY number
3752: ,x_msg_data OUT NOCOPY varchar2
3753: ) is

Line 3833: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

3829: /************************************************************************************
3830: ************************************************************************************/
3831: procedure Create_Kpi_Default_Values(
3832: p_commit IN varchar2 := FND_API.G_FALSE
3833: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
3834: ,x_return_status OUT NOCOPY varchar2
3835: ,x_msg_count OUT NOCOPY number
3836: ,x_msg_data OUT NOCOPY varchar2
3837: ) is

Line 3839: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

3835: ,x_msg_count OUT NOCOPY number
3836: ,x_msg_data OUT NOCOPY varchar2
3837: ) is
3838:
3839: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
3840:
3841: l_db_object varchar2(30);
3842:
3843: l_count number;

Line 4036: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

4032: ************************************************************************************/
4033:
4034: procedure Retrieve_Kpi_Default_Values(
4035: p_commit IN varchar2 := FND_API.G_FALSE
4036: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
4037: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
4038: ,x_return_status OUT NOCOPY varchar2
4039: ,x_msg_count OUT NOCOPY number
4040: ,x_msg_data OUT NOCOPY varchar2

Line 4037: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

4033:
4034: procedure Retrieve_Kpi_Default_Values(
4035: p_commit IN varchar2 := FND_API.G_FALSE
4036: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
4037: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
4038: ,x_return_status OUT NOCOPY varchar2
4039: ,x_msg_count OUT NOCOPY number
4040: ,x_msg_data OUT NOCOPY varchar2
4041: ) is

Line 4181: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

4177: ************************************************************************************/
4178:
4179: procedure Update_Kpi_Default_Values(
4180: p_commit IN varchar2 := FND_API.G_FALSE
4181: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
4182: ,x_return_status OUT NOCOPY varchar2
4183: ,x_msg_count OUT NOCOPY number
4184: ,x_msg_data OUT NOCOPY varchar2
4185: ) is

Line 4187: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

4183: ,x_msg_count OUT NOCOPY number
4184: ,x_msg_data OUT NOCOPY varchar2
4185: ) is
4186:
4187: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
4188:
4189: l_count number;
4190:
4191: begin

Line 4446: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

4442: ************************************************************************************/
4443:
4444: procedure Delete_Kpi_Default_Values(
4445: p_commit IN varchar2 := FND_API.G_FALSE
4446: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
4447: ,x_return_status OUT NOCOPY varchar2
4448: ,x_msg_count OUT NOCOPY number
4449: ,x_msg_data OUT NOCOPY varchar2
4450: ) is

Line 4534: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

4530: ************************************************************************************/
4531:
4532: procedure Create_Kpi_In_Tab(
4533: p_commit IN varchar2 := FND_API.G_FALSE
4534: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
4535: ,x_return_status OUT NOCOPY varchar2
4536: ,x_msg_count OUT NOCOPY number
4537: ,x_msg_data OUT NOCOPY varchar2
4538: ) is

Line 4540: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

4536: ,x_msg_count OUT NOCOPY number
4537: ,x_msg_data OUT NOCOPY varchar2
4538: ) is
4539:
4540: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
4541: l_Bsc_Kpi_Group_Rec BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec;
4542:
4543: l_db_object varchar2(30);
4544:

Line 4750: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

4746: ************************************************************************************/
4747:
4748: procedure Retrieve_Kpi_In_Tab(
4749: p_commit IN varchar2 := FND_API.G_FALSE
4750: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
4751: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
4752: ,x_return_status OUT NOCOPY varchar2
4753: ,x_msg_count OUT NOCOPY number
4754: ,x_msg_data OUT NOCOPY varchar2

Line 4751: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

4747:
4748: procedure Retrieve_Kpi_In_Tab(
4749: p_commit IN varchar2 := FND_API.G_FALSE
4750: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
4751: ,x_Bsc_Kpi_Entity_Rec IN OUT NOCOPY BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
4752: ,x_return_status OUT NOCOPY varchar2
4753: ,x_msg_count OUT NOCOPY number
4754: ,x_msg_data OUT NOCOPY varchar2
4755: ) is

Line 4832: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

4828: ************************************************************************************/
4829:
4830: procedure Update_Kpi_In_Tab(
4831: p_commit IN varchar2 := FND_API.G_FALSE
4832: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
4833: ,x_return_status OUT NOCOPY varchar2
4834: ,x_msg_count OUT NOCOPY number
4835: ,x_msg_data OUT NOCOPY varchar2
4836: ) is

Line 4950: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

4946: ************************************************************************************/
4947:
4948: procedure Delete_Kpi_In_Tab(
4949: p_commit IN varchar2 := FND_API.G_FALSE
4950: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
4951: ,x_return_status OUT NOCOPY varchar2
4952: ,x_msg_count OUT NOCOPY number
4953: ,x_msg_data OUT NOCOPY varchar2
4954: ) is

Line 5038: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

5034: ************************************************************************************/
5035:
5036: procedure Update_Kpi_Time_Stamp(
5037: p_commit IN varchar2 := FND_API.G_FALSE
5038: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
5039: ,x_return_status OUT NOCOPY varchar2
5040: ,x_msg_count OUT NOCOPY number
5041: ,x_msg_data OUT NOCOPY varchar2
5042: ) is

Line 5104: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

5100: ************************************************************************************/
5101:
5102: procedure Create_Master_Kpi(
5103: p_commit IN varchar2 := FND_API.G_FALSE
5104: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
5105: ,x_return_status OUT NOCOPY varchar2
5106: ,x_msg_count OUT NOCOPY number
5107: ,x_msg_data OUT NOCOPY varchar2
5108: ) is

Line 5110: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

5106: ,x_msg_count OUT NOCOPY number
5107: ,x_msg_data OUT NOCOPY varchar2
5108: ) is
5109:
5110: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
5111:
5112: l_count number;
5113:
5114: --The following variables are needed as temporary holders.

Line 5265: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

5261: /************************************************************************************
5262: ************************************************************************************/
5263: procedure Create_Shared_Kpi(
5264: p_commit IN varchar2 := FND_API.G_FALSE
5265: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
5266: ,x_return_status OUT NOCOPY varchar2
5267: ,x_msg_count OUT NOCOPY number
5268: ,x_msg_data OUT NOCOPY varchar2
5269: ) is

Line 5274: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec; -- local Record.

5270:
5271: TYPE Recdc_value IS REF CURSOR;
5272: dc_value Recdc_value;
5273:
5274: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec; -- local Record.
5275: l_x_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec; -- to keep values
5276: -- from retrieve procedures.
5277:
5278: l_Bsc_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;

Line 5275: l_x_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec; -- to keep values

5271: TYPE Recdc_value IS REF CURSOR;
5272: dc_value Recdc_value;
5273:
5274: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec; -- local Record.
5275: l_x_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec; -- to keep values
5276: -- from retrieve procedures.
5277:
5278: l_Bsc_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
5279: l_x_Bsc_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;

Line 5500: BSC_KPI_PUB.Create_Kpi_User_Access( p_commit

5496:
5497: --DBMS_OUTPUT.PUT_LINE(' BSC_KPI_PVT.Create_Shared_Kpi - Flag 13');
5498:
5499: -- Grant access
5500: BSC_KPI_PUB.Create_Kpi_User_Access( p_commit
5501: ,l_Bsc_Kpi_Entity_Rec
5502: ,x_return_status
5503: ,x_msg_count
5504: ,x_msg_data);

Line 5514: BSC_KPI_PUB.Create_Kpi_User_Access( p_commit

5510: into l_Bsc_Kpi_Entity_Rec.Bsc_Responsibility_Id
5511: from FND_RESPONSIBILITY
5512: where responsibility_key = 'BSC_PMD_USER';
5513:
5514: BSC_KPI_PUB.Create_Kpi_User_Access( p_commit
5515: ,l_Bsc_Kpi_Entity_Rec
5516: ,x_return_status
5517: ,x_msg_count
5518: ,x_msg_data);*/

Line 5758: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

5754: ************************************************************************************/
5755:
5756: procedure Set_Default_Option(
5757: p_commit IN varchar2 := FND_API.G_FALSE
5758: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
5759: ,x_return_status OUT NOCOPY varchar2
5760: ,x_msg_count OUT NOCOPY number
5761: ,x_msg_data OUT NOCOPY varchar2
5762: ) is

Line 5764: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;

5760: ,x_msg_count OUT NOCOPY number
5761: ,x_msg_data OUT NOCOPY varchar2
5762: ) is
5763:
5764: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
5765:
5766: TYPE Recdc_value IS REF CURSOR;
5767: dc_value Recdc_value;
5768:

Line 5781: AND PROTOTYPE_FLAG <> BSC_KPI_PUB.Delete_Kpi_Flag;

5777: CURSOR c_Select_Indicator IS
5778: SELECT INDICATOR
5779: FROM BSC_KPIS_B
5780: WHERE SOURCE_INDICATOR = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_id
5781: AND PROTOTYPE_FLAG <> BSC_KPI_PUB.Delete_Kpi_Flag;
5782:
5783: begin
5784: FND_MSG_PUB.Initialize;
5785: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5806: if ((l_share_flag = 1) and (l_proto_flag <> BSC_KPI_PUB.DELETE_KPI_FLAG)) then

5802: INTO l_share_flag, l_proto_flag
5803: FROM BSC_KPIS_B
5804: WHERE INDICATOR = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_id;
5805:
5806: if ((l_share_flag = 1) and (l_proto_flag <> BSC_KPI_PUB.DELETE_KPI_FLAG)) then
5807:
5808: -- Second step is to set the default option (1) by selecting the first displayed
5809: -- option. At this point all displayed options are flagged with 2.
5810: update BSC_KPI_ANALYSIS_OPTIONS_B

Line 5859: elsif ((l_share_flag = 2) and (l_proto_flag <> BSC_KPI_PUB.DELETE_KPI_FLAG)) then-- this is a shared indicator.

5855: WHERE INDICATOR = l_shared_kpi;
5856:
5857: END LOOP;
5858:
5859: elsif ((l_share_flag = 2) and (l_proto_flag <> BSC_KPI_PUB.DELETE_KPI_FLAG)) then-- this is a shared indicator.
5860:
5861: -- Get the source indicator for this shared indicator.
5862: select source_indicator
5863: into l_shared_kpi

Line 6103: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec

6099: ************************************************************************************/
6100:
6101: procedure Set_Default_Option_MG(
6102: p_commit IN varchar2 := FND_API.G_FALSE
6103: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_Kpi_Entity_Rec
6104: ,x_return_status OUT NOCOPY varchar2
6105: ,x_msg_count OUT NOCOPY number
6106: ,x_msg_data OUT NOCOPY varchar2
6107: ) is

Line 6128: IF (l_proto_flag <> BSC_KPI_PUB.Delete_Kpi_Flag) THEN

6124: INTO l_source_kpi, l_proto_flag
6125: FROM BSC_KPIS_B
6126: WHERE INDICATOR = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
6127:
6128: IF (l_proto_flag <> BSC_KPI_PUB.Delete_Kpi_Flag) THEN
6129: -- Get the number of analysis groups in this or in source kpi.
6130: select max(analysis_group_id)
6131: into l_group_count
6132: from BSC_KPI_ANALYSIS_GROUPS

Line 6314: p_Bsc_kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_kpi_Entity_Rec

6310: /************************************************************************************
6311: ************************************************************************************/
6312:
6313: procedure Assign_Analysis_Option(
6314: p_Bsc_kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_kpi_Entity_Rec
6315: ,x_return_status OUT NOCOPY varchar2
6316: ,x_msg_count OUT NOCOPY number
6317: ,x_msg_data OUT NOCOPY varchar2
6318: ) IS

Line 6323: l_Bsc_kpi_Entity_Rec BSC_KPI_PUB.Bsc_kpi_Entity_Rec;

6319:
6320: l_option_id number;
6321: l_parent_option_id number;
6322: l_grandparent_option_id number;
6323: l_Bsc_kpi_Entity_Rec BSC_KPI_PUB.Bsc_kpi_Entity_Rec;
6324:
6325: Begin
6326: FND_MSG_PUB.Initialize;
6327: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6431: p_Bsc_kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_kpi_Entity_Rec

6427: /************************************************************************************
6428: ************************************************************************************/
6429:
6430: procedure Unassign_Analysis_Option(
6431: p_Bsc_kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_kpi_Entity_Rec
6432: ,x_return_status OUT NOCOPY varchar2
6433: ,x_msg_count OUT NOCOPY number
6434: ,x_msg_data OUT NOCOPY varchar2
6435: ) IS

Line 6440: l_Bsc_kpi_Entity_Rec BSC_KPI_PUB.Bsc_kpi_Entity_Rec;

6436: l_option_id number;
6437: l_parent_option_id number;
6438: l_grandparent_option_id number;
6439: l_count number;
6440: l_Bsc_kpi_Entity_Rec BSC_KPI_PUB.Bsc_kpi_Entity_Rec;
6441: Begin
6442: FND_MSG_PUB.Initialize;
6443: x_return_status := FND_API.G_RET_STS_SUCCESS;
6444: SAVEPOINT BscKpiPvt_UnAssAnaOpts;

Line 6564: p_Bsc_kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_kpi_Entity_Rec

6560: /************************************************************************************
6561: ************************************************************************************/
6562:
6563: function Is_Analysis_Option_Selected(
6564: p_Bsc_kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_kpi_Entity_Rec
6565: ,x_return_status OUT NOCOPY varchar2
6566: ,x_msg_count OUT NOCOPY number
6567: ,x_msg_data OUT NOCOPY varchar2
6568: ) return varchar2 IS

Line 6574: l_Bsc_kpi_Entity_Rec BSC_KPI_PUB.Bsc_kpi_Entity_Rec;

6570: l_option_id number;
6571: l_parent_option_id number;
6572: l_grandparent_option_id number;
6573: l_count number;
6574: l_Bsc_kpi_Entity_Rec BSC_KPI_PUB.Bsc_kpi_Entity_Rec;
6575: l_temp varchar2(5);
6576: Begin
6577: FND_MSG_PUB.Initialize;
6578: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6689: p_Bsc_kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_kpi_Entity_Rec

6685: /************************************************************************************
6686: ************************************************************************************/
6687:
6688: function Is_Leaf_Analysis_Option(
6689: p_Bsc_kpi_Entity_Rec IN BSC_KPI_PUB.Bsc_kpi_Entity_Rec
6690: ,x_return_status OUT NOCOPY varchar2
6691: ,x_msg_count OUT NOCOPY number
6692: ,x_msg_data OUT NOCOPY varchar2
6693: ) return varchar2 IS

Line 6834: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC

6830: /********************************************************/
6831:
6832: PROCEDURE Delete_Ind_Cause_Effect_Rels(
6833: p_commit IN VARCHAR2 := FND_API.G_FALSE
6834: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
6835: ,x_return_status OUT NOCOPY VARCHAR2
6836: ,x_msg_count OUT NOCOPY NUMBER
6837: ,x_msg_data OUT NOCOPY VARCHAR2
6838: ) IS

Line 6869: AND NVL(cause_level,BSC_KPI_PUB.c_IND_LEVEL)=BSC_KPI_PUB.c_IND_LEVEL

6865:
6866: DELETE
6867: FROM bsc_kpi_cause_effect_rels
6868: WHERE cause_indicator =p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
6869: AND NVL(cause_level,BSC_KPI_PUB.c_IND_LEVEL)=BSC_KPI_PUB.c_IND_LEVEL
6870: AND NVL(effect_level,BSC_KPI_PUB.c_IND_LEVEL)=BSC_KPI_PUB.c_IND_LEVEL;
6871:
6872: DELETE
6873: FROM bsc_kpi_cause_effect_rels

Line 6870: AND NVL(effect_level,BSC_KPI_PUB.c_IND_LEVEL)=BSC_KPI_PUB.c_IND_LEVEL;

6866: DELETE
6867: FROM bsc_kpi_cause_effect_rels
6868: WHERE cause_indicator =p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
6869: AND NVL(cause_level,BSC_KPI_PUB.c_IND_LEVEL)=BSC_KPI_PUB.c_IND_LEVEL
6870: AND NVL(effect_level,BSC_KPI_PUB.c_IND_LEVEL)=BSC_KPI_PUB.c_IND_LEVEL;
6871:
6872: DELETE
6873: FROM bsc_kpi_cause_effect_rels
6874: WHERE effect_indicator =p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id

Line 6875: AND NVL(cause_level,BSC_KPI_PUB.c_IND_LEVEL)=BSC_KPI_PUB.c_IND_LEVEL

6871:
6872: DELETE
6873: FROM bsc_kpi_cause_effect_rels
6874: WHERE effect_indicator =p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
6875: AND NVL(cause_level,BSC_KPI_PUB.c_IND_LEVEL)=BSC_KPI_PUB.c_IND_LEVEL
6876: AND NVL(effect_level,BSC_KPI_PUB.c_IND_LEVEL)=BSC_KPI_PUB.c_IND_LEVEL;
6877:
6878:
6879: IF (p_commit = FND_API.G_TRUE) THEN

Line 6876: AND NVL(effect_level,BSC_KPI_PUB.c_IND_LEVEL)=BSC_KPI_PUB.c_IND_LEVEL;

6872: DELETE
6873: FROM bsc_kpi_cause_effect_rels
6874: WHERE effect_indicator =p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
6875: AND NVL(cause_level,BSC_KPI_PUB.c_IND_LEVEL)=BSC_KPI_PUB.c_IND_LEVEL
6876: AND NVL(effect_level,BSC_KPI_PUB.c_IND_LEVEL)=BSC_KPI_PUB.c_IND_LEVEL;
6877:
6878:
6879: IF (p_commit = FND_API.G_TRUE) THEN
6880: COMMIT;

Line 6937: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC

6933:
6934: PROCEDURE Delete_Ind_Shell_Cmds
6935: (
6936: p_commit IN VARCHAR2 := FND_API.G_FALSE
6937: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
6938: ,x_return_status OUT NOCOPY VARCHAR2
6939: ,x_msg_count OUT NOCOPY NUMBER
6940: ,x_msg_data OUT NOCOPY VARCHAR2
6941: ) IS

Line 7036: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC

7032:
7033: PROCEDURE Delete_Ind_MM_Controls
7034: (
7035: p_commit IN VARCHAR2 := FND_API.G_FALSE
7036: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
7037: ,x_return_status OUT NOCOPY VARCHAR2
7038: ,x_msg_count OUT NOCOPY NUMBER
7039: ,x_msg_data OUT NOCOPY VARCHAR2
7040: ) IS

Line 7129: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC

7125:
7126: PROCEDURE Delete_Ind_Subtitles
7127: (
7128: p_commit IN VARCHAR2 := FND_API.G_FALSE
7129: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
7130: ,x_return_status OUT NOCOPY VARCHAR2
7131: ,x_msg_count OUT NOCOPY NUMBER
7132: ,x_msg_data OUT NOCOPY VARCHAR2
7133: ) IS

Line 7223: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC

7219:
7220: PROCEDURE Delete_Ind_SeriesColors
7221: (
7222: p_commit IN VARCHAR2 := FND_API.G_FALSE
7223: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
7224: ,x_return_status OUT NOCOPY VARCHAR2
7225: ,x_msg_count OUT NOCOPY NUMBER
7226: ,x_msg_data OUT NOCOPY VARCHAR2
7227: ) IS

Line 7317: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC

7313:
7314: PROCEDURE Delete_Ind_Images
7315: (
7316: p_commit IN VARCHAR2 := FND_API.G_FALSE
7317: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
7318: ,x_return_status OUT NOCOPY VARCHAR2
7319: ,x_msg_count OUT NOCOPY NUMBER
7320: ,x_msg_data OUT NOCOPY VARCHAR2
7321: ) IS

Line 7422: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC

7418:
7419: PROCEDURE Delete_Ind_Sys_Prop
7420: (
7421: p_commit IN VARCHAR2 := FND_API.G_FALSE
7422: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
7423: ,x_return_status OUT NOCOPY VARCHAR2
7424: ,x_msg_count OUT NOCOPY NUMBER
7425: ,x_msg_data OUT NOCOPY VARCHAR2
7426: ) IS

Line 7469: WHERE source_type = BSC_KPI_PUB.c_IND_TYPE

7465: WHERE indicator=p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7466:
7467: DELETE
7468: FROM bsc_sys_labels_b
7469: WHERE source_type = BSC_KPI_PUB.c_IND_TYPE
7470: AND source_code = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7471:
7472: DELETE
7473: FROM bsc_sys_labels_tl

Line 7474: WHERE source_type = BSC_KPI_PUB.c_IND_TYPE

7470: AND source_code = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7471:
7472: DELETE
7473: FROM bsc_sys_labels_tl
7474: WHERE source_type = BSC_KPI_PUB.c_IND_TYPE
7475: AND source_code = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7476:
7477: DELETE
7478: FROM bsc_sys_lines

Line 7479: WHERE source_type = BSC_KPI_PUB.c_IND_TYPE

7475: AND source_code = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7476:
7477: DELETE
7478: FROM bsc_sys_lines
7479: WHERE source_type = BSC_KPI_PUB.c_IND_TYPE
7480: AND source_code = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7481:
7482: DELETE
7483: FROM bsc_sys_user_options

Line 7484: WHERE source_type = BSC_KPI_PUB.c_IND_TYPE

7480: AND source_code = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7481:
7482: DELETE
7483: FROM bsc_sys_user_options
7484: WHERE source_type = BSC_KPI_PUB.c_IND_TYPE
7485: AND source_code = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7486:
7487: IF (p_commit = FND_API.G_TRUE) THEN
7488: COMMIT;

Line 7544: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC

7540:
7541: PROCEDURE Delete_Ind_Comments
7542: (
7543: p_commit IN VARCHAR2 := FND_API.G_FALSE
7544: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
7545: ,x_return_status OUT NOCOPY VARCHAR2
7546: ,x_msg_count OUT NOCOPY NUMBER
7547: ,x_msg_data OUT NOCOPY VARCHAR2
7548: ) IS

Line 7637: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC

7633:
7634: PROCEDURE Delete_Ind_Tree_Nodes
7635: (
7636: p_commit IN VARCHAR2 := FND_API.G_FALSE
7637: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
7638: ,x_return_status OUT NOCOPY VARCHAR2
7639: ,x_msg_count OUT NOCOPY NUMBER
7640: ,x_msg_data OUT NOCOPY VARCHAR2
7641: ) IS

Line 7735: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC

7731:
7732: PROCEDURE Delete_Ind_User_Access
7733: (
7734: p_commit IN VARCHAR2 := FND_API.G_FALSE
7735: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
7736: ,x_return_status OUT NOCOPY VARCHAR2
7737: ,x_msg_count OUT NOCOPY NUMBER
7738: ,x_msg_data OUT NOCOPY VARCHAR2
7739: ) IS

Line 7830: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC

7826:
7827: PROCEDURE Delete_Sim_Tree_Data
7828: (
7829: p_commit IN VARCHAR2 := FND_API.G_FALSE
7830: ,p_Bsc_Kpi_Entity_Rec IN BSC_KPI_PUB.BSC_KPI_ENTITY_REC
7831: ,x_return_status OUT NOCOPY VARCHAR2
7832: ,x_msg_count OUT NOCOPY NUMBER
7833: ,x_msg_data OUT NOCOPY VARCHAR2
7834: ) IS