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_DIMENSION_LEVELS_PVT dependencies on FND_API

Line 39: p_commit IN varchar2 := FND_API.G_FALSE

35: -- Procedure to Create all pertaining information for a given Dimension Level.
36: -- Though all procedures in this package may be called individually, this
37: -- procedure is the entry point to populate all meta data for dimension levels.
38: procedure Create_Dim_Level(
39: p_commit IN varchar2 := FND_API.G_FALSE
40: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
41: ,x_return_status OUT NOCOPY varchar2
42: ,x_msg_count OUT NOCOPY number
43: ,x_msg_data OUT NOCOPY varchar2

Line 47: p_commit IN varchar2 := FND_API.G_FALSE

43: ,x_msg_data OUT NOCOPY varchar2
44: );
45:
46: procedure Retrieve_Dim_Level(
47: p_commit IN varchar2 := FND_API.G_FALSE
48: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
49: ,x_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
50: ,x_return_status OUT NOCOPY varchar2
51: ,x_msg_count OUT NOCOPY number

Line 56: p_commit IN varchar2 := FND_API.G_FALSE

52: ,x_msg_data OUT NOCOPY varchar2
53: );
54:
55: procedure Update_Dim_Level(
56: p_commit IN varchar2 := FND_API.G_FALSE
57: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
58: ,x_return_status OUT NOCOPY varchar2
59: ,x_msg_count OUT NOCOPY number
60: ,x_msg_data OUT NOCOPY varchar2

Line 67: p_commit IN varchar2 := FND_API.G_FALSE

63: -- Procedure to Delete all pertaining information for a given Dimension Level.
64: -- Though all procedures in this package may be called individually, this
65: -- procedure is the entry point to delete all meta data for dimension levels.
66: procedure Delete_Dim_Level(
67: p_commit IN varchar2 := FND_API.G_FALSE
68: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
69: ,x_return_status OUT NOCOPY varchar2
70: ,x_msg_count OUT NOCOPY number
71: ,x_msg_data OUT NOCOPY varchar2

Line 76: p_commit IN varchar2 := FND_API.G_FALSE

72: );
73:
74: -- Procedure to Populate the necessary meta data in BSC for a dimension level.
75: procedure Create_Bsc_Dim_Levels_Md(
76: p_commit IN varchar2 := FND_API.G_FALSE
77: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
78: ,x_return_status OUT NOCOPY varchar2
79: ,x_msg_count OUT NOCOPY number
80: ,x_msg_data OUT NOCOPY varchar2

Line 84: p_commit IN varchar2 := FND_API.G_FALSE

80: ,x_msg_data OUT NOCOPY varchar2
81: );
82:
83: procedure Retrieve_Bsc_Dim_Levels_Md(
84: p_commit IN varchar2 := FND_API.G_FALSE
85: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
86: ,x_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
87: ,x_return_status OUT NOCOPY varchar2
88: ,x_msg_count OUT NOCOPY number

Line 93: p_commit IN varchar2 := FND_API.G_FALSE

89: ,x_msg_data OUT NOCOPY varchar2
90: );
91:
92: procedure Update_Bsc_Dim_Levels_Md(
93: p_commit IN varchar2 := FND_API.G_FALSE
94: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
95: ,x_return_status OUT NOCOPY varchar2
96: ,x_msg_count OUT NOCOPY number
97: ,x_msg_data OUT NOCOPY varchar2

Line 102: p_commit IN varchar2 := FND_API.G_FALSE

98: );
99:
100: -- Procedure to Delete the necessary meta data in BSC for a dimension level.
101: procedure Delete_Bsc_Dim_Levels_Md(
102: p_commit IN varchar2 := FND_API.G_FALSE
103: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
104: ,x_return_status OUT NOCOPY varchar2
105: ,x_msg_count OUT NOCOPY number
106: ,x_msg_data OUT NOCOPY varchar2

Line 112: p_commit IN varchar2 := FND_API.G_FALSE

108:
109: -- Procedure to Populate information on the columns for the dimension level
110: -- view or table.
111: procedure Create_Bsc_Sys_Dim_Lvl_Cols(
112: p_commit IN varchar2 := FND_API.G_FALSE
113: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
114: ,x_return_status OUT NOCOPY varchar2
115: ,x_msg_count OUT NOCOPY number
116: ,x_msg_data OUT NOCOPY varchar2

Line 120: p_commit IN varchar2 := FND_API.G_FALSE

116: ,x_msg_data OUT NOCOPY varchar2
117: );
118:
119: procedure Retrieve_Bsc_Sys_Dim_Lvl_Cols(
120: p_commit IN varchar2 := FND_API.G_FALSE
121: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
122: ,x_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
123: ,x_return_status OUT NOCOPY varchar2
124: ,x_msg_count OUT NOCOPY number

Line 129: p_commit IN varchar2 := FND_API.G_FALSE

125: ,x_msg_data OUT NOCOPY varchar2
126: );
127:
128: procedure Update_Bsc_Sys_Dim_Lvl_Cols(
129: p_commit IN varchar2 := FND_API.G_FALSE
130: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
131: ,x_return_status OUT NOCOPY varchar2
132: ,x_msg_count OUT NOCOPY number
133: ,x_msg_data OUT NOCOPY varchar2

Line 139: p_commit IN varchar2 := FND_API.G_FALSE

135:
136: -- Procedure to Delete information on the columns for the dimension level
137: -- view or table.
138: procedure Delete_Bsc_Sys_Dim_Lvl_Cols(
139: p_commit IN varchar2 := FND_API.G_FALSE
140: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
141: ,x_return_status OUT NOCOPY varchar2
142: ,x_msg_count OUT NOCOPY number
143: ,x_msg_data OUT NOCOPY varchar2

Line 189: p_commit IN varchar2 := FND_API.G_FALSE

185: -- Procedures to Handle Relationships between Dimension Levels
186: **********************************************************************************/
187: ---------
188: PROCEDURE Create_Dim_Level_Relation(
189: p_commit IN varchar2 := FND_API.G_FALSE
190: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
191: ,x_return_status OUT NOCOPY varchar2
192: ,x_msg_count OUT NOCOPY number
193: ,x_msg_data OUT NOCOPY varchar2

Line 197: p_commit IN varchar2 := FND_API.G_FALSE

193: ,x_msg_data OUT NOCOPY varchar2
194: );
195: ----------
196: PROCEDURE Delete_Dim_Level_Relation(
197: p_commit IN varchar2 := FND_API.G_FALSE
198: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
199: ,x_return_status OUT NOCOPY varchar2
200: ,x_msg_count OUT NOCOPY number
201: ,x_msg_data OUT NOCOPY varchar2

Line 224: p_commit IN varchar2 := FND_API.G_FALSE

220: p_Short_Name IN varchar2
221: ) RETURN number;
222: ----------
223: PROCEDURE Create_BSC_Dim_Level_View (
224: p_commit IN varchar2 := FND_API.G_FALSE
225: ,p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
226: ,x_return_status OUT NOCOPY varchar2
227: ,x_msg_count OUT NOCOPY number
228: ,x_msg_data OUT NOCOPY varchar2

Line 255: p_Commit IN VARCHAR2 := FND_API.G_FALSE

251: /*********************************************************************************
252: **********************************************************************************/
253:
254: PROCEDURE Translate_Dimension_Level (
255: p_Commit IN VARCHAR2 := FND_API.G_FALSE
256: ,p_Bsc_Pmf_Dim_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type
257: ,p_Bsc_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
258: ,x_return_status OUT NOCOPY VARCHAR2
259: ,x_msg_count OUT NOCOPY NUMBER

Line 265: ( p_commit IN VARCHAR2 := FND_API.G_FALSE

261: );
262: --
263:
264: procedure Trans_DimObj_By_Given_Lang
265: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
266: , p_dim_level_rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
267: , x_return_status OUT NOCOPY VARCHAR2
268: , x_msg_count OUT NOCOPY NUMBER
269: , x_msg_data OUT NOCOPY VARCHAR2