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.EDW_NAEDW_PUSH dependencies on EDW_OWB_COLLECTION_UTIL

Line 365: l_dim_name EDW_OWB_COLLECTION_UTIL.varcharTableType;

361: l_start number;
362: l_end number;
363: l_str varchar2(300);
364: l_len number;
365: l_dim_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
366: l_dim_id EDW_OWB_COLLECTION_UTIL.numberTableType;
367: l_dim_number number:=1;
368: Begin
369: l_start:=1;

Line 366: l_dim_id EDW_OWB_COLLECTION_UTIL.numberTableType;

362: l_end number;
363: l_str varchar2(300);
364: l_len number;
365: l_dim_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
366: l_dim_id EDW_OWB_COLLECTION_UTIL.numberTableType;
367: l_dim_number number:=1;
368: Begin
369: l_start:=1;
370: l_end:=1;

Line 414: l_parent EDW_OWB_COLLECTION_UTIL.varcharTableType;

410: End;--PROCEDURE parse_dim_names(p_dim_string varchar2) IS
411:
412: PROCEDURE Parse_Metadata(p_dim_index number) IS
413:
414: l_parent EDW_OWB_COLLECTION_UTIL.varcharTableType;
415: l_child EDW_OWB_COLLECTION_UTIL.varcharTableType;
416: l_parent_level varchar2(400);
417: l_number number:=1;
418: l_found boolean;

Line 415: l_child EDW_OWB_COLLECTION_UTIL.varcharTableType;

411:
412: PROCEDURE Parse_Metadata(p_dim_index number) IS
413:
414: l_parent EDW_OWB_COLLECTION_UTIL.varcharTableType;
415: l_child EDW_OWB_COLLECTION_UTIL.varcharTableType;
416: l_parent_level varchar2(400);
417: l_number number:=1;
418: l_found boolean;
419: Begin

Line 978: l_relation_key EDW_OWB_COLLECTION_UTIL.varcharTableType;

974: g_status:=false;
975: End;
976:
977: PROCEDURE Get_all_cols(p_index number) IS
978: l_relation_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
979: l_item_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
980: l_data_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
981: l_type_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
982: l_number_key number:=1;

Line 979: l_item_key EDW_OWB_COLLECTION_UTIL.varcharTableType;

975: End;
976:
977: PROCEDURE Get_all_cols(p_index number) IS
978: l_relation_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
979: l_item_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
980: l_data_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
981: l_type_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
982: l_number_key number:=1;
983: l_relation EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 980: l_data_key EDW_OWB_COLLECTION_UTIL.varcharTableType;

976:
977: PROCEDURE Get_all_cols(p_index number) IS
978: l_relation_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
979: l_item_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
980: l_data_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
981: l_type_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
982: l_number_key number:=1;
983: l_relation EDW_OWB_COLLECTION_UTIL.varcharTableType;
984: l_item EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 981: l_type_key EDW_OWB_COLLECTION_UTIL.varcharTableType;

977: PROCEDURE Get_all_cols(p_index number) IS
978: l_relation_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
979: l_item_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
980: l_data_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
981: l_type_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
982: l_number_key number:=1;
983: l_relation EDW_OWB_COLLECTION_UTIL.varcharTableType;
984: l_item EDW_OWB_COLLECTION_UTIL.varcharTableType;
985: l_item_length EDW_OWB_COLLECTION_UTIL.numberTableType;

Line 983: l_relation EDW_OWB_COLLECTION_UTIL.varcharTableType;

979: l_item_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
980: l_data_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
981: l_type_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
982: l_number_key number:=1;
983: l_relation EDW_OWB_COLLECTION_UTIL.varcharTableType;
984: l_item EDW_OWB_COLLECTION_UTIL.varcharTableType;
985: l_item_length EDW_OWB_COLLECTION_UTIL.numberTableType;
986: l_data EDW_OWB_COLLECTION_UTIL.varcharTableType;
987: l_type EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 984: l_item EDW_OWB_COLLECTION_UTIL.varcharTableType;

980: l_data_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
981: l_type_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
982: l_number_key number:=1;
983: l_relation EDW_OWB_COLLECTION_UTIL.varcharTableType;
984: l_item EDW_OWB_COLLECTION_UTIL.varcharTableType;
985: l_item_length EDW_OWB_COLLECTION_UTIL.numberTableType;
986: l_data EDW_OWB_COLLECTION_UTIL.varcharTableType;
987: l_type EDW_OWB_COLLECTION_UTIL.varcharTableType;
988: l_parent EDW_OWB_COLLECTION_UTIL.varcharTableType;

Line 985: l_item_length EDW_OWB_COLLECTION_UTIL.numberTableType;

981: l_type_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
982: l_number_key number:=1;
983: l_relation EDW_OWB_COLLECTION_UTIL.varcharTableType;
984: l_item EDW_OWB_COLLECTION_UTIL.varcharTableType;
985: l_item_length EDW_OWB_COLLECTION_UTIL.numberTableType;
986: l_data EDW_OWB_COLLECTION_UTIL.varcharTableType;
987: l_type EDW_OWB_COLLECTION_UTIL.varcharTableType;
988: l_parent EDW_OWB_COLLECTION_UTIL.varcharTableType;
989: l_number number:=1;

Line 986: l_data EDW_OWB_COLLECTION_UTIL.varcharTableType;

982: l_number_key number:=1;
983: l_relation EDW_OWB_COLLECTION_UTIL.varcharTableType;
984: l_item EDW_OWB_COLLECTION_UTIL.varcharTableType;
985: l_item_length EDW_OWB_COLLECTION_UTIL.numberTableType;
986: l_data EDW_OWB_COLLECTION_UTIL.varcharTableType;
987: l_type EDW_OWB_COLLECTION_UTIL.varcharTableType;
988: l_parent EDW_OWB_COLLECTION_UTIL.varcharTableType;
989: l_number number:=1;
990: l_found boolean;

Line 987: l_type EDW_OWB_COLLECTION_UTIL.varcharTableType;

983: l_relation EDW_OWB_COLLECTION_UTIL.varcharTableType;
984: l_item EDW_OWB_COLLECTION_UTIL.varcharTableType;
985: l_item_length EDW_OWB_COLLECTION_UTIL.numberTableType;
986: l_data EDW_OWB_COLLECTION_UTIL.varcharTableType;
987: l_type EDW_OWB_COLLECTION_UTIL.varcharTableType;
988: l_parent EDW_OWB_COLLECTION_UTIL.varcharTableType;
989: l_number number:=1;
990: l_found boolean;
991: l_owner varchar2(400);

Line 988: l_parent EDW_OWB_COLLECTION_UTIL.varcharTableType;

984: l_item EDW_OWB_COLLECTION_UTIL.varcharTableType;
985: l_item_length EDW_OWB_COLLECTION_UTIL.numberTableType;
986: l_data EDW_OWB_COLLECTION_UTIL.varcharTableType;
987: l_type EDW_OWB_COLLECTION_UTIL.varcharTableType;
988: l_parent EDW_OWB_COLLECTION_UTIL.varcharTableType;
989: l_number number:=1;
990: l_found boolean;
991: l_owner varchar2(400);
992: Begin

Line 1020: l_owner:=EDW_OWB_COLLECTION_UTIL.get_table_owner(g_dim_name(p_index));

1016: return;
1017: end;
1018: Begin
1019: --get the table owner
1020: l_owner:=EDW_OWB_COLLECTION_UTIL.get_table_owner(g_dim_name(p_index));
1021: if g_debug then
1022: write_to_log_file_n('The owner for '||g_dim_name(p_index)||' is '||l_owner);
1023: end if;
1024: if l_owner is null then

Line 1025: g_status_message:=EDW_OWB_COLLECTION_UTIL.g_status_message;

1021: if g_debug then
1022: write_to_log_file_n('The owner for '||g_dim_name(p_index)||' is '||l_owner);
1023: end if;
1024: if l_owner is null then
1025: g_status_message:=EDW_OWB_COLLECTION_UTIL.g_status_message;
1026: g_status:=false;
1027: return;
1028: end if;
1029: open c3(g_dim_id(p_index),l_owner);

Line 1137: --EDW_OWB_COLLECTION_UTIL.print_stmt(g_insert_stmt);

1133: end loop;
1134: end if;
1135: --make the stmt
1136: Make_insert_stmt(i); --pass the level index
1137: --EDW_OWB_COLLECTION_UTIL.print_stmt(g_insert_stmt);
1138: if g_status = false then
1139: return;
1140: end if;
1141: --we dont need to make update anymore. no updates at all..if the row is there, just skip the level

Line 1193: EDW_OWB_COLLECTION_UTIL.init_all(g_conc_program_name,null,'bis.edw.loader');

1189:
1190: PROCEDURE Init_All IS
1191: Begin
1192: g_conc_program_name:='EDW_NAEDW_PUSH';
1193: EDW_OWB_COLLECTION_UTIL.init_all(g_conc_program_name,null,'bis.edw.loader');
1194: write_to_log_file_n('Finished setting up the log file');
1195: if g_debug is null then
1196: if fnd_profile.value('EDW_DEBUG')='Y' then
1197: g_debug:=true;--look at the profile value for this

Line 1251: EDW_OWB_COLLECTION_UTIL.commit_conc_program_log;--this issues a commit

1247:
1248: procedure finish_all(p_flag boolean) is
1249: begin
1250: if p_flag=true then
1251: EDW_OWB_COLLECTION_UTIL.commit_conc_program_log;--this issues a commit
1252: else
1253: rollback;
1254: EDW_OWB_COLLECTION_UTIL.commit_conc_program_log;
1255: end if;

Line 1254: EDW_OWB_COLLECTION_UTIL.commit_conc_program_log;

1250: if p_flag=true then
1251: EDW_OWB_COLLECTION_UTIL.commit_conc_program_log;--this issues a commit
1252: else
1253: rollback;
1254: EDW_OWB_COLLECTION_UTIL.commit_conc_program_log;
1255: end if;
1256: End;--procedure finish_all(p_flag boolean) is
1257:
1258:

Line 1269: EDW_OWB_COLLECTION_UTIL.write_to_log_file(p_message);

1265: End;
1266:
1267: procedure write_to_log_file(p_message varchar2) is
1268: begin
1269: EDW_OWB_COLLECTION_UTIL.write_to_log_file(p_message);
1270: Exception when others then
1271: null;
1272: End;
1273:

Line 1310: if EDW_OWB_COLLECTION_UTIL.does_table_have_data(p_dim,g_dim_pk||'=0')=2 then

1306: End;
1307:
1308: function naedw_in_star(p_dim varchar2) return boolean is
1309: Begin
1310: if EDW_OWB_COLLECTION_UTIL.does_table_have_data(p_dim,g_dim_pk||'=0')=2 then
1311: return true;
1312: else
1313: return false;
1314: end if;

Line 1324: if EDW_OWB_COLLECTION_UTIL.does_table_have_data(p_dim,g_dim_pk||'=-1')=2 then

1320: End;
1321:
1322: function err_in_star(p_dim varchar2) return boolean is
1323: Begin
1324: if EDW_OWB_COLLECTION_UTIL.does_table_have_data(p_dim,g_dim_pk||'=-1')=2 then
1325: return true;
1326: else
1327: return false;
1328: end if;