87: --: This procedure is part of the Data Set API.
88:
89: procedure Create_Measures(
90: p_commit IN varchar2 := FND_API.G_FALSE
91: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
92: ,x_return_status OUT NOCOPY varchar2
93: ,x_msg_count OUT NOCOPY number
94: ,x_msg_data OUT NOCOPY varchar2
95: ) is
96:
97: l_count number;
98: l_count_mescol number;
99: l_color_formula varchar2(200);
100: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
101:
102: begin
103: l_Dataset_Rec := p_Dataset_Rec;
104:
251: ************************************************************************************/
252:
253: procedure Retrieve_Measures(
254: p_commit IN varchar2 := FND_API.G_FALSE
255: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
256: ,x_Dataset_Rec IN OUT NOCOPY BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
257: ,x_return_status OUT NOCOPY varchar2
258: ,x_msg_count OUT NOCOPY number
259: ,x_msg_data OUT NOCOPY varchar2
252:
253: procedure Retrieve_Measures(
254: p_commit IN varchar2 := FND_API.G_FALSE
255: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
256: ,x_Dataset_Rec IN OUT NOCOPY BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
257: ,x_return_status OUT NOCOPY varchar2
258: ,x_msg_count OUT NOCOPY number
259: ,x_msg_data OUT NOCOPY varchar2
260: ) is
444: ************************************************************************************/
445:
446: procedure Update_Measures(
447: p_commit IN varchar2 := FND_API.G_FALSE
448: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
449: ,x_return_status OUT NOCOPY varchar2
450: ,x_msg_count OUT NOCOPY number
451: ,x_msg_data OUT NOCOPY varchar2
452: ) is
450: ,x_msg_count OUT NOCOPY number
451: ,x_msg_data OUT NOCOPY varchar2
452: ) is
453:
454: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
455:
456: l_count number;
457: l_color_formula varchar2(200);
458: l_count_mescol number;
722: ************************************************************************************/
723:
724: PROCEDURE Delete_Measures(
725: p_commit IN VARCHAR2 := FND_API.G_FALSE
726: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
727: ,x_return_status OUT NOCOPY VARCHAR2
728: ,x_msg_count OUT NOCOPY NUMBER
729: ,x_msg_data OUT NOCOPY VARCHAR2
730: ) IS
880: /*
881:
882: procedure Create_Formats(
883: p_commit IN varchar2 := FND_API.G_FALSE
884: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
885: ,x_return_status OUT NOCOPY varchar2
886: ,x_msg_count OUT NOCOPY number
887: ,x_msg_data OUT NOCOPY varchar2
888: ) is
923: /*
924:
925: procedure Delete_Formats(
926: p_commit IN varchar2 := FND_API.G_FALSE
927: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
928: ,x_return_status OUT NOCOPY varchar2
929: ,x_msg_count OUT NOCOPY number
930: ,x_msg_data OUT NOCOPY varchar2
931: ) is
968: --: This procedure is part of the Data Set API.
969:
970: procedure Create_Dataset(
971: p_commit IN varchar2 := FND_API.G_FALSE
972: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
973: ,x_return_status OUT NOCOPY varchar2
974: ,x_msg_count OUT NOCOPY number
975: ,x_msg_data OUT NOCOPY varchar2
976: ) is
975: ,x_msg_data OUT NOCOPY varchar2
976: ) is
977:
978: l_count number;
979: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
980:
981: begin
982: l_Dataset_Rec := p_Dataset_Rec;
983:
1104: ************************************************************************************/
1105:
1106: procedure Retrieve_Dataset(
1107: p_commit IN varchar2 := FND_API.G_FALSE
1108: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1109: ,x_Dataset_Rec IN OUT NOCOPY BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1110: ,x_return_status OUT NOCOPY varchar2
1111: ,x_msg_count OUT NOCOPY number
1112: ,x_msg_data OUT NOCOPY varchar2
1105:
1106: procedure Retrieve_Dataset(
1107: p_commit IN varchar2 := FND_API.G_FALSE
1108: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1109: ,x_Dataset_Rec IN OUT NOCOPY BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1110: ,x_return_status OUT NOCOPY varchar2
1111: ,x_msg_count OUT NOCOPY number
1112: ,x_msg_data OUT NOCOPY varchar2
1113: ) is
1184: ************************************************************************************/
1185:
1186: procedure Update_Dataset(
1187: p_commit IN varchar2 := FND_API.G_FALSE
1188: , p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1189: ,x_return_status OUT NOCOPY varchar2
1190: ,x_msg_count OUT NOCOPY number
1191: ,x_msg_data OUT NOCOPY varchar2
1192: ) is
1190: ,x_msg_count OUT NOCOPY number
1191: ,x_msg_data OUT NOCOPY varchar2
1192: ) is
1193:
1194: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
1195:
1196: l_count number;
1197: l_Old_Format_id number;
1198: l_indicator_table BSC_NUM_LIST;
1491: ************************************************************************************/
1492:
1493: procedure Delete_Dataset(
1494: p_commit IN varchar2 := FND_API.G_FALSE
1495: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1496: ,x_return_status OUT NOCOPY varchar2
1497: ,x_msg_count OUT NOCOPY number
1498: ,x_msg_data OUT NOCOPY varchar2
1499: ) is
1619: --: This procedure is part of the Data Set API.
1620:
1621: procedure Create_Dataset_Calc(
1622: p_commit IN varchar2 := FND_API.G_FALSE
1623: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1624: ,x_return_status OUT NOCOPY varchar2
1625: ,x_msg_count OUT NOCOPY number
1626: ,x_msg_data OUT NOCOPY varchar2
1627: ) is
1701: ************************************************************************************/
1702:
1703: procedure Retrieve_Dataset_Calc(
1704: p_commit IN varchar2 := FND_API.G_FALSE
1705: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1706: ,x_Dataset_Rec IN OUT NOCOPY BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1707: ,x_return_status OUT NOCOPY varchar2
1708: ,x_msg_count OUT NOCOPY number
1709: ,x_msg_data OUT NOCOPY varchar2
1702:
1703: procedure Retrieve_Dataset_Calc(
1704: p_commit IN varchar2 := FND_API.G_FALSE
1705: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1706: ,x_Dataset_Rec IN OUT NOCOPY BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1707: ,x_return_status OUT NOCOPY varchar2
1708: ,x_msg_count OUT NOCOPY number
1709: ,x_msg_data OUT NOCOPY varchar2
1710: ) is
1748: ************************************************************************************/
1749:
1750: procedure Update_Dataset_Calc(
1751: p_commit IN varchar2 := FND_API.G_FALSE
1752: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1753: ,x_return_status OUT NOCOPY varchar2
1754: ,x_msg_count OUT NOCOPY number
1755: ,x_msg_data OUT NOCOPY varchar2
1756: ) is
1813: ************************************************************************************/
1814:
1815: procedure Delete_Dataset_Calc(
1816: p_commit IN varchar2 := FND_API.G_FALSE
1817: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1818: ,x_return_status OUT NOCOPY varchar2
1819: ,x_msg_count OUT NOCOPY number
1820: ,x_msg_data OUT NOCOPY varchar2
1821: ) is
1911: --=============================================================================
1912: PROCEDURE Translate_Measure
1913: ( p_commit IN VARCHAR2
1914: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
1915: , p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1916: , x_return_status OUT NOCOPY VARCHAR2
1917: , x_msg_count OUT NOCOPY NUMBER
1918: , x_msg_data OUT NOCOPY VARCHAR2
1919: )
1963:
1964: -- mdamle 09/25/2003 - Sync up measures for all installed languages
1965: PROCEDURE Translate_Measure_By_lang
1966: ( p_commit IN VARCHAR2
1967: , p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type
1968: , p_lang IN VARCHAR2
1969: , p_source_lang IN VARCHAR2
1970: , x_return_status OUT NOCOPY VARCHAR2
1971: , x_msg_count OUT NOCOPY NUMBER