DBA Data[Home] [Help]

APPS.BSC_DATASETS_PVT dependencies on BSC_DATASETS_PUB

Line 91: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

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

Line 100: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;

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:

Line 255: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

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

Line 256: ,x_Dataset_Rec IN OUT NOCOPY BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

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

Line 448: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

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

Line 454: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;

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;

Line 726: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

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

Line 884: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

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

Line 927: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

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

Line 972: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

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

Line 979: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;

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:

Line 1108: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

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

Line 1109: ,x_Dataset_Rec IN OUT NOCOPY BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

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

Line 1188: , p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

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

Line 1194: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;

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;

Line 1495: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

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

Line 1623: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

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

Line 1705: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

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

Line 1706: ,x_Dataset_Rec IN OUT NOCOPY BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

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

Line 1752: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

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

Line 1817: ,p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

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

Line 1915: , p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

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: )

Line 1967: , p_Dataset_Rec IN BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type

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