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.QPR_MAINTAIN_AW dependencies on DBMS_LOB

Line 525: DBMS_LOB.CREATETEMPORARY(xml_clob,TRUE);

521:
522:
523: itr:=0;
524:
525: DBMS_LOB.CREATETEMPORARY(xml_clob,TRUE);
526: dbms_lob.open(xml_clob, DBMS_LOB.LOB_READWRITE);
527: l_str:=' 528: l_str:= l_str|| 'Id="Action'||g_run_number||'" ';
529: l_str:= l_str|| 'AWName="'||l_schem||'.'||l_aw_name||

Line 526: dbms_lob.open(xml_clob, DBMS_LOB.LOB_READWRITE);

522:
523: itr:=0;
524:
525: DBMS_LOB.CREATETEMPORARY(xml_clob,TRUE);
526: dbms_lob.open(xml_clob, DBMS_LOB.LOB_READWRITE);
527: l_str:=' 528: l_str:= l_str|| 'Id="Action'||g_run_number||'" ';
529: l_str:= l_str|| 'AWName="'||l_schem||'.'||l_aw_name||
530: '" BuildType="EXECUTE" RunSolve="true" ';

Line 543: dbms_lob.writeappend(xml_clob, length(l_str), l_str);

539: else
540: l_str:= l_str|| 'CleanAttrs="false" CleanDim="false" '||
541: 'trackStatus="false" MaxJobQueues="0">';
542: end if;
543: dbms_lob.writeappend(xml_clob, length(l_str), l_str);
544: log_debug(l_str);
545: if p_include_dim = 'Y' then
546: for c_aw_dim_rec in c_aw_dim loop
547: log_debug(c_aw_dim_rec.dim_code);

Line 550: dbms_lob.writeappend(xml_clob, length(l_str), l_str);

546: for c_aw_dim_rec in c_aw_dim loop
547: log_debug(c_aw_dim_rec.dim_code);
548: l_str:=' ';
550: dbms_lob.writeappend(xml_clob, length(l_str), l_str);
551: log_debug(l_str);
552: end loop;
553: end if;
554: for c_cube_meas_rec in c_cube_meas loop

Line 566: dbms_lob.writeappend(xml_clob, length(l_str), l_str);

562: else
563: xml_str_temp:=xml_str_temp || l_str;
564: end if;
565: else
566: dbms_lob.writeappend(xml_clob, length(l_str), l_str);
567: log_debug(l_str);
568: end if;
569: end loop;
570: dbms_lob.writeappend(xml_clob, 18, ' ');

Line 570: dbms_lob.writeappend(xml_clob, 18, ' ');

566: dbms_lob.writeappend(xml_clob, length(l_str), l_str);
567: log_debug(l_str);
568: end if;
569: end loop;
570: dbms_lob.writeappend(xml_clob, 18, ' ');
571: dbms_lob.close(xml_clob);
572: xml_str := sys.interactionExecute(xml_clob);
573: log_debug(xml_str);
574: for c_xml_load_log_rec in c_xml_load_log loop

Line 571: dbms_lob.close(xml_clob);

567: log_debug(l_str);
568: end if;
569: end loop;
570: dbms_lob.writeappend(xml_clob, 18, ' ');
571: dbms_lob.close(xml_clob);
572: xml_str := sys.interactionExecute(xml_clob);
573: log_debug(xml_str);
574: for c_xml_load_log_rec in c_xml_load_log loop
575: log_debug(c_xml_load_log_rec.xml_message);

Line 580: DBMS_LOB.CREATETEMPORARY(xml_clob1,TRUE);

576: end loop;
577:
578: if xml_str_temp is not null then
579: log_debug('Second Load');
580: DBMS_LOB.CREATETEMPORARY(xml_clob1,TRUE);
581: dbms_lob.open(xml_clob1, DBMS_LOB.LOB_READWRITE);
582: l_str:=' 583: l_str:= l_str|| 'Id="Action1'||g_run_number||'" ';
584: l_str:= l_str|| 'AWName="'||l_schem||'.'||l_aw_name||

Line 581: dbms_lob.open(xml_clob1, DBMS_LOB.LOB_READWRITE);

577:
578: if xml_str_temp is not null then
579: log_debug('Second Load');
580: DBMS_LOB.CREATETEMPORARY(xml_clob1,TRUE);
581: dbms_lob.open(xml_clob1, DBMS_LOB.LOB_READWRITE);
582: l_str:=' 583: l_str:= l_str|| 'Id="Action1'||g_run_number||'" ';
584: l_str:= l_str|| 'AWName="'||l_schem||'.'||l_aw_name||
585: '" BuildType="EXECUTE" RunSolve="true" ';

Line 598: dbms_lob.writeappend(xml_clob1, length(l_str), l_str);

594: else
595: l_str:= l_str|| 'CleanAttrs="false" CleanDim="false" '||
596: 'trackStatus="false" MaxJobQueues="0">';
597: end if;
598: dbms_lob.writeappend(xml_clob1, length(l_str), l_str);
599: dbms_lob.writeappend(xml_clob1, length(xml_str_temp), xml_str_temp);
600: log_debug(l_str);
601: log_debug(xml_str_temp);
602: dbms_lob.writeappend(xml_clob1, 18, ' ');

Line 599: dbms_lob.writeappend(xml_clob1, length(xml_str_temp), xml_str_temp);

595: l_str:= l_str|| 'CleanAttrs="false" CleanDim="false" '||
596: 'trackStatus="false" MaxJobQueues="0">';
597: end if;
598: dbms_lob.writeappend(xml_clob1, length(l_str), l_str);
599: dbms_lob.writeappend(xml_clob1, length(xml_str_temp), xml_str_temp);
600: log_debug(l_str);
601: log_debug(xml_str_temp);
602: dbms_lob.writeappend(xml_clob1, 18, ' ');
603: dbms_lob.close(xml_clob1);

Line 602: dbms_lob.writeappend(xml_clob1, 18, ' ');

598: dbms_lob.writeappend(xml_clob1, length(l_str), l_str);
599: dbms_lob.writeappend(xml_clob1, length(xml_str_temp), xml_str_temp);
600: log_debug(l_str);
601: log_debug(xml_str_temp);
602: dbms_lob.writeappend(xml_clob1, 18, ' ');
603: dbms_lob.close(xml_clob1);
604: xml_str := sys.interactionExecute(xml_clob1);
605: log_debug(xml_str);
606: for c_xml_load_log_rec in c_xml_load_log loop

Line 603: dbms_lob.close(xml_clob1);

599: dbms_lob.writeappend(xml_clob1, length(xml_str_temp), xml_str_temp);
600: log_debug(l_str);
601: log_debug(xml_str_temp);
602: dbms_lob.writeappend(xml_clob1, 18, ' ');
603: dbms_lob.close(xml_clob1);
604: xml_str := sys.interactionExecute(xml_clob1);
605: log_debug(xml_str);
606: for c_xml_load_log_rec in c_xml_load_log loop
607: log_debug(c_xml_load_log_rec.xml_message);

Line 613: DBMS_LOB.CREATETEMPORARY(xml_clob2,TRUE);

609: end if;
610:
611: if xml_str_temp1 is not null then
612: log_debug('Third Load');
613: DBMS_LOB.CREATETEMPORARY(xml_clob2,TRUE);
614: dbms_lob.open(xml_clob2, DBMS_LOB.LOB_READWRITE);
615: l_str:=' 616: l_str:= l_str|| 'Id="Action2'||g_run_number||'" ';
617: l_str:= l_str|| 'AWName="'||l_schem||'.'||l_aw_name||

Line 614: dbms_lob.open(xml_clob2, DBMS_LOB.LOB_READWRITE);

610:
611: if xml_str_temp1 is not null then
612: log_debug('Third Load');
613: DBMS_LOB.CREATETEMPORARY(xml_clob2,TRUE);
614: dbms_lob.open(xml_clob2, DBMS_LOB.LOB_READWRITE);
615: l_str:=' 616: l_str:= l_str|| 'Id="Action2'||g_run_number||'" ';
617: l_str:= l_str|| 'AWName="'||l_schem||'.'||l_aw_name||
618: '" BuildType="EXECUTE" RunSolve="true" ';

Line 631: dbms_lob.writeappend(xml_clob2, length(l_str), l_str);

627: else
628: l_str:= l_str|| 'CleanAttrs="false" CleanDim="false" '||
629: 'trackStatus="false" MaxJobQueues="0">';
630: end if;
631: dbms_lob.writeappend(xml_clob2, length(l_str), l_str);
632: dbms_lob.writeappend(xml_clob2, length(xml_str_temp1), xml_str_temp1);
633: log_debug(l_str);
634: log_debug(xml_str_temp1);
635: dbms_lob.writeappend(xml_clob2, 18, ' ');

Line 632: dbms_lob.writeappend(xml_clob2, length(xml_str_temp1), xml_str_temp1);

628: l_str:= l_str|| 'CleanAttrs="false" CleanDim="false" '||
629: 'trackStatus="false" MaxJobQueues="0">';
630: end if;
631: dbms_lob.writeappend(xml_clob2, length(l_str), l_str);
632: dbms_lob.writeappend(xml_clob2, length(xml_str_temp1), xml_str_temp1);
633: log_debug(l_str);
634: log_debug(xml_str_temp1);
635: dbms_lob.writeappend(xml_clob2, 18, ' ');
636: dbms_lob.close(xml_clob2);

Line 635: dbms_lob.writeappend(xml_clob2, 18, ' ');

631: dbms_lob.writeappend(xml_clob2, length(l_str), l_str);
632: dbms_lob.writeappend(xml_clob2, length(xml_str_temp1), xml_str_temp1);
633: log_debug(l_str);
634: log_debug(xml_str_temp1);
635: dbms_lob.writeappend(xml_clob2, 18, ' ');
636: dbms_lob.close(xml_clob2);
637: xml_str := sys.interactionExecute(xml_clob2);
638: log_debug(xml_str);
639: for c_xml_load_log_rec in c_xml_load_log loop

Line 636: dbms_lob.close(xml_clob2);

632: dbms_lob.writeappend(xml_clob2, length(xml_str_temp1), xml_str_temp1);
633: log_debug(l_str);
634: log_debug(xml_str_temp1);
635: dbms_lob.writeappend(xml_clob2, 18, ' ');
636: dbms_lob.close(xml_clob2);
637: xml_str := sys.interactionExecute(xml_clob2);
638: log_debug(xml_str);
639: for c_xml_load_log_rec in c_xml_load_log loop
640: log_debug(c_xml_load_log_rec.xml_message);