APPS.BSC_AW_MD_WRAPPER dependencies on DBMS_SQL

Line 489: l_comp_added dbms_sql.varchar2_table; --so we insert into oo distinct composite names

485: End;
486:
487: procedure create_kpi(p_kpi varchar2,p_dim_set bsc_aw_adapter_kpi.dim_set_r) is
488: l_property varchar2(4000);
489: l_comp_added dbms_sql.varchar2_table; --so we insert into oo distinct composite names
490: l_dimset_name_property varchar2(400);
491: l_bsc_olap_object_relation bsc_olap_object_relation_tb;
492: Begin
493: default_context_if_null;

Line 1085: p_match_columns dbms_sql.varchar2_table,

1081: p_object_type varchar2,
1082: p_relation_type varchar2,
1083: p_parent_object varchar2,
1084: p_parent_object_type varchar2,
1085: p_match_columns dbms_sql.varchar2_table,
1086: p_match_values dbms_sql.varchar2_table,
1087: p_set_columns dbms_sql.varchar2_table,
1088: p_set_values dbms_sql.varchar2_table
1089: ) is

Line 1086: p_match_values dbms_sql.varchar2_table,

1082: p_relation_type varchar2,
1083: p_parent_object varchar2,
1084: p_parent_object_type varchar2,
1085: p_match_columns dbms_sql.varchar2_table,
1086: p_match_values dbms_sql.varchar2_table,
1087: p_set_columns dbms_sql.varchar2_table,
1088: p_set_values dbms_sql.varchar2_table
1089: ) is
1090: --

Line 1087: p_set_columns dbms_sql.varchar2_table,

1083: p_parent_object varchar2,
1084: p_parent_object_type varchar2,
1085: p_match_columns dbms_sql.varchar2_table,
1086: p_match_values dbms_sql.varchar2_table,
1087: p_set_columns dbms_sql.varchar2_table,
1088: p_set_values dbms_sql.varchar2_table
1089: ) is
1090: --
1091: l_stmt varchar2(8000);

Line 1088: p_set_values dbms_sql.varchar2_table

1084: p_parent_object_type varchar2,
1085: p_match_columns dbms_sql.varchar2_table,
1086: p_match_values dbms_sql.varchar2_table,
1087: p_set_columns dbms_sql.varchar2_table,
1088: p_set_values dbms_sql.varchar2_table
1089: ) is
1090: --
1091: l_stmt varchar2(8000);
1092: Begin

Line 1135: p_match_columns dbms_sql.varchar2_table,

1131: p_object varchar2,
1132: p_object_type varchar2,
1133: p_parent_object varchar2,
1134: p_parent_object_type varchar2,
1135: p_match_columns dbms_sql.varchar2_table,
1136: p_match_values dbms_sql.varchar2_table,
1137: p_set_columns dbms_sql.varchar2_table,
1138: p_set_values dbms_sql.varchar2_table
1139: ) is

Line 1136: p_match_values dbms_sql.varchar2_table,

1132: p_object_type varchar2,
1133: p_parent_object varchar2,
1134: p_parent_object_type varchar2,
1135: p_match_columns dbms_sql.varchar2_table,
1136: p_match_values dbms_sql.varchar2_table,
1137: p_set_columns dbms_sql.varchar2_table,
1138: p_set_values dbms_sql.varchar2_table
1139: ) is
1140: --

Line 1137: p_set_columns dbms_sql.varchar2_table,

1133: p_parent_object varchar2,
1134: p_parent_object_type varchar2,
1135: p_match_columns dbms_sql.varchar2_table,
1136: p_match_values dbms_sql.varchar2_table,
1137: p_set_columns dbms_sql.varchar2_table,
1138: p_set_values dbms_sql.varchar2_table
1139: ) is
1140: --
1141: l_stmt varchar2(8000);

Line 1138: p_set_values dbms_sql.varchar2_table

1134: p_parent_object_type varchar2,
1135: p_match_columns dbms_sql.varchar2_table,
1136: p_match_values dbms_sql.varchar2_table,
1137: p_set_columns dbms_sql.varchar2_table,
1138: p_set_values dbms_sql.varchar2_table
1139: ) is
1140: --
1141: l_stmt varchar2(8000);
1142: Begin