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_BIS_DIM_OBJ_PUB dependencies on BSC_DIMENSION_LEVELS_PUB

Line 152: ( p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

148: FUNCTION TO ALTER
149: M x N Tables
150: ********************************************************************************/
151: FUNCTION Alter_M_By_N_Tables
152: ( p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
153: , p_Dim_Level_Rec_Old IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
154: , x_return_status OUT NOCOPY VARCHAR2
155: , x_msg_count OUT NOCOPY NUMBER
156: , x_msg_data OUT NOCOPY VARCHAR2

Line 153: , p_Dim_Level_Rec_Old IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

149: M x N Tables
150: ********************************************************************************/
151: FUNCTION Alter_M_By_N_Tables
152: ( p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
153: , p_Dim_Level_Rec_Old IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
154: , x_return_status OUT NOCOPY VARCHAR2
155: , x_msg_count OUT NOCOPY NUMBER
156: , x_msg_data OUT NOCOPY VARCHAR2
157: )

Line 171: ( p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

167: /*******************************************************************************
168: FUNCTION TO ALTER One x N Child Tables
169: ********************************************************************************/
170: FUNCTION Alter_One_By_N_Tables
171: ( p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
172: , p_Dim_Level_Rec_Old IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
173: , x_return_status OUT NOCOPY VARCHAR2
174: , x_msg_count OUT NOCOPY NUMBER
175: , x_msg_data OUT NOCOPY VARCHAR2

Line 172: , p_Dim_Level_Rec_Old IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

168: FUNCTION TO ALTER One x N Child Tables
169: ********************************************************************************/
170: FUNCTION Alter_One_By_N_Tables
171: ( p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
172: , p_Dim_Level_Rec_Old IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
173: , x_return_status OUT NOCOPY VARCHAR2
174: , x_msg_count OUT NOCOPY NUMBER
175: , x_msg_data OUT NOCOPY VARCHAR2
176: )

Line 182: ( p_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

178: /*******************************************************************************
179: FUNCTION TO CREATE BSC DIMENSION OBJECTS MASTER TABLES
180: ********************************************************************************/
181: FUNCTION Create_Bsc_Master_Tabs
182: ( p_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
183: , x_return_status OUT NOCOPY VARCHAR2
184: , x_msg_count OUT NOCOPY NUMBER
185: , x_msg_data OUT NOCOPY VARCHAR2
186: )

Line 192: ( p_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

188: /*******************************************************************************
189: FUNCTION TO ALTER BSC DIMENSION OBJECTS MASTER TABLES
190: ********************************************************************************/
191: FUNCTION Alter_Bsc_Master_Tabs
192: ( p_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
193: , p_Dim_Level_Rec_Old IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
194: , x_return_status OUT NOCOPY VARCHAR2
195: , x_msg_count OUT NOCOPY NUMBER
196: , x_msg_data OUT NOCOPY VARCHAR2

Line 193: , p_Dim_Level_Rec_Old IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

189: FUNCTION TO ALTER BSC DIMENSION OBJECTS MASTER TABLES
190: ********************************************************************************/
191: FUNCTION Alter_Bsc_Master_Tabs
192: ( p_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
193: , p_Dim_Level_Rec_Old IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
194: , x_return_status OUT NOCOPY VARCHAR2
195: , x_msg_count OUT NOCOPY NUMBER
196: , x_msg_data OUT NOCOPY VARCHAR2
197: )

Line 203: ( p_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

199: /*******************************************************************************
200: FUNCTION TO CREATE PMF DIMENSION-OBJ VIEWS
201: ********************************************************************************/
202: FUNCTION Create_Pmf_Views
203: ( p_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
204: , x_return_status OUT NOCOPY VARCHAR2
205: , x_msg_count OUT NOCOPY NUMBER
206: , x_msg_data OUT NOCOPY VARCHAR2
207: )

Line 307: ( p_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

303: /*******************************************************************************
304: FUNCTION TO INITIALIZE BSC RECORDS
305: ********************************************************************************/
306: FUNCTION Initialize_Bsc_Recs
307: ( p_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
308: , x_return_status OUT NOCOPY VARCHAR2
309: , x_msg_count OUT NOCOPY NUMBER
310: , x_msg_data OUT NOCOPY VARCHAR2
311: ) RETURN BOOLEAN;

Line 878: l_bsc_dim_obj_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;

874: , x_return_status OUT NOCOPY VARCHAR2
875: , x_msg_count OUT NOCOPY NUMBER
876: , x_msg_data OUT NOCOPY VARCHAR2
877: ) IS
878: l_bsc_dim_obj_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
879: l_bis_dim_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
880: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
881: l_level_table_name BIS_LEVELS.LEVEL_VALUES_VIEW_NAME%TYPE;
882: l_bis_short_name BIS_LEVELS.Short_Name%TYPE;

Line 1373: BSC_DIMENSION_LEVELS_PUB.Create_Dim_Level

1369: IF (l_bsc_dim_obj_rec.Bsc_Source = 'PMF') THEN
1370: l_level_table_name := l_bsc_dim_obj_rec.Bsc_Level_Name;
1371: l_bsc_dim_obj_rec.Bsc_Level_Name := l_bsc_dim_obj_rec.Bsc_Level_View_Name;
1372: END IF;
1373: BSC_DIMENSION_LEVELS_PUB.Create_Dim_Level
1374: ( p_commit => FND_API.G_FALSE
1375: , p_Dim_Level_Rec => l_bsc_dim_obj_rec
1376: , p_create_tables => FALSE
1377: , x_return_status => x_return_status

Line 2051: l_bsc_dim_obj_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;

2047: , x_msg_data OUT NOCOPY VARCHAR2
2048: ) IS
2049: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2050: l_bis_dim_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
2051: l_bsc_dim_obj_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
2052: l_bsc_drop_tables BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
2053: l_MTab_Tbl BSC_BIS_DIM_OBJ_PUB.KPI_Dim_Set_Table_Type;
2054:
2055: l_temp_var BSC_SYS_DIM_LEVELS_B.abbreviation%TYPE;

Line 2052: l_bsc_drop_tables BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;

2048: ) IS
2049: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2050: l_bis_dim_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
2051: l_bsc_dim_obj_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
2052: l_bsc_drop_tables BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
2053: l_MTab_Tbl BSC_BIS_DIM_OBJ_PUB.KPI_Dim_Set_Table_Type;
2054:
2055: l_temp_var BSC_SYS_DIM_LEVELS_B.abbreviation%TYPE;
2056: l_source_table VARCHAR(33);

Line 2645: BSC_DIMENSION_LEVELS_PUB.Update_Dim_Level

2641: IF (l_bsc_dim_obj_rec.Bsc_Source = 'PMF') THEN
2642: l_level_table_name := l_bsc_dim_obj_rec.Bsc_Level_Name;
2643: l_bsc_dim_obj_rec.Bsc_Level_Name := l_bsc_dim_obj_rec.Bsc_Level_View_Name;
2644: END IF;
2645: BSC_DIMENSION_LEVELS_PUB.Update_Dim_Level
2646: ( p_commit => FND_API.G_FALSE
2647: , p_Dim_Level_Rec => l_bsc_dim_obj_rec
2648: , x_return_status => x_return_status
2649: , x_msg_count => x_msg_count

Line 2769: BSC_DIMENSION_LEVELS_PUB.Drop_Dim_Level_Tabs

2765: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2767: END IF;
2768: IF ((l_create_pmf) AND (l_bsc_dim_obj_rec.Bsc_Source = 'PMF')) THEN
2769: BSC_DIMENSION_LEVELS_PUB.Drop_Dim_Level_Tabs
2770: ( p_Dim_Level_Rec => l_bsc_drop_tables
2771: , x_return_status => x_return_status
2772: , x_msg_count => x_msg_count
2773: , x_msg_data => x_msg_data

Line 3209: l_bsc_dim_obj_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;

3205: , x_msg_count OUT NOCOPY NUMBER
3206: , x_msg_data OUT NOCOPY VARCHAR2
3207: ) IS
3208: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
3209: l_bsc_dim_obj_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
3210: l_bis_dim_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
3211: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3212: l_count NUMBER;
3213: l_dim_short_name VARCHAR2(30);

Line 3321: BSC_DIMENSION_LEVELS_PUB.Delete_Dim_Level

3317: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3319: END IF;
3320: --CALL BSC API
3321: BSC_DIMENSION_LEVELS_PUB.Delete_Dim_Level
3322: ( p_commit => FND_API.G_FALSE
3323: , p_Dim_Level_Rec => l_bsc_dim_obj_rec
3324: , x_return_status => x_return_status
3325: , x_msg_count => x_msg_count

Line 3638: ( p_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

3634: /*******************************************************************************
3635: FUNCTION TO INITIALIZE BSC RECORDS
3636: ********************************************************************************/
3637: FUNCTION Initialize_Bsc_Recs
3638: ( p_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
3639: , x_return_status OUT NOCOPY VARCHAR2
3640: , x_msg_count OUT NOCOPY NUMBER
3641: , x_msg_data OUT NOCOPY VARCHAR2
3642: )

Line 3776: ( p_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

3772: /*******************************************************************************
3773: FUNCTION TO INTIALIZE PMF DIMENSION RECORDS
3774: ********************************************************************************/
3775: FUNCTION Initialize_Pmf_Recs
3776: ( p_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
3777: , x_return_status OUT NOCOPY VARCHAR2
3778: , x_msg_count OUT NOCOPY NUMBER
3779: , x_msg_data OUT NOCOPY VARCHAR2
3780: )

Line 4045: ( p_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

4041: FUNCTION TO CREATE PMF DIMENSION-OBJ VIEWS
4042: ********************************************************************************/
4043:
4044: FUNCTION Create_Pmf_Views
4045: ( p_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
4046: , x_return_status OUT NOCOPY VARCHAR2
4047: , x_msg_count OUT NOCOPY NUMBER
4048: , x_msg_data OUT NOCOPY VARCHAR2
4049: )

Line 4223: ( p_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

4219: /*******************************************************************************
4220: FUNCTION TO CREATE BSC DIMENSIONS
4221: ********************************************************************************/
4222: FUNCTION Create_Bsc_Master_Tabs
4223: ( p_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
4224: , x_return_status OUT NOCOPY VARCHAR2
4225: , x_msg_count OUT NOCOPY NUMBER
4226: , x_msg_data OUT NOCOPY VARCHAR2
4227: )

Line 4515: ( p_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

4511: /*******************************************************************************
4512: FUNCTION TO ALTER BSC DIMENSION OBJECTS MASTER TABLES
4513: ********************************************************************************/
4514: FUNCTION Alter_Bsc_Master_Tabs
4515: ( p_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
4516: , p_Dim_Level_Rec_Old IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
4517: , x_return_status OUT NOCOPY VARCHAR2
4518: , x_msg_count OUT NOCOPY NUMBER
4519: , x_msg_data OUT NOCOPY VARCHAR2

Line 4516: , p_Dim_Level_Rec_Old IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

4512: FUNCTION TO ALTER BSC DIMENSION OBJECTS MASTER TABLES
4513: ********************************************************************************/
4514: FUNCTION Alter_Bsc_Master_Tabs
4515: ( p_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
4516: , p_Dim_Level_Rec_Old IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
4517: , x_return_status OUT NOCOPY VARCHAR2
4518: , x_msg_count OUT NOCOPY NUMBER
4519: , x_msg_data OUT NOCOPY VARCHAR2
4520: )

Line 4845: ( p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

4841: /*******************************************************************************
4842: FUNCTION TO ALTER M x N Tables
4843: ********************************************************************************/
4844: FUNCTION Alter_M_By_N_Tables
4845: ( p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
4846: , p_Dim_Level_Rec_Old IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
4847: , x_return_status OUT NOCOPY VARCHAR2
4848: , x_msg_count OUT NOCOPY NUMBER
4849: , x_msg_data OUT NOCOPY VARCHAR2

Line 4846: , p_Dim_Level_Rec_Old IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

4842: FUNCTION TO ALTER M x N Tables
4843: ********************************************************************************/
4844: FUNCTION Alter_M_By_N_Tables
4845: ( p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
4846: , p_Dim_Level_Rec_Old IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
4847: , x_return_status OUT NOCOPY VARCHAR2
4848: , x_msg_count OUT NOCOPY NUMBER
4849: , x_msg_data OUT NOCOPY VARCHAR2
4850: )

Line 5100: ( p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

5096: /*******************************************************************************
5097: FUNCTION TO ALTER One x N Child Tables
5098: ********************************************************************************/
5099: FUNCTION Alter_One_By_N_Tables
5100: ( p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
5101: , p_Dim_Level_Rec_Old IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
5102: , x_return_status OUT NOCOPY VARCHAR2
5103: , x_msg_count OUT NOCOPY NUMBER
5104: , x_msg_data OUT NOCOPY VARCHAR2

Line 5101: , p_Dim_Level_Rec_Old IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

5097: FUNCTION TO ALTER One x N Child Tables
5098: ********************************************************************************/
5099: FUNCTION Alter_One_By_N_Tables
5100: ( p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
5101: , p_Dim_Level_Rec_Old IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
5102: , x_return_status OUT NOCOPY VARCHAR2
5103: , x_msg_count OUT NOCOPY NUMBER
5104: , x_msg_data OUT NOCOPY VARCHAR2
5105: )

Line 5518: l_bsc_dim_obj_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;

5514: ) RETURN VARCHAR2 IS
5515: l_Msg_Data VARCHAR2(32000);
5516: l_msg_count NUMBER;
5517:
5518: l_bsc_dim_obj_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
5519: l_dim_Grp_name BSC_SYS_DIM_GROUPS_TL.short_name%TYPE;
5520: l_MTab_Tbl BSC_BIS_DIM_OBJ_PUB.KPI_Dim_Set_Table_Type;
5521:
5522: l_count NUMBER;

Line 6005: l_bsc_dim_obj_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;

6001: , x_return_status OUT NOCOPY VARCHAR2
6002: , x_msg_count OUT NOCOPY NUMBER
6003: , x_msg_data OUT NOCOPY VARCHAR2
6004: ) IS
6005: l_bsc_dim_obj_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
6006: l_flag BOOLEAN;
6007:
6008: CURSOR c_Pmf_Dim_Obj is
6009: SELECT A.Short_Name

Line 6146: ( p_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

6142: END Remove_BSC_PMF_EDW_Dim_View;
6143: --=======================================================================================
6144:
6145: PROCEDURE Init_Create_Pmf_Recs
6146: ( p_Dim_Level_Rec IN OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
6147: , x_return_status OUT NOCOPY VARCHAR2
6148: , x_msg_count OUT NOCOPY NUMBER
6149: , x_msg_data OUT NOCOPY VARCHAR2
6150: ) IS

Line 6869: l_bsc_dim_obj_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;

6865: , x_obj_names OUT NOCOPY VARCHAR2
6866: ) RETURN BOOLEAN IS
6867:
6868: l_MTab_Tbl BSC_BIS_DIM_OBJ_PUB.KPI_Dim_Set_Table_Type;
6869: l_bsc_dim_obj_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
6870: l_obj_names VARCHAR2(8000);
6871: l_child_dim_obj_list VARCHAR2 (32000);
6872: l_disp_format_flag BOOLEAN := FALSE;
6873: l_child_disp_fm_flag BOOLEAN := FALSE;

Line 7046: ( p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type

7042:
7043: /******************************************************************************/
7044: -- Added for Bug#4758995
7045: FUNCTION Get_Unique_Level_Pk_Col
7046: ( p_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
7047: , x_return_status OUT NOCOPY VARCHAR2
7048: , x_msg_count OUT NOCOPY NUMBER
7049: , x_msg_data OUT NOCOPY VARCHAR2
7050: ) RETURN VARCHAR2 IS