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_AW_CALENDAR dependencies on DBMS_SQL

Line 13: l_affected_kpi dbms_sql.varchar2_table;

9: if the calendar is extended or the start date changes, this procedure is not called. we simply refresh the
10: calendar load program
11: */
12: procedure create_calendar(p_calendar number,p_options varchar2) is
13: l_affected_kpi dbms_sql.varchar2_table;
14: Begin
15: create_calendar(p_calendar,p_options,l_affected_kpi);
16: Exception when others then
17: log_n('Exception in create_calendar '||sqlerrm);

Line 24: p_affected_kpi out nocopy dbms_sql.varchar2_table

20:
21: procedure create_calendar(
22: p_calendar number,
23: p_options varchar2,
24: p_affected_kpi out nocopy dbms_sql.varchar2_table
25: ) is
26: Begin
27: if p_options is not null then
28: bsc_aw_utility.parse_parameter_values(p_options,',',bsc_aw_utility.g_options);

Line 47: procedure create_calendar(p_calendar number,p_affected_kpi out nocopy dbms_sql.varchar2_table) is

43: log_n('Exception in create_calendar '||sqlerrm);
44: raise;
45: End;
46:
47: procedure create_calendar(p_calendar number,p_affected_kpi out nocopy dbms_sql.varchar2_table) is
48: l_calendar calendar_r;
49: l_create_objects boolean;
50: l_create_program boolean;
51: l_recreate varchar2(40);

Line 881: p_affected_kpi out nocopy dbms_sql.varchar2_table) is

877:
878: procedure check_calendar_create(
879: p_calendar calendar_r,
880: p_recreate out nocopy varchar2,
881: p_affected_kpi out nocopy dbms_sql.varchar2_table) is
882: --
883: Begin
884: if bsc_aw_md_api.is_dim_present(p_calendar.dim_name) then
885: --check to see if the calendar matches the calendar in the olap metadata

Line 926: l_periodicities dbms_sql.varchar2_table;

922: */
923: procedure correct_calendar(p_calendar calendar_r,p_recreate out nocopy varchar2) is
924: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
925: l_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
926: l_periodicities dbms_sql.varchar2_table;
927: l_olap_periodicities dbms_sql.varchar2_table;
928: l_level_name_dim varchar(200);
929: l_olap_periodicity_dim dbms_sql.varchar2_table;
930: l_pc parent_child_tb;

Line 927: l_olap_periodicities dbms_sql.varchar2_table;

923: procedure correct_calendar(p_calendar calendar_r,p_recreate out nocopy varchar2) is
924: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
925: l_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
926: l_periodicities dbms_sql.varchar2_table;
927: l_olap_periodicities dbms_sql.varchar2_table;
928: l_level_name_dim varchar(200);
929: l_olap_periodicity_dim dbms_sql.varchar2_table;
930: l_pc parent_child_tb;
931: --

Line 929: l_olap_periodicity_dim dbms_sql.varchar2_table;

925: l_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
926: l_periodicities dbms_sql.varchar2_table;
927: l_olap_periodicities dbms_sql.varchar2_table;
928: l_level_name_dim varchar(200);
929: l_olap_periodicity_dim dbms_sql.varchar2_table;
930: l_pc parent_child_tb;
931: --
932: Begin
933: bsc_aw_md_api.get_bsc_olap_object(null,null,p_calendar.dim_name,'dimension',l_oo);

Line 1016: procedure drop_calendar_objects(p_calendar_name varchar2,p_object_type varchar2,p_affected_kpi out nocopy dbms_sql.varchar2_table) is

1012: raise;
1013: End;
1014:
1015: --p_object_type is null or all or dml program
1016: procedure drop_calendar_objects(p_calendar_name varchar2,p_object_type varchar2,p_affected_kpi out nocopy dbms_sql.varchar2_table) is
1017: --
1018: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
1019: l_flag dbms_sql.varchar2_table;
1020: Begin

Line 1019: l_flag dbms_sql.varchar2_table;

1015: --p_object_type is null or all or dml program
1016: procedure drop_calendar_objects(p_calendar_name varchar2,p_object_type varchar2,p_affected_kpi out nocopy dbms_sql.varchar2_table) is
1017: --
1018: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
1019: l_flag dbms_sql.varchar2_table;
1020: Begin
1021: --first drop all dependent kpi ... if needed
1022: if p_object_type is null or p_object_type='all' then
1023: bsc_aw_md_api.get_kpi_for_dim(p_calendar_name,p_affected_kpi);

Line 1092: p_periodicity_dim in out nocopy dbms_sql.varchar2_table,

1088: for each child, see if any immediate parent is present. if no, either top level or missing levels
1089: */
1090: procedure get_missing_periodicity(
1091: p_calendar_dim varchar2,
1092: p_periodicity_dim in out nocopy dbms_sql.varchar2_table,
1093: p_lowest_level out nocopy dbms_sql.varchar2_table
1094: ) is
1095: --
1096: l_missing_levels dbms_sql.varchar2_table;

Line 1093: p_lowest_level out nocopy dbms_sql.varchar2_table

1089: */
1090: procedure get_missing_periodicity(
1091: p_calendar_dim varchar2,
1092: p_periodicity_dim in out nocopy dbms_sql.varchar2_table,
1093: p_lowest_level out nocopy dbms_sql.varchar2_table
1094: ) is
1095: --
1096: l_missing_levels dbms_sql.varchar2_table;
1097: l_found boolean;

Line 1096: l_missing_levels dbms_sql.varchar2_table;

1092: p_periodicity_dim in out nocopy dbms_sql.varchar2_table,
1093: p_lowest_level out nocopy dbms_sql.varchar2_table
1094: ) is
1095: --
1096: l_missing_levels dbms_sql.varchar2_table;
1097: l_found boolean;
1098: l_parent_child_calendar parent_child_tb;
1099: Begin
1100: --get calendar properties

Line 1148: p_periodicity_dim dbms_sql.varchar2_table,

1144: End;
1145:
1146: function is_child_present(
1147: p_parent varchar2,
1148: p_periodicity_dim dbms_sql.varchar2_table,
1149: p_parent_child parent_child_tb) return boolean is
1150: Begin
1151: for i in 1..p_parent_child.count loop
1152: if p_parent_child(i).parent_dim_name=p_parent and bsc_aw_utility.in_array(p_periodicity_dim,p_parent_child(i).child_dim_name) then

Line 1164: p_periodicity_dim dbms_sql.varchar2_table,

1160: End;
1161:
1162: function is_parent_present(
1163: p_child varchar2,
1164: p_periodicity_dim dbms_sql.varchar2_table,
1165: p_parent_child parent_child_tb) return boolean is
1166: Begin
1167: for i in 1..p_parent_child.count loop
1168: if p_parent_child(i).child_dim_name=p_child and bsc_aw_utility.in_array(p_periodicity_dim,p_parent_child(i).parent_dim_name) then

Line 1181: p_periodicity_dim dbms_sql.varchar2_table,

1177:
1178: --recursively called
1179: procedure get_missing_level_down(
1180: p_parent varchar2,
1181: p_periodicity_dim dbms_sql.varchar2_table,
1182: p_parent_child parent_child_tb,
1183: p_missing_levels_in dbms_sql.varchar2_table,
1184: p_missing_levels_out out nocopy dbms_sql.varchar2_table,
1185: p_found in out nocopy boolean --indicates if child is found and its time to stop

Line 1183: p_missing_levels_in dbms_sql.varchar2_table,

1179: procedure get_missing_level_down(
1180: p_parent varchar2,
1181: p_periodicity_dim dbms_sql.varchar2_table,
1182: p_parent_child parent_child_tb,
1183: p_missing_levels_in dbms_sql.varchar2_table,
1184: p_missing_levels_out out nocopy dbms_sql.varchar2_table,
1185: p_found in out nocopy boolean --indicates if child is found and its time to stop
1186: ) is
1187: --

Line 1184: p_missing_levels_out out nocopy dbms_sql.varchar2_table,

1180: p_parent varchar2,
1181: p_periodicity_dim dbms_sql.varchar2_table,
1182: p_parent_child parent_child_tb,
1183: p_missing_levels_in dbms_sql.varchar2_table,
1184: p_missing_levels_out out nocopy dbms_sql.varchar2_table,
1185: p_found in out nocopy boolean --indicates if child is found and its time to stop
1186: ) is
1187: --
1188: l_missing_levels dbms_sql.varchar2_table;

Line 1188: l_missing_levels dbms_sql.varchar2_table;

1184: p_missing_levels_out out nocopy dbms_sql.varchar2_table,
1185: p_found in out nocopy boolean --indicates if child is found and its time to stop
1186: ) is
1187: --
1188: l_missing_levels dbms_sql.varchar2_table;
1189: Begin
1190: if p_found=false then
1191: if is_child_present(p_parent,p_periodicity_dim,p_parent_child) then
1192: p_missing_levels_out:=p_missing_levels_in;

Line 1216: p_periodicity_dim dbms_sql.varchar2_table,

1212:
1213: --recursively called
1214: procedure get_missing_level_up(
1215: p_child varchar2,
1216: p_periodicity_dim dbms_sql.varchar2_table,
1217: p_parent_child parent_child_tb,
1218: p_missing_levels_in dbms_sql.varchar2_table,
1219: p_missing_levels_out out nocopy dbms_sql.varchar2_table,
1220: p_found in out nocopy boolean --indicates if child is found and its time to stop

Line 1218: p_missing_levels_in dbms_sql.varchar2_table,

1214: procedure get_missing_level_up(
1215: p_child varchar2,
1216: p_periodicity_dim dbms_sql.varchar2_table,
1217: p_parent_child parent_child_tb,
1218: p_missing_levels_in dbms_sql.varchar2_table,
1219: p_missing_levels_out out nocopy dbms_sql.varchar2_table,
1220: p_found in out nocopy boolean --indicates if child is found and its time to stop
1221: ) is
1222: --

Line 1219: p_missing_levels_out out nocopy dbms_sql.varchar2_table,

1215: p_child varchar2,
1216: p_periodicity_dim dbms_sql.varchar2_table,
1217: p_parent_child parent_child_tb,
1218: p_missing_levels_in dbms_sql.varchar2_table,
1219: p_missing_levels_out out nocopy dbms_sql.varchar2_table,
1220: p_found in out nocopy boolean --indicates if child is found and its time to stop
1221: ) is
1222: --
1223: l_missing_levels dbms_sql.varchar2_table;

Line 1223: l_missing_levels dbms_sql.varchar2_table;

1219: p_missing_levels_out out nocopy dbms_sql.varchar2_table,
1220: p_found in out nocopy boolean --indicates if child is found and its time to stop
1221: ) is
1222: --
1223: l_missing_levels dbms_sql.varchar2_table;
1224: Begin
1225: if p_found=false then
1226: if is_parent_present(p_child,p_periodicity_dim,p_parent_child) then
1227: p_missing_levels_out:=p_missing_levels_in;

Line 1274: l_lock_objects dbms_sql.varchar2_table;

1270: End;
1271:
1272: procedure lock_calendar_objects(p_calendar number) is
1273: --
1274: l_lock_objects dbms_sql.varchar2_table;
1275: Begin
1276: get_calendar_objects_to_lock(p_calendar,l_lock_objects);
1277: bsc_aw_management.get_workspace_lock(l_lock_objects,null);
1278: Exception when others then

Line 1293: procedure get_calendar_objects_to_lock(p_calendar number,p_lock_objects out nocopy dbms_sql.varchar2_table) is

1289: we have to acquire locks and update in a certain order . else we get
1290: ORA-37023: (XSMLTUPD01) Object workspace object cannot be updated without dimension workspace object.
1291: we cannot update a relation before a dim. so when we get locks, we first get dim, then relations, then variables
1292: */
1293: procedure get_calendar_objects_to_lock(p_calendar number,p_lock_objects out nocopy dbms_sql.varchar2_table) is
1294: l_dim varchar2(300);
1295: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
1296: l_objects dbms_sql.varchar2_table;
1297: Begin

Line 1296: l_objects dbms_sql.varchar2_table;

1292: */
1293: procedure get_calendar_objects_to_lock(p_calendar number,p_lock_objects out nocopy dbms_sql.varchar2_table) is
1294: l_dim varchar2(300);
1295: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
1296: l_objects dbms_sql.varchar2_table;
1297: Begin
1298: l_dim:=get_calendar_name(p_calendar);
1299: bsc_aw_md_api.get_bsc_olap_object(null,null,l_dim,'dimension',l_bsc_olap_object);
1300: for i in 1..l_bsc_olap_object.count loop

Line 1374: l_calendar dbms_sql.number_table;

1370: End;
1371:
1372: procedure reimplement_all_calendars is
1373: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
1374: l_calendar dbms_sql.number_table;
1375: l_year number;
1376: l_cal_id number;
1377: Begin
1378: bsc_aw_md_api.get_bsc_olap_object(null,'dimension',null,'dimension',l_oo);

Line 1401: l_affected_kpi dbms_sql.varchar2_table;

1397: raise;
1398: End;
1399:
1400: procedure reimplement_calendar(p_calendar_id number) is
1401: l_affected_kpi dbms_sql.varchar2_table;
1402: l_dim varchar2(100);
1403: Begin
1404: if g_debug then
1405: log('Reimplement calendar '||p_calendar_id||bsc_aw_utility.get_time);