DBA Data[Home] [Help]

APPS.BSC_UPGRADES dependencies on BIS_UTILITIES_PUB

Line 102: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

98:
99: PROCEDURE sync_dim_object_mappings
100: ( p_dim_short_name IN VARCHAR2
101: , x_return_status OUT NOCOPY VARCHAR2
102: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
103: );
104:
105: -- ankgoel: bug#3874911
106: -- Validate and re-generate dataset names untill unique

Line 182: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

178: l_indicator_id NUMBER;
179: l_count NUMBER;
180: l_bis_measure_rec bis_measure_pub.measure_rec_type;
181: l_return_status VARCHAR2(1);
182: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
183: l_err VARCHAR2(2000);
184: BEGIN
185: l_num_ids := 0;
186:

Line 430: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

426:
427: PROCEDURE sync_measures_bsc_to_pmf_51
428: IS
429: l_return_status varchar2(1);
430: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
431: l_measure_rec BIS_MEASURE_PUB.Measure_rec_type;
432:
433: TYPE t_array_of_varchar2 IS TABLE OF VARCHAR2(2000)
434: INDEX BY BINARY_INTEGER;

Line 544: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

540:
541: PROCEDURE synch_measures_cds_to_pmf
542: IS
543: l_return_status varchar2(1);
544: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
545: l_measure_rec BIS_MEASURE_PUB.Measure_rec_type;
546: l_count NUMBER;
547: l_Kpi_Id NUMBER;
548:

Line 621: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

617:
618: PROCEDURE sync_measures_bsc_to_pmf
619: IS
620: l_return_status varchar2(1);
621: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
622: l_measure_rec BIS_MEASURE_PUB.Measure_rec_type;
623: l_count NUMBER;
624: l_Kpi_Id NUMBER;
625:

Line 846: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

842:
843: l_return_status varchar2(1);
844: l_msg_count number;
845: l_msg_data varchar2(2000);
846: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
847:
848: BEGIN
849:
850: -- meastmon bug#3379110 --------------------------------------------------------------------

Line 925: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type)

921: Procedure lang_synch_BSC_To_PMF_measure(
922: p_dataset_id IN NUMBER := NULL
923: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
924: , x_return_status OUT NOCOPY VARCHAR2
925: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type)
926: is
927:
928: cursor installed_languages_cursor is
929: select L.language_code

Line 1101: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type)

1097: Procedure lang_synch_existing_measures(
1098: x_msg_count OUT NOCOPY NUMBER
1099: , x_msg_data OUT NOCOPY VARCHAR2
1100: , x_return_status OUT NOCOPY VARCHAR2
1101: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type)
1102: is
1103:
1104: cursor synch_lang_cursor is
1105: select i.indicator_id, itl.language, itl.source_lang, i.short_name, d.source, d.dataset_id,

Line 1303: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1299:
1300: l_bsc_dim_obj_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
1301: l_bis_dim_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1302:
1303: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1304:
1305: l_flag BOOLEAN;
1306: l_count NUMBER;
1307: l_sql VARCHAR2(32000);

Line 1569: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1565:
1566:
1567: l_bis_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
1568: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
1569: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1570:
1571: l_flag BOOLEAN;
1572: l_count NUMBER;
1573: BEGIN

Line 1825: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1821: PROCEDURE Lang_Synch_BSC_To_PMF_DimObj
1822: (
1823: p_level_short_name IN VARCHAR2
1824: , x_return_status OUT NOCOPY VARCHAR2
1825: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1826: )
1827: IS
1828:
1829: l_Dim_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

Line 1831: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1827: IS
1828:
1829: l_Dim_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1830: l_level_id NUMBER;
1831: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1832:
1833: cursor installed_languages_cursor is
1834: select L.language_code
1835: from FND_LANGUAGES L

Line 2000: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1996: PROCEDURE Lang_Synch_BSC_To_PMF_Dim
1997: (
1998: p_dim_short_name IN VARCHAR2
1999: , x_return_status OUT NOCOPY VARCHAR2
2000: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2001: )
2002: IS
2003:
2004: l_Dim_Grp_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

Line 2005: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

2001: )
2002: IS
2003:
2004: l_Dim_Grp_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
2005: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2006:
2007: cursor installed_languages_cursor is
2008: select L.language_code
2009: from FND_LANGUAGES L

Line 2291: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

2287: FUNCTION Upgrade_Advanced_Profile(
2288: x_error_msg OUT NOCOPY VARCHAR2
2289: ) RETURN BOOLEAN IS
2290:
2291: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2292: l_return_status boolean;
2293: l_summerization_value VARCHAR2(240);
2294: l_ui_features_value VARCHAR2(240);
2295:

Line 2734: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

2730:
2731: PROCEDURE sync_dim_object_mappings
2732: ( p_dim_short_name IN VARCHAR2
2733: , x_return_status OUT NOCOPY VARCHAR2
2734: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2735: )
2736: IS
2737: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2738:

Line 2737: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

2733: , x_return_status OUT NOCOPY VARCHAR2
2734: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2735: )
2736: IS
2737: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2738:
2739: CURSOR c_bsc_rel is
2740: SELECT bsc_lvl.short_name, bis_dim.dimension_id
2741: FROM bsc_sys_dim_groups_vl bsc_dim,