APPS.BSC_DIMENSION_SETS_PVT dependencies on BSC_DIMENSION_SETS_PUB

Line 52: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

48: --: This procedure is part of the Dimension Set API.
49:
50: procedure Create_Dim_Group_In_Dset(
51: p_commit IN varchar2 := FND_API.G_FALSE
52: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
53: ,x_return_status OUT NOCOPY varchar2
54: ,x_msg_count OUT NOCOPY number
55: ,x_msg_data OUT NOCOPY varchar2
56: ) is

Line 143: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

139: ************************************************************************************/
140:
141: procedure Retrieve_Dim_Group_In_Dset(
142: p_commit IN varchar2 := FND_API.G_FALSE
143: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
144: ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
145: ,x_return_status OUT NOCOPY varchar2
146: ,x_msg_count OUT NOCOPY number
147: ,x_msg_data OUT NOCOPY varchar2

Line 144: ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

140:
141: procedure Retrieve_Dim_Group_In_Dset(
142: p_commit IN varchar2 := FND_API.G_FALSE
143: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
144: ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
145: ,x_return_status OUT NOCOPY varchar2
146: ,x_msg_count OUT NOCOPY number
147: ,x_msg_data OUT NOCOPY varchar2
148: ) is

Line 209: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

205: ************************************************************************************/
206:
207: procedure Update_Dim_Group_In_Dset(
208: p_commit IN varchar2 := FND_API.G_FALSE
209: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
210: ,x_return_status OUT NOCOPY varchar2
211: ,x_msg_count OUT NOCOPY number
212: ,x_msg_data OUT NOCOPY varchar2
213: ) is

Line 215: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;

211: ,x_msg_count OUT NOCOPY number
212: ,x_msg_data OUT NOCOPY varchar2
213: ) is
214:
215: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
216:
217: l_count number;
218:
219: begin

Line 341: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

337: ************************************************************************************/
338:
339: procedure Delete_Dim_Group_In_Dset(
340: p_commit IN varchar2 := FND_API.G_FALSE
341: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
342: ,x_return_status OUT NOCOPY varchar2
343: ,x_msg_count OUT NOCOPY number
344: ,x_msg_data OUT NOCOPY varchar2
345: ) is

Line 450: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

446: --: This procedure belongs to the Dimension Set API.
447:
448: procedure Create_Bsc_Kpi_Dim_Sets_Tl(
449: p_commit IN varchar2 := FND_API.G_FALSE
450: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
451: ,x_return_status OUT NOCOPY varchar2
452: ,x_msg_count OUT NOCOPY number
453: ,x_msg_data OUT NOCOPY varchar2
454: ) is

Line 456: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;

452: ,x_msg_count OUT NOCOPY number
453: ,x_msg_data OUT NOCOPY varchar2
454: ) is
455:
456: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
457:
458: l_count number;
459:
460: begin

Line 603: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

599: ************************************************************************************/
600:
601: procedure Retrieve_Bsc_Kpi_Dim_Sets_Tl(
602: p_commit IN varchar2 := FND_API.G_FALSE
603: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
604: ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
605: ,x_return_status OUT NOCOPY varchar2
606: ,x_msg_count OUT NOCOPY number
607: ,x_msg_data OUT NOCOPY varchar2

Line 604: ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

600:
601: procedure Retrieve_Bsc_Kpi_Dim_Sets_Tl(
602: p_commit IN varchar2 := FND_API.G_FALSE
603: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
604: ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
605: ,x_return_status OUT NOCOPY varchar2
606: ,x_msg_count OUT NOCOPY number
607: ,x_msg_data OUT NOCOPY varchar2
608: ) is

Line 682: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

678: ************************************************************************************/
679:
680: procedure Update_Bsc_Kpi_Dim_Sets_Tl(
681: p_commit IN varchar2 := FND_API.G_FALSE
682: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
683: ,x_return_status OUT NOCOPY varchar2
684: ,x_msg_count OUT NOCOPY number
685: ,x_msg_data OUT NOCOPY varchar2
686: ) is

Line 688: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;

684: ,x_msg_count OUT NOCOPY number
685: ,x_msg_data OUT NOCOPY varchar2
686: ) is
687:
688: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
689:
690: l_count number;
691:
692: begin

Line 809: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

805: ************************************************************************************/
806:
807: procedure Delete_Bsc_Kpi_Dim_Sets_Tl(
808: p_commit IN varchar2 := FND_API.G_FALSE
809: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
810: ,x_return_status OUT NOCOPY varchar2
811: ,x_msg_count OUT NOCOPY number
812: ,x_msg_data OUT NOCOPY varchar2
813: ) is

Line 891: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

887: --: This procedure belongs to the Dimension Set API.
888:
889: procedure Create_Dim_Level_Properties(
890: p_commit IN varchar2 := FND_API.G_FALSE
891: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
892: ,x_return_status OUT NOCOPY varchar2
893: ,x_msg_count OUT NOCOPY number
894: ,x_msg_data OUT NOCOPY varchar2
895: ) is

Line 1004: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

1000: ************************************************************************************/
1001:
1002: procedure Retrieve_Dim_Level_Properties(
1003: p_commit IN varchar2 := FND_API.G_FALSE
1004: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
1005: ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
1006: ,x_return_status OUT NOCOPY varchar2
1007: ,x_msg_count OUT NOCOPY number
1008: ,x_msg_data OUT NOCOPY varchar2

Line 1005: ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

1001:
1002: procedure Retrieve_Dim_Level_Properties(
1003: p_commit IN varchar2 := FND_API.G_FALSE
1004: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
1005: ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
1006: ,x_return_status OUT NOCOPY varchar2
1007: ,x_msg_count OUT NOCOPY number
1008: ,x_msg_data OUT NOCOPY varchar2
1009: ) is

Line 1087: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

1083: ************************************************************************************/
1084:
1085: procedure Update_Dim_Level_Properties(
1086: p_commit IN varchar2 := FND_API.G_FALSE
1087: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
1088: ,x_return_status OUT NOCOPY varchar2
1089: ,x_msg_count OUT NOCOPY number
1090: ,x_msg_data OUT NOCOPY varchar2
1091: ) is

Line 1093: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;

1089: ,x_msg_count OUT NOCOPY number
1090: ,x_msg_data OUT NOCOPY varchar2
1091: ) is
1092:
1093: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
1094:
1095: l_count number;
1096:
1097: begin

Line 1262: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

1258: ************************************************************************************/
1259:
1260: procedure Delete_Dim_Level_Properties(
1261: p_commit IN varchar2 := FND_API.G_FALSE
1262: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
1263: ,x_return_status OUT NOCOPY varchar2
1264: ,x_msg_count OUT NOCOPY number
1265: ,x_msg_data OUT NOCOPY varchar2
1266: ) is

Line 1366: , p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

1362: --: This procedure is part of the Dimension Set API.
1363:
1364: PROCEDURE Create_Dim_Levels
1365: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
1366: , p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
1367: , x_return_status OUT NOCOPY VARCHAR2
1368: , x_msg_count OUT NOCOPY NUMBER
1369: , x_msg_data OUT NOCOPY VARCHAR2
1370: ) IS

Line 1374: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;

1370: ) IS
1371:
1372: l_count NUMBER;
1373: kpi_dim_set_exists EXCEPTION;
1374: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
1375:
1376: CURSOR c_dim_sys_levels_tl IS
1377: SELECT Name
1378: , Help

Line 1586: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

1582: ************************************************************************************/
1583:
1584: procedure Retrieve_Dim_Levels(
1585: p_commit IN varchar2 := FND_API.G_FALSE
1586: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
1587: ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
1588: ,x_return_status OUT NOCOPY varchar2
1589: ,x_msg_count OUT NOCOPY number
1590: ,x_msg_data OUT NOCOPY varchar2

Line 1587: ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

1583:
1584: procedure Retrieve_Dim_Levels(
1585: p_commit IN varchar2 := FND_API.G_FALSE
1586: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
1587: ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
1588: ,x_return_status OUT NOCOPY varchar2
1589: ,x_msg_count OUT NOCOPY number
1590: ,x_msg_data OUT NOCOPY varchar2
1591: ) is

Line 1723: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

1719: ************************************************************************************/
1720:
1721: procedure Update_Dim_Levels(
1722: p_commit IN varchar2 := FND_API.G_FALSE
1723: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
1724: ,x_return_status OUT NOCOPY varchar2
1725: ,x_msg_count OUT NOCOPY number
1726: ,x_msg_data OUT NOCOPY varchar2
1727: ) is

Line 1729: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;

1725: ,x_msg_count OUT NOCOPY number
1726: ,x_msg_data OUT NOCOPY varchar2
1727: ) is
1728:
1729: l_Dim_Set_Rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
1730:
1731: l_count number;
1732:
1733: begin

Line 1997: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

1993: ************************************************************************************/
1994:
1995: procedure Delete_Dim_Levels(
1996: p_commit IN varchar2 := FND_API.G_FALSE
1997: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
1998: ,x_return_status OUT NOCOPY varchar2
1999: ,x_msg_count OUT NOCOPY number
2000: ,x_msg_data OUT NOCOPY varchar2
2001: ) is

Line 2115: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type

2111: --: This procedure is part of the Dimension Set API.
2112:
2113: procedure Update_Kpi_Analysis_Options_B(
2114: p_commit IN varchar2 := FND_API.G_FALSE
2115: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
2116: ,x_return_status OUT NOCOPY varchar2
2117: ,x_msg_count OUT NOCOPY number
2118: ,x_msg_data OUT NOCOPY varchar2
2119: ) is