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

Line 392: dbms_lob.open(xbfile);

388: l_p_filename := LENGTH(p_filename);
389: l_alias := SUBSTR(p_filename,1,l_p_filename-4);
390: l_url_ret := ' ';
391: xbfile := bfilename('XMLDIR',p_filename);
392: dbms_lob.open(xbfile);
393: dbms_lob.createtemporary(iclob,TRUE,dbms_lob.session);
394: dbms_lob.loadfromfile(iclob,xbfile,dbms_lob.getlength(xbfile));
395: dbms_lob.close(xbfile);
396: --

Line 393: dbms_lob.createtemporary(iclob,TRUE,dbms_lob.session);

389: l_alias := SUBSTR(p_filename,1,l_p_filename-4);
390: l_url_ret := ' ';
391: xbfile := bfilename('XMLDIR',p_filename);
392: dbms_lob.open(xbfile);
393: dbms_lob.createtemporary(iclob,TRUE,dbms_lob.session);
394: dbms_lob.loadfromfile(iclob,xbfile,dbms_lob.getlength(xbfile));
395: dbms_lob.close(xbfile);
396: --
397: l_valid_str := '';

Line 394: dbms_lob.loadfromfile(iclob,xbfile,dbms_lob.getlength(xbfile));

390: l_url_ret := ' ';
391: xbfile := bfilename('XMLDIR',p_filename);
392: dbms_lob.open(xbfile);
393: dbms_lob.createtemporary(iclob,TRUE,dbms_lob.session);
394: dbms_lob.loadfromfile(iclob,xbfile,dbms_lob.getlength(xbfile));
395: dbms_lob.close(xbfile);
396: --
397: l_valid_str := '';
398: import_srch_pos := 1;

Line 395: dbms_lob.close(xbfile);

391: xbfile := bfilename('XMLDIR',p_filename);
392: dbms_lob.open(xbfile);
393: dbms_lob.createtemporary(iclob,TRUE,dbms_lob.session);
394: dbms_lob.loadfromfile(iclob,xbfile,dbms_lob.getlength(xbfile));
395: dbms_lob.close(xbfile);
396: --
397: l_valid_str := '';
398: import_srch_pos := 1;
399: l_import_len := LENGTH(p_srch_str1);

Line 404: l_import_pos := dbms_lob.INSTR(iclob,p_srch_str1,import_srch_pos,1);

400: l_namesp_len := LENGTH(p_srch_str2);
401: l_schema_len := LENGTH(p_srch_str3);
402:
403: LOOP
404: l_import_pos := dbms_lob.INSTR(iclob,p_srch_str1,import_srch_pos,1);
405: --
406: IF l_import_pos = 0
407: THEN
408: EXIT;

Line 412: l_namesp_pos := dbms_lob.INSTR(iclob,p_srch_str2,l_import_pos+l_import_len+1,1);

408: EXIT;
409: END IF;
410: --
411: l_namesp_str := '';
412: l_namesp_pos := dbms_lob.INSTR(iclob,p_srch_str2,l_import_pos+l_import_len+1,1);
413: l_end_pos := dbms_lob.INSTR(iclob,p_srch_str4,l_namesp_pos+l_namesp_len+2,1);
414: l_namesp_str :=
415: dbms_lob.SUBSTR(iclob,l_end_pos-l_namesp_pos-l_namesp_len,l_namesp_pos+l_namesp_len);
416: --

Line 413: l_end_pos := dbms_lob.INSTR(iclob,p_srch_str4,l_namesp_pos+l_namesp_len+2,1);

409: END IF;
410: --
411: l_namesp_str := '';
412: l_namesp_pos := dbms_lob.INSTR(iclob,p_srch_str2,l_import_pos+l_import_len+1,1);
413: l_end_pos := dbms_lob.INSTR(iclob,p_srch_str4,l_namesp_pos+l_namesp_len+2,1);
414: l_namesp_str :=
415: dbms_lob.SUBSTR(iclob,l_end_pos-l_namesp_pos-l_namesp_len,l_namesp_pos+l_namesp_len);
416: --
417: l_schema_str := '';

Line 415: dbms_lob.SUBSTR(iclob,l_end_pos-l_namesp_pos-l_namesp_len,l_namesp_pos+l_namesp_len);

411: l_namesp_str := '';
412: l_namesp_pos := dbms_lob.INSTR(iclob,p_srch_str2,l_import_pos+l_import_len+1,1);
413: l_end_pos := dbms_lob.INSTR(iclob,p_srch_str4,l_namesp_pos+l_namesp_len+2,1);
414: l_namesp_str :=
415: dbms_lob.SUBSTR(iclob,l_end_pos-l_namesp_pos-l_namesp_len,l_namesp_pos+l_namesp_len);
416: --
417: l_schema_str := '';
418: l_schema_pos := dbms_lob.INSTR(iclob,p_srch_str3,l_import_pos+l_import_len+1,1);
419: l_end_pos := dbms_lob.INSTR(iclob,p_srch_str4,l_schema_pos+l_schema_len+2,1);

Line 418: l_schema_pos := dbms_lob.INSTR(iclob,p_srch_str3,l_import_pos+l_import_len+1,1);

414: l_namesp_str :=
415: dbms_lob.SUBSTR(iclob,l_end_pos-l_namesp_pos-l_namesp_len,l_namesp_pos+l_namesp_len);
416: --
417: l_schema_str := '';
418: l_schema_pos := dbms_lob.INSTR(iclob,p_srch_str3,l_import_pos+l_import_len+1,1);
419: l_end_pos := dbms_lob.INSTR(iclob,p_srch_str4,l_schema_pos+l_schema_len+2,1);
420: l_schema_str :=
421: dbms_lob.SUBSTR(iclob,l_end_pos-l_schema_pos-l_schema_len,l_schema_pos+l_schema_len);
422: --

Line 419: l_end_pos := dbms_lob.INSTR(iclob,p_srch_str4,l_schema_pos+l_schema_len+2,1);

415: dbms_lob.SUBSTR(iclob,l_end_pos-l_namesp_pos-l_namesp_len,l_namesp_pos+l_namesp_len);
416: --
417: l_schema_str := '';
418: l_schema_pos := dbms_lob.INSTR(iclob,p_srch_str3,l_import_pos+l_import_len+1,1);
419: l_end_pos := dbms_lob.INSTR(iclob,p_srch_str4,l_schema_pos+l_schema_len+2,1);
420: l_schema_str :=
421: dbms_lob.SUBSTR(iclob,l_end_pos-l_schema_pos-l_schema_len,l_schema_pos+l_schema_len);
422: --
423: IF LENGTH(l_namesp_str) > 0

Line 421: dbms_lob.SUBSTR(iclob,l_end_pos-l_schema_pos-l_schema_len,l_schema_pos+l_schema_len);

417: l_schema_str := '';
418: l_schema_pos := dbms_lob.INSTR(iclob,p_srch_str3,l_import_pos+l_import_len+1,1);
419: l_end_pos := dbms_lob.INSTR(iclob,p_srch_str4,l_schema_pos+l_schema_len+2,1);
420: l_schema_str :=
421: dbms_lob.SUBSTR(iclob,l_end_pos-l_schema_pos-l_schema_len,l_schema_pos+l_schema_len);
422: --
423: IF LENGTH(l_namesp_str) > 0
424: THEN
425: IF INSTR(l_namesp_str,'instance',1,1) > 0

Line 468: dbms_lob.freetemporary(iclob);

464: import_srch_pos := l_end_pos + 1;
465: END LOOP;
466: p_valid_str := substr(l_valid_str,1);
467: --
468: dbms_lob.freetemporary(iclob);
469: --
470: END verify_import;
471: --
472: --

Line 500: dbms_lob.open(xbfile);

496: BEGIN
497: l_alias := SUBSTR(filename,1,LENGTH(filename)-4);
498: l_url_ret := ' ';
499: xbfile := bfilename('XMLDIR',filename);
500: dbms_lob.open(xbfile);
501: dbms_lob.createtemporary(xclob,TRUE,dbms_lob.session);
502: dbms_lob.loadfromfile(xclob,xbfile,dbms_lob.getlength(xbfile));
503: dbms_lob.close(xbfile);
504: l_first_len := LENGTH(p_first_srch);

Line 501: dbms_lob.createtemporary(xclob,TRUE,dbms_lob.session);

497: l_alias := SUBSTR(filename,1,LENGTH(filename)-4);
498: l_url_ret := ' ';
499: xbfile := bfilename('XMLDIR',filename);
500: dbms_lob.open(xbfile);
501: dbms_lob.createtemporary(xclob,TRUE,dbms_lob.session);
502: dbms_lob.loadfromfile(xclob,xbfile,dbms_lob.getlength(xbfile));
503: dbms_lob.close(xbfile);
504: l_first_len := LENGTH(p_first_srch);
505: l_first_pos := dbms_lob.INSTR(xclob,p_first_srch,1,1);

Line 502: dbms_lob.loadfromfile(xclob,xbfile,dbms_lob.getlength(xbfile));

498: l_url_ret := ' ';
499: xbfile := bfilename('XMLDIR',filename);
500: dbms_lob.open(xbfile);
501: dbms_lob.createtemporary(xclob,TRUE,dbms_lob.session);
502: dbms_lob.loadfromfile(xclob,xbfile,dbms_lob.getlength(xbfile));
503: dbms_lob.close(xbfile);
504: l_first_len := LENGTH(p_first_srch);
505: l_first_pos := dbms_lob.INSTR(xclob,p_first_srch,1,1);
506: l_second_pos := dbms_lob.INSTR(xclob,p_last_replace,l_first_pos+l_first_len+1,1);

Line 503: dbms_lob.close(xbfile);

499: xbfile := bfilename('XMLDIR',filename);
500: dbms_lob.open(xbfile);
501: dbms_lob.createtemporary(xclob,TRUE,dbms_lob.session);
502: dbms_lob.loadfromfile(xclob,xbfile,dbms_lob.getlength(xbfile));
503: dbms_lob.close(xbfile);
504: l_first_len := LENGTH(p_first_srch);
505: l_first_pos := dbms_lob.INSTR(xclob,p_first_srch,1,1);
506: l_second_pos := dbms_lob.INSTR(xclob,p_last_replace,l_first_pos+l_first_len+1,1);
507: p_url_ret :=

Line 505: l_first_pos := dbms_lob.INSTR(xclob,p_first_srch,1,1);

501: dbms_lob.createtemporary(xclob,TRUE,dbms_lob.session);
502: dbms_lob.loadfromfile(xclob,xbfile,dbms_lob.getlength(xbfile));
503: dbms_lob.close(xbfile);
504: l_first_len := LENGTH(p_first_srch);
505: l_first_pos := dbms_lob.INSTR(xclob,p_first_srch,1,1);
506: l_second_pos := dbms_lob.INSTR(xclob,p_last_replace,l_first_pos+l_first_len+1,1);
507: p_url_ret :=
508: dbms_lob.SUBSTR(xclob,l_second_pos-l_first_pos-l_first_len,l_first_pos+l_first_len);
509: link_srch_pos := 1;

Line 506: l_second_pos := dbms_lob.INSTR(xclob,p_last_replace,l_first_pos+l_first_len+1,1);

502: dbms_lob.loadfromfile(xclob,xbfile,dbms_lob.getlength(xbfile));
503: dbms_lob.close(xbfile);
504: l_first_len := LENGTH(p_first_srch);
505: l_first_pos := dbms_lob.INSTR(xclob,p_first_srch,1,1);
506: l_second_pos := dbms_lob.INSTR(xclob,p_last_replace,l_first_pos+l_first_len+1,1);
507: p_url_ret :=
508: dbms_lob.SUBSTR(xclob,l_second_pos-l_first_pos-l_first_len,l_first_pos+l_first_len);
509: link_srch_pos := 1;
510: l_first_pos := 0;

Line 508: dbms_lob.SUBSTR(xclob,l_second_pos-l_first_pos-l_first_len,l_first_pos+l_first_len);

504: l_first_len := LENGTH(p_first_srch);
505: l_first_pos := dbms_lob.INSTR(xclob,p_first_srch,1,1);
506: l_second_pos := dbms_lob.INSTR(xclob,p_last_replace,l_first_pos+l_first_len+1,1);
507: p_url_ret :=
508: dbms_lob.SUBSTR(xclob,l_second_pos-l_first_pos-l_first_len,l_first_pos+l_first_len);
509: link_srch_pos := 1;
510: l_first_pos := 0;
511: l_second_pos := 0;
512: l_first_len := LENGTH(p_link_srch);

Line 514: l_first_pos := dbms_lob.INSTR(xclob,p_link_srch,link_srch_pos,1);

510: l_first_pos := 0;
511: l_second_pos := 0;
512: l_first_len := LENGTH(p_link_srch);
513: LOOP
514: l_first_pos := dbms_lob.INSTR(xclob,p_link_srch,link_srch_pos,1);
515: IF l_first_pos = 0
516: THEN
517: EXIT;
518: END IF;

Line 519: l_second_pos := dbms_lob.INSTR(xclob,p_last_replace,l_first_pos+l_first_len+1,1);

515: IF l_first_pos = 0
516: THEN
517: EXIT;
518: END IF;
519: l_second_pos := dbms_lob.INSTR(xclob,p_last_replace,l_first_pos+l_first_len+1,1);
520: l_link_ret :=
521: dbms_lob.SUBSTR(xclob,l_second_pos-l_first_pos-l_first_len,l_first_pos+l_first_len);
522: l_alias_pos := INSTR(l_link_ret,l_alias,1);
523: l_file_name := SUBSTR(l_link_ret,l_alias_pos);

Line 521: dbms_lob.SUBSTR(xclob,l_second_pos-l_first_pos-l_first_len,l_first_pos+l_first_len);

517: EXIT;
518: END IF;
519: l_second_pos := dbms_lob.INSTR(xclob,p_last_replace,l_first_pos+l_first_len+1,1);
520: l_link_ret :=
521: dbms_lob.SUBSTR(xclob,l_second_pos-l_first_pos-l_first_len,l_first_pos+l_first_len);
522: l_alias_pos := INSTR(l_link_ret,l_alias,1);
523: l_file_name := SUBSTR(l_link_ret,l_alias_pos);
524: --
525: IF INSTR(l_file_name,'calculation',1) > 0

Line 552: dbms_lob.freetemporary(xclob);

548: END IF;
549: --
550: link_srch_pos := l_second_pos + 1;
551: END LOOP;
552: dbms_lob.freetemporary(xclob);
553: EXCEPTION
554: WHEN others
555: THEN
556: l_url_ret := ' ';

Line 611: dbms_lob.open(xbfile);

607: l_login_id := FND_GLOBAL.Login_Id;
608: l_date := SYSDATE;
609: --
610: xbfile := bfilename('XMLDIR',filename);
611: dbms_lob.open(xbfile);
612: dbms_lob.createtemporary(p_clob,TRUE,dbms_lob.session);
613: dbms_lob.loadfromfile(p_clob,xbfile,dbms_lob.getlength(xbfile));
614: dbms_lob.close(xbfile);
615: --

Line 612: dbms_lob.createtemporary(p_clob,TRUE,dbms_lob.session);

608: l_date := SYSDATE;
609: --
610: xbfile := bfilename('XMLDIR',filename);
611: dbms_lob.open(xbfile);
612: dbms_lob.createtemporary(p_clob,TRUE,dbms_lob.session);
613: dbms_lob.loadfromfile(p_clob,xbfile,dbms_lob.getlength(xbfile));
614: dbms_lob.close(xbfile);
615: --
616: l_elem_found_pos := 1;

Line 613: dbms_lob.loadfromfile(p_clob,xbfile,dbms_lob.getlength(xbfile));

609: --
610: xbfile := bfilename('XMLDIR',filename);
611: dbms_lob.open(xbfile);
612: dbms_lob.createtemporary(p_clob,TRUE,dbms_lob.session);
613: dbms_lob.loadfromfile(p_clob,xbfile,dbms_lob.getlength(xbfile));
614: dbms_lob.close(xbfile);
615: --
616: l_elem_found_pos := 1;
617: --

Line 614: dbms_lob.close(xbfile);

610: xbfile := bfilename('XMLDIR',filename);
611: dbms_lob.open(xbfile);
612: dbms_lob.createtemporary(p_clob,TRUE,dbms_lob.session);
613: dbms_lob.loadfromfile(p_clob,xbfile,dbms_lob.getlength(xbfile));
614: dbms_lob.close(xbfile);
615: --
616: l_elem_found_pos := 1;
617: --
618: LOOP

Line 627: l_elem_srch_pos := dbms_lob.INSTR(p_clob,'

623: l_elem_descr := '';
624: l_exec := 1;
625: --
626: l_elem_srch_pos := 0;
627: l_elem_srch_pos := dbms_lob.INSTR(p_clob,' 628: IF l_elem_srch_pos = 0
629: THEN
630: EXIT;
631: END IF;

Line 633: l_next_elem_pos := dbms_lob.INSTR(p_clob,'

629: THEN
630: EXIT;
631: END IF;
632: --
633: l_next_elem_pos := dbms_lob.INSTR(p_clob,' 634: --
635: -- get name attribute for the element
636: --
637: l_name_srch_pos := 0;

Line 638: l_name_srch_pos := dbms_lob.INSTR(p_clob,'name="',l_elem_srch_pos,1);

634: --
635: -- get name attribute for the element
636: --
637: l_name_srch_pos := 0;
638: l_name_srch_pos := dbms_lob.INSTR(p_clob,'name="',l_elem_srch_pos,1);
639: IF l_name_srch_pos = 0
640: THEN
641: EXIT;
642: END IF;

Line 643: l_second_pos := dbms_lob.INSTR(p_clob,'"',l_name_srch_pos+6,1);

639: IF l_name_srch_pos = 0
640: THEN
641: EXIT;
642: END IF;
643: l_second_pos := dbms_lob.INSTR(p_clob,'"',l_name_srch_pos+6,1);
644: IF (l_next_elem_pos = 0)
645: THEN
646: l_elem_name :=
647: dbms_lob.SUBSTR(p_clob,l_second_pos-l_name_srch_pos-6,l_name_srch_pos+6);

Line 647: dbms_lob.SUBSTR(p_clob,l_second_pos-l_name_srch_pos-6,l_name_srch_pos+6);

643: l_second_pos := dbms_lob.INSTR(p_clob,'"',l_name_srch_pos+6,1);
644: IF (l_next_elem_pos = 0)
645: THEN
646: l_elem_name :=
647: dbms_lob.SUBSTR(p_clob,l_second_pos-l_name_srch_pos-6,l_name_srch_pos+6);
648: ELSE
649: IF (l_name_srch_pos < l_next_elem_pos)
650: THEN
651: l_elem_name :=

Line 652: dbms_lob.SUBSTR(p_clob,l_second_pos-l_name_srch_pos-6,l_name_srch_pos+6);

648: ELSE
649: IF (l_name_srch_pos < l_next_elem_pos)
650: THEN
651: l_elem_name :=
652: dbms_lob.SUBSTR(p_clob,l_second_pos-l_name_srch_pos-6,l_name_srch_pos+6);
653: ELSE
654: l_exec := 0;
655: END IF;
656: END IF;

Line 662: l_id_srch_pos := dbms_lob.INSTR(p_clob,'id="',l_elem_srch_pos,1);

658: --
659: -- get id attribute for the element
660: --
661: l_id_srch_pos := 0;
662: l_id_srch_pos := dbms_lob.INSTR(p_clob,'id="',l_elem_srch_pos,1);
663: IF l_id_srch_pos = 0
664: THEN
665: l_elem_xbrl_id := l_elem_name;
666: ELSE

Line 667: l_second_pos := dbms_lob.INSTR(p_clob,'"',l_id_srch_pos+4,1);

663: IF l_id_srch_pos = 0
664: THEN
665: l_elem_xbrl_id := l_elem_name;
666: ELSE
667: l_second_pos := dbms_lob.INSTR(p_clob,'"',l_id_srch_pos+4,1);
668: IF (l_next_elem_pos = 0)
669: THEN
670: l_elem_xbrl_id :=
671: dbms_lob.SUBSTR(p_clob,l_second_pos-l_id_srch_pos-4,l_id_srch_pos+4);

Line 671: dbms_lob.SUBSTR(p_clob,l_second_pos-l_id_srch_pos-4,l_id_srch_pos+4);

667: l_second_pos := dbms_lob.INSTR(p_clob,'"',l_id_srch_pos+4,1);
668: IF (l_next_elem_pos = 0)
669: THEN
670: l_elem_xbrl_id :=
671: dbms_lob.SUBSTR(p_clob,l_second_pos-l_id_srch_pos-4,l_id_srch_pos+4);
672: ELSE
673: IF (l_id_srch_pos < l_next_elem_pos)
674: THEN
675: l_elem_xbrl_id :=

Line 676: dbms_lob.SUBSTR(p_clob,l_second_pos-l_id_srch_pos-4,l_id_srch_pos+4);

672: ELSE
673: IF (l_id_srch_pos < l_next_elem_pos)
674: THEN
675: l_elem_xbrl_id :=
676: dbms_lob.SUBSTR(p_clob,l_second_pos-l_id_srch_pos-4,l_id_srch_pos+4);
677: ELSE
678: l_elem_xbrl_id := l_elem_name;
679: END IF;
680: END IF;

Line 687: l_type_srch_pos := dbms_lob.INSTR(p_clob,'type="',l_elem_srch_pos,1);

683: --
684: -- get type attribute for the element
685: --
686: l_type_srch_pos := 0;
687: l_type_srch_pos := dbms_lob.INSTR(p_clob,'type="',l_elem_srch_pos,1);
688: IF l_type_srch_pos = 0
689: THEN
690: l_elem_type := '';
691: ELSE

Line 692: l_second_pos := dbms_lob.INSTR(p_clob,'"',l_type_srch_pos+6,1);

688: IF l_type_srch_pos = 0
689: THEN
690: l_elem_type := '';
691: ELSE
692: l_second_pos := dbms_lob.INSTR(p_clob,'"',l_type_srch_pos+6,1);
693: IF (l_next_elem_pos = 0)
694: THEN
695: l_elem_type :=
696: dbms_lob.SUBSTR(p_clob,l_second_pos-l_type_srch_pos-6,l_type_srch_pos+6);

Line 696: dbms_lob.SUBSTR(p_clob,l_second_pos-l_type_srch_pos-6,l_type_srch_pos+6);

692: l_second_pos := dbms_lob.INSTR(p_clob,'"',l_type_srch_pos+6,1);
693: IF (l_next_elem_pos = 0)
694: THEN
695: l_elem_type :=
696: dbms_lob.SUBSTR(p_clob,l_second_pos-l_type_srch_pos-6,l_type_srch_pos+6);
697: ELSE
698: IF (l_type_srch_pos < l_next_elem_pos)
699: THEN
700: l_elem_type :=

Line 701: dbms_lob.SUBSTR(p_clob,l_second_pos-l_type_srch_pos-6,l_type_srch_pos+6);

697: ELSE
698: IF (l_type_srch_pos < l_next_elem_pos)
699: THEN
700: l_elem_type :=
701: dbms_lob.SUBSTR(p_clob,l_second_pos-l_type_srch_pos-6,l_type_srch_pos+6);
702: ELSE
703: l_elem_type := '';
704: END IF;
705: END IF;

Line 712: l_group_srch_pos := dbms_lob.INSTR(p_clob,'substitutionGroup="',l_elem_srch_pos,1);

708: --
709: -- get group attribute for the element
710: --
711: l_group_srch_pos := 0;
712: l_group_srch_pos := dbms_lob.INSTR(p_clob,'substitutionGroup="',l_elem_srch_pos,1);
713: IF l_group_srch_pos = 0
714: THEN
715: l_elem_group := '';
716: ELSE

Line 717: l_second_pos := dbms_lob.INSTR(p_clob,'"',l_group_srch_pos+19,1);

713: IF l_group_srch_pos = 0
714: THEN
715: l_elem_group := '';
716: ELSE
717: l_second_pos := dbms_lob.INSTR(p_clob,'"',l_group_srch_pos+19,1);
718: IF (l_next_elem_pos = 0)
719: THEN
720: l_elem_group :=
721: dbms_lob.SUBSTR(p_clob,l_second_pos-l_group_srch_pos-19,l_group_srch_pos+19);

Line 721: dbms_lob.SUBSTR(p_clob,l_second_pos-l_group_srch_pos-19,l_group_srch_pos+19);

717: l_second_pos := dbms_lob.INSTR(p_clob,'"',l_group_srch_pos+19,1);
718: IF (l_next_elem_pos = 0)
719: THEN
720: l_elem_group :=
721: dbms_lob.SUBSTR(p_clob,l_second_pos-l_group_srch_pos-19,l_group_srch_pos+19);
722: ELSE
723: IF (l_group_srch_pos < l_next_elem_pos)
724: THEN
725: l_elem_group :=

Line 726: dbms_lob.SUBSTR(p_clob,l_second_pos-l_group_srch_pos-19,l_group_srch_pos+19);

722: ELSE
723: IF (l_group_srch_pos < l_next_elem_pos)
724: THEN
725: l_elem_group :=
726: dbms_lob.SUBSTR(p_clob,l_second_pos-l_group_srch_pos-19,l_group_srch_pos+19);
727: ELSE
728: l_elem_group := '';
729: END IF;
730: END IF;

Line 737: l_docm_srch_pos := dbms_lob.INSTR(p_clob,'',l_elem_srch_pos,1);

733: --
734: -- get documentation attribute for the element
735: --
736: l_docm_srch_pos := 0;
737: l_docm_srch_pos := dbms_lob.INSTR(p_clob,'',l_elem_srch_pos,1);
738: IF l_docm_srch_pos = 0
739: THEN
740: l_elem_descr := '';
741: ELSE

Line 742: l_second_pos := dbms_lob.INSTR(p_clob,'',l_docm_srch_pos+15,1);

738: IF l_docm_srch_pos = 0
739: THEN
740: l_elem_descr := '';
741: ELSE
742: l_second_pos := dbms_lob.INSTR(p_clob,'',l_docm_srch_pos+15,1);
743: IF (l_next_elem_pos = 0)
744: THEN
745: IF (l_second_pos-l_docm_srch_pos-15) > 1000
746: THEN

Line 748: dbms_lob.SUBSTR(p_clob,1000,l_docm_srch_pos+15);

744: THEN
745: IF (l_second_pos-l_docm_srch_pos-15) > 1000
746: THEN
747: l_elem_descr :=
748: dbms_lob.SUBSTR(p_clob,1000,l_docm_srch_pos+15);
749: ELSE
750: l_elem_descr :=
751: dbms_lob.SUBSTR(p_clob,l_second_pos-l_docm_srch_pos-15,l_docm_srch_pos+15);
752: END IF;

Line 751: dbms_lob.SUBSTR(p_clob,l_second_pos-l_docm_srch_pos-15,l_docm_srch_pos+15);

747: l_elem_descr :=
748: dbms_lob.SUBSTR(p_clob,1000,l_docm_srch_pos+15);
749: ELSE
750: l_elem_descr :=
751: dbms_lob.SUBSTR(p_clob,l_second_pos-l_docm_srch_pos-15,l_docm_srch_pos+15);
752: END IF;
753: ELSE
754: IF (l_group_srch_pos < l_next_elem_pos)
755: THEN

Line 759: dbms_lob.SUBSTR(p_clob,1000,l_docm_srch_pos+15);

755: THEN
756: IF (l_second_pos-l_docm_srch_pos-15) > 1000
757: THEN
758: l_elem_descr :=
759: dbms_lob.SUBSTR(p_clob,1000,l_docm_srch_pos+15);
760: ELSE
761: l_elem_descr :=
762: dbms_lob.SUBSTR(p_clob,l_second_pos-l_docm_srch_pos-15,l_docm_srch_pos+15);
763: END IF;

Line 762: dbms_lob.SUBSTR(p_clob,l_second_pos-l_docm_srch_pos-15,l_docm_srch_pos+15);

758: l_elem_descr :=
759: dbms_lob.SUBSTR(p_clob,1000,l_docm_srch_pos+15);
760: ELSE
761: l_elem_descr :=
762: dbms_lob.SUBSTR(p_clob,l_second_pos-l_docm_srch_pos-15,l_docm_srch_pos+15);
763: END IF;
764: ELSE
765: l_elem_group := '';
766: END IF;

Line 774: l_abstr_srch_pos := dbms_lob.INSTR(p_clob,'abstract="true"',l_elem_srch_pos,1);

770: --
771: -- get abstract attribute for the element
772: --
773: l_abstr_srch_pos := 0;
774: l_abstr_srch_pos := dbms_lob.INSTR(p_clob,'abstract="true"',l_elem_srch_pos,1);
775: IF l_abstr_srch_pos > 0
776: THEN
777: IF (l_next_elem_pos = 0)
778: THEN

Line 828: dbms_lob.freetemporary(p_clob);

824: END IF;
825: --
826: l_elem_found_pos := l_elem_srch_pos + 5;
827: END LOOP;
828: dbms_lob.freetemporary(p_clob);
829: -- COMMIT;
830: --
831: -- add elements from imported taxonomies for the taxonomy_id
832: -- into RG_XBRL_MAP_ELEMENTS using p_valid_str

Line 948: dbms_lob.open(xbfile);

944: FOR UPDATE;
945: --
946: BEGIN
947: xbfile := bfilename('XMLDIR',filename);
948: dbms_lob.open(xbfile);
949: dbms_lob.createtemporary(l_clob,TRUE,dbms_lob.session);
950: dbms_lob.loadfromfile(l_clob,xbfile,dbms_lob.getlength(xbfile));
951: dbms_lob.close(xbfile);
952: --

Line 949: dbms_lob.createtemporary(l_clob,TRUE,dbms_lob.session);

945: --
946: BEGIN
947: xbfile := bfilename('XMLDIR',filename);
948: dbms_lob.open(xbfile);
949: dbms_lob.createtemporary(l_clob,TRUE,dbms_lob.session);
950: dbms_lob.loadfromfile(l_clob,xbfile,dbms_lob.getlength(xbfile));
951: dbms_lob.close(xbfile);
952: --
953: OPEN tax_el_storage(p_taxonomy_id);

Line 950: dbms_lob.loadfromfile(l_clob,xbfile,dbms_lob.getlength(xbfile));

946: BEGIN
947: xbfile := bfilename('XMLDIR',filename);
948: dbms_lob.open(xbfile);
949: dbms_lob.createtemporary(l_clob,TRUE,dbms_lob.session);
950: dbms_lob.loadfromfile(l_clob,xbfile,dbms_lob.getlength(xbfile));
951: dbms_lob.close(xbfile);
952: --
953: OPEN tax_el_storage(p_taxonomy_id);
954: LOOP

Line 951: dbms_lob.close(xbfile);

947: xbfile := bfilename('XMLDIR',filename);
948: dbms_lob.open(xbfile);
949: dbms_lob.createtemporary(l_clob,TRUE,dbms_lob.session);
950: dbms_lob.loadfromfile(l_clob,xbfile,dbms_lob.getlength(xbfile));
951: dbms_lob.close(xbfile);
952: --
953: OPEN tax_el_storage(p_taxonomy_id);
954: LOOP
955: l_element_id := 0;

Line 967: l_start_pos := dbms_lob.INSTR(l_clob,p_tax_name || '.xsd#' || l_element_xbrl_id,1,1);

963: IF tax_el_storage%NOTFOUND THEN
964: EXIT;
965: END IF;
966: --
967: l_start_pos := dbms_lob.INSTR(l_clob,p_tax_name || '.xsd#' || l_element_xbrl_id,1,1);
968: l_title_pos := dbms_lob.INSTR(l_clob, 'label="', l_start_pos+6, 1);
969: l_second_pos := dbms_lob.INSTR(l_clob, '"', l_title_pos+7, 1);
970: l_label_descr :=
971: dbms_lob.SUBSTR(l_clob,l_second_pos-l_title_pos-7,l_title_pos+7);

Line 968: l_title_pos := dbms_lob.INSTR(l_clob, 'label="', l_start_pos+6, 1);

964: EXIT;
965: END IF;
966: --
967: l_start_pos := dbms_lob.INSTR(l_clob,p_tax_name || '.xsd#' || l_element_xbrl_id,1,1);
968: l_title_pos := dbms_lob.INSTR(l_clob, 'label="', l_start_pos+6, 1);
969: l_second_pos := dbms_lob.INSTR(l_clob, '"', l_title_pos+7, 1);
970: l_label_descr :=
971: dbms_lob.SUBSTR(l_clob,l_second_pos-l_title_pos-7,l_title_pos+7);
972: --

Line 969: l_second_pos := dbms_lob.INSTR(l_clob, '"', l_title_pos+7, 1);

965: END IF;
966: --
967: l_start_pos := dbms_lob.INSTR(l_clob,p_tax_name || '.xsd#' || l_element_xbrl_id,1,1);
968: l_title_pos := dbms_lob.INSTR(l_clob, 'label="', l_start_pos+6, 1);
969: l_second_pos := dbms_lob.INSTR(l_clob, '"', l_title_pos+7, 1);
970: l_label_descr :=
971: dbms_lob.SUBSTR(l_clob,l_second_pos-l_title_pos-7,l_title_pos+7);
972: --
973: -- label description in loc is ready in l_label_descr

Line 971: dbms_lob.SUBSTR(l_clob,l_second_pos-l_title_pos-7,l_title_pos+7);

967: l_start_pos := dbms_lob.INSTR(l_clob,p_tax_name || '.xsd#' || l_element_xbrl_id,1,1);
968: l_title_pos := dbms_lob.INSTR(l_clob, 'label="', l_start_pos+6, 1);
969: l_second_pos := dbms_lob.INSTR(l_clob, '"', l_title_pos+7, 1);
970: l_label_descr :=
971: dbms_lob.SUBSTR(l_clob,l_second_pos-l_title_pos-7,l_title_pos+7);
972: --
973: -- label description in loc is ready in l_label_descr
974: --
975: -- now find xlink:to="l_label_descr"

Line 977: l_link_to_pos := dbms_lob.INSTR(l_clob,'xlink:to="' || l_label_descr || '"',1,1);

973: -- label description in loc is ready in l_label_descr
974: --
975: -- now find xlink:to="l_label_descr"
976: --
977: l_link_to_pos := dbms_lob.INSTR(l_clob,'xlink:to="' || l_label_descr || '"',1,1);
978: --
979: -- now find the nearest 980: --
981: l_cur_lblarc_pos := 1;

Line 984: l_prev_lblarc_pos := dbms_lob.INSTR(l_clob, '

980: --
981: l_cur_lblarc_pos := 1;
982: l_near_lblarc_pos := 1;
983: l_prev_lblarc_pos := 1;
984: l_prev_lblarc_pos := dbms_lob.INSTR(l_clob, ' 985: LOOP
986: l_fnd_lblarc_pos := dbms_lob.INSTR(l_clob, ' 987: IF (l_fnd_lblarc_pos = 0) OR (l_fnd_lblarc_pos > l_link_to_pos)
988: THEN

Line 986: l_fnd_lblarc_pos := dbms_lob.INSTR(l_clob, '

982: l_near_lblarc_pos := 1;
983: l_prev_lblarc_pos := 1;
984: l_prev_lblarc_pos := dbms_lob.INSTR(l_clob, ' 985: LOOP
986: l_fnd_lblarc_pos := dbms_lob.INSTR(l_clob, ' 987: IF (l_fnd_lblarc_pos = 0) OR (l_fnd_lblarc_pos > l_link_to_pos)
988: THEN
989: l_near_lblarc_pos := l_cur_lblarc_pos;
990: EXIT;

Line 998: l_link_from_pos := dbms_lob.INSTR(l_clob,'xlink:from="',l_near_lblarc_pos,1);

994: END LOOP;
995: --
996: -- l_near_lblarc_pos is ready
997: --
998: l_link_from_pos := dbms_lob.INSTR(l_clob,'xlink:from="',l_near_lblarc_pos,1);
999: l_second_pos := dbms_lob.INSTR(l_clob, '"', l_link_from_pos+12, 1);
1000: l_label_from :=
1001: dbms_lob.SUBSTR(l_clob,l_second_pos-l_link_from_pos-12,l_link_from_pos+12);
1002: --

Line 999: l_second_pos := dbms_lob.INSTR(l_clob, '"', l_link_from_pos+12, 1);

995: --
996: -- l_near_lblarc_pos is ready
997: --
998: l_link_from_pos := dbms_lob.INSTR(l_clob,'xlink:from="',l_near_lblarc_pos,1);
999: l_second_pos := dbms_lob.INSTR(l_clob, '"', l_link_from_pos+12, 1);
1000: l_label_from :=
1001: dbms_lob.SUBSTR(l_clob,l_second_pos-l_link_from_pos-12,l_link_from_pos+12);
1002: --
1003: -- l_label_from is ready for xlink:label=" " search

Line 1001: dbms_lob.SUBSTR(l_clob,l_second_pos-l_link_from_pos-12,l_link_from_pos+12);

997: --
998: l_link_from_pos := dbms_lob.INSTR(l_clob,'xlink:from="',l_near_lblarc_pos,1);
999: l_second_pos := dbms_lob.INSTR(l_clob, '"', l_link_from_pos+12, 1);
1000: l_label_from :=
1001: dbms_lob.SUBSTR(l_clob,l_second_pos-l_link_from_pos-12,l_link_from_pos+12);
1002: --
1003: -- l_label_from is ready for xlink:label=" " search
1004: --
1005: l_label_pos := dbms_lob.INSTR(l_clob,

Line 1005: l_label_pos := dbms_lob.INSTR(l_clob,

1001: dbms_lob.SUBSTR(l_clob,l_second_pos-l_link_from_pos-12,l_link_from_pos+12);
1002: --
1003: -- l_label_from is ready for xlink:label=" " search
1004: --
1005: l_label_pos := dbms_lob.INSTR(l_clob,
1006: 'xlink:label="' || l_label_from, 1, 1);
1007: l_right_br_pos := dbms_lob.INSTR(l_clob, '>', l_label_pos, 1);
1008: l_left_br_pos := dbms_lob.INSTR(l_clob, '<', l_right_br_pos+1, 1);
1009: --

Line 1007: l_right_br_pos := dbms_lob.INSTR(l_clob, '>', l_label_pos, 1);

1003: -- l_label_from is ready for xlink:label=" " search
1004: --
1005: l_label_pos := dbms_lob.INSTR(l_clob,
1006: 'xlink:label="' || l_label_from, 1, 1);
1007: l_right_br_pos := dbms_lob.INSTR(l_clob, '>', l_label_pos, 1);
1008: l_left_br_pos := dbms_lob.INSTR(l_clob, '<', l_right_br_pos+1, 1);
1009: --
1010: l_label :=
1011: dbms_lob.SUBSTR(l_clob,l_left_br_pos-l_right_br_pos-1, l_right_br_pos+1);

Line 1008: l_left_br_pos := dbms_lob.INSTR(l_clob, '<', l_right_br_pos+1, 1);

1004: --
1005: l_label_pos := dbms_lob.INSTR(l_clob,
1006: 'xlink:label="' || l_label_from, 1, 1);
1007: l_right_br_pos := dbms_lob.INSTR(l_clob, '>', l_label_pos, 1);
1008: l_left_br_pos := dbms_lob.INSTR(l_clob, '<', l_right_br_pos+1, 1);
1009: --
1010: l_label :=
1011: dbms_lob.SUBSTR(l_clob,l_left_br_pos-l_right_br_pos-1, l_right_br_pos+1);
1012: --

Line 1011: dbms_lob.SUBSTR(l_clob,l_left_br_pos-l_right_br_pos-1, l_right_br_pos+1);

1007: l_right_br_pos := dbms_lob.INSTR(l_clob, '>', l_label_pos, 1);
1008: l_left_br_pos := dbms_lob.INSTR(l_clob, '<', l_right_br_pos+1, 1);
1009: --
1010: l_label :=
1011: dbms_lob.SUBSTR(l_clob,l_left_br_pos-l_right_br_pos-1, l_right_br_pos+1);
1012: --
1013: UPDATE RG_XBRL_ELEMENTS
1014: SET element_label = l_label
1015: WHERE CURRENT OF tax_el_storage;

Line 1018: dbms_lob.freetemporary(l_clob);

1014: SET element_label = l_label
1015: WHERE CURRENT OF tax_el_storage;
1016: END LOOP;
1017: CLOSE tax_el_storage;
1018: dbms_lob.freetemporary(l_clob);
1019: COMMIT;
1020: END update_lbl_clob;
1021: --
1022: --

Line 1059: dbms_lob.open(xbfile);

1055: FOR UPDATE;
1056: --
1057: BEGIN
1058: xbfile := bfilename('XMLDIR',filename);
1059: dbms_lob.open(xbfile);
1060: dbms_lob.createtemporary(d_clob,TRUE,dbms_lob.session);
1061: dbms_lob.loadfromfile(d_clob,xbfile,dbms_lob.getlength(xbfile));
1062: dbms_lob.close(xbfile);
1063: --

Line 1060: dbms_lob.createtemporary(d_clob,TRUE,dbms_lob.session);

1056: --
1057: BEGIN
1058: xbfile := bfilename('XMLDIR',filename);
1059: dbms_lob.open(xbfile);
1060: dbms_lob.createtemporary(d_clob,TRUE,dbms_lob.session);
1061: dbms_lob.loadfromfile(d_clob,xbfile,dbms_lob.getlength(xbfile));
1062: dbms_lob.close(xbfile);
1063: --
1064: OPEN tax_el_storage(p_taxonomy_id);

Line 1061: dbms_lob.loadfromfile(d_clob,xbfile,dbms_lob.getlength(xbfile));

1057: BEGIN
1058: xbfile := bfilename('XMLDIR',filename);
1059: dbms_lob.open(xbfile);
1060: dbms_lob.createtemporary(d_clob,TRUE,dbms_lob.session);
1061: dbms_lob.loadfromfile(d_clob,xbfile,dbms_lob.getlength(xbfile));
1062: dbms_lob.close(xbfile);
1063: --
1064: OPEN tax_el_storage(p_taxonomy_id);
1065: LOOP

Line 1062: dbms_lob.close(xbfile);

1058: xbfile := bfilename('XMLDIR',filename);
1059: dbms_lob.open(xbfile);
1060: dbms_lob.createtemporary(d_clob,TRUE,dbms_lob.session);
1061: dbms_lob.loadfromfile(d_clob,xbfile,dbms_lob.getlength(xbfile));
1062: dbms_lob.close(xbfile);
1063: --
1064: OPEN tax_el_storage(p_taxonomy_id);
1065: LOOP
1066: l_element_id := 0;

Line 1077: l_start_pos := dbms_lob.INSTR(d_clob,p_tax_name || '.xsd#' || l_element_xbrl_id,1,1);

1073: IF tax_el_storage%NOTFOUND THEN
1074: EXIT;
1075: END IF;
1076: --
1077: l_start_pos := dbms_lob.INSTR(d_clob,p_tax_name || '.xsd#' || l_element_xbrl_id,1,1);
1078: l_title_pos := dbms_lob.INSTR(d_clob, 'label="', l_start_pos+6, 1);
1079: l_second_pos := dbms_lob.INSTR(d_clob, '"', l_title_pos+7, 1);
1080: l_title_descr :=
1081: dbms_lob.SUBSTR(d_clob,l_second_pos-l_title_pos-7,l_title_pos+7);

Line 1078: l_title_pos := dbms_lob.INSTR(d_clob, 'label="', l_start_pos+6, 1);

1074: EXIT;
1075: END IF;
1076: --
1077: l_start_pos := dbms_lob.INSTR(d_clob,p_tax_name || '.xsd#' || l_element_xbrl_id,1,1);
1078: l_title_pos := dbms_lob.INSTR(d_clob, 'label="', l_start_pos+6, 1);
1079: l_second_pos := dbms_lob.INSTR(d_clob, '"', l_title_pos+7, 1);
1080: l_title_descr :=
1081: dbms_lob.SUBSTR(d_clob,l_second_pos-l_title_pos-7,l_title_pos+7);
1082: --

Line 1079: l_second_pos := dbms_lob.INSTR(d_clob, '"', l_title_pos+7, 1);

1075: END IF;
1076: --
1077: l_start_pos := dbms_lob.INSTR(d_clob,p_tax_name || '.xsd#' || l_element_xbrl_id,1,1);
1078: l_title_pos := dbms_lob.INSTR(d_clob, 'label="', l_start_pos+6, 1);
1079: l_second_pos := dbms_lob.INSTR(d_clob, '"', l_title_pos+7, 1);
1080: l_title_descr :=
1081: dbms_lob.SUBSTR(d_clob,l_second_pos-l_title_pos-7,l_title_pos+7);
1082: --
1083: l_def_arc_pos := dbms_lob.INSTR(d_clob, '

Line 1081: dbms_lob.SUBSTR(d_clob,l_second_pos-l_title_pos-7,l_title_pos+7);

1077: l_start_pos := dbms_lob.INSTR(d_clob,p_tax_name || '.xsd#' || l_element_xbrl_id,1,1);
1078: l_title_pos := dbms_lob.INSTR(d_clob, 'label="', l_start_pos+6, 1);
1079: l_second_pos := dbms_lob.INSTR(d_clob, '"', l_title_pos+7, 1);
1080: l_title_descr :=
1081: dbms_lob.SUBSTR(d_clob,l_second_pos-l_title_pos-7,l_title_pos+7);
1082: --
1083: l_def_arc_pos := dbms_lob.INSTR(d_clob, ' 1084: l_from_pos := dbms_lob.INSTR(d_clob, 'from="' || l_title_descr, l_def_arc_pos, 1);
1085: l_to_pos := dbms_lob.INSTR(d_clob, 'to="' || l_title_descr, l_from_pos+6, 1);

Line 1083: l_def_arc_pos := dbms_lob.INSTR(d_clob, '

1079: l_second_pos := dbms_lob.INSTR(d_clob, '"', l_title_pos+7, 1);
1080: l_title_descr :=
1081: dbms_lob.SUBSTR(d_clob,l_second_pos-l_title_pos-7,l_title_pos+7);
1082: --
1083: l_def_arc_pos := dbms_lob.INSTR(d_clob, ' 1084: l_from_pos := dbms_lob.INSTR(d_clob, 'from="' || l_title_descr, l_def_arc_pos, 1);
1085: l_to_pos := dbms_lob.INSTR(d_clob, 'to="' || l_title_descr, l_from_pos+6, 1);
1086: l_second_pos := dbms_lob.INSTR(d_clob, '"', l_to_pos+5, 1);
1087: l_parent_descr :=

Line 1084: l_from_pos := dbms_lob.INSTR(d_clob, 'from="' || l_title_descr, l_def_arc_pos, 1);

1080: l_title_descr :=
1081: dbms_lob.SUBSTR(d_clob,l_second_pos-l_title_pos-7,l_title_pos+7);
1082: --
1083: l_def_arc_pos := dbms_lob.INSTR(d_clob, ' 1084: l_from_pos := dbms_lob.INSTR(d_clob, 'from="' || l_title_descr, l_def_arc_pos, 1);
1085: l_to_pos := dbms_lob.INSTR(d_clob, 'to="' || l_title_descr, l_from_pos+6, 1);
1086: l_second_pos := dbms_lob.INSTR(d_clob, '"', l_to_pos+5, 1);
1087: l_parent_descr :=
1088: dbms_lob.SUBSTR(d_clob,l_second_pos-l_to_pos-4,l_to_pos+4);

Line 1085: l_to_pos := dbms_lob.INSTR(d_clob, 'to="' || l_title_descr, l_from_pos+6, 1);

1081: dbms_lob.SUBSTR(d_clob,l_second_pos-l_title_pos-7,l_title_pos+7);
1082: --
1083: l_def_arc_pos := dbms_lob.INSTR(d_clob, ' 1084: l_from_pos := dbms_lob.INSTR(d_clob, 'from="' || l_title_descr, l_def_arc_pos, 1);
1085: l_to_pos := dbms_lob.INSTR(d_clob, 'to="' || l_title_descr, l_from_pos+6, 1);
1086: l_second_pos := dbms_lob.INSTR(d_clob, '"', l_to_pos+5, 1);
1087: l_parent_descr :=
1088: dbms_lob.SUBSTR(d_clob,l_second_pos-l_to_pos-4,l_to_pos+4);
1089: --

Line 1086: l_second_pos := dbms_lob.INSTR(d_clob, '"', l_to_pos+5, 1);

1082: --
1083: l_def_arc_pos := dbms_lob.INSTR(d_clob, ' 1084: l_from_pos := dbms_lob.INSTR(d_clob, 'from="' || l_title_descr, l_def_arc_pos, 1);
1085: l_to_pos := dbms_lob.INSTR(d_clob, 'to="' || l_title_descr, l_from_pos+6, 1);
1086: l_second_pos := dbms_lob.INSTR(d_clob, '"', l_to_pos+5, 1);
1087: l_parent_descr :=
1088: dbms_lob.SUBSTR(d_clob,l_second_pos-l_to_pos-4,l_to_pos+4);
1089: --
1090: l_ref_pos := dbms_lob.INSTR(d_clob, 'href="' || p_tax_name || '.xsd#' || l_parent_descr,

Line 1088: dbms_lob.SUBSTR(d_clob,l_second_pos-l_to_pos-4,l_to_pos+4);

1084: l_from_pos := dbms_lob.INSTR(d_clob, 'from="' || l_title_descr, l_def_arc_pos, 1);
1085: l_to_pos := dbms_lob.INSTR(d_clob, 'to="' || l_title_descr, l_from_pos+6, 1);
1086: l_second_pos := dbms_lob.INSTR(d_clob, '"', l_to_pos+5, 1);
1087: l_parent_descr :=
1088: dbms_lob.SUBSTR(d_clob,l_second_pos-l_to_pos-4,l_to_pos+4);
1089: --
1090: l_ref_pos := dbms_lob.INSTR(d_clob, 'href="' || p_tax_name || '.xsd#' || l_parent_descr,
1091: 1, 1);
1092: --

Line 1090: l_ref_pos := dbms_lob.INSTR(d_clob, 'href="' || p_tax_name || '.xsd#' || l_parent_descr,

1086: l_second_pos := dbms_lob.INSTR(d_clob, '"', l_to_pos+5, 1);
1087: l_parent_descr :=
1088: dbms_lob.SUBSTR(d_clob,l_second_pos-l_to_pos-4,l_to_pos+4);
1089: --
1090: l_ref_pos := dbms_lob.INSTR(d_clob, 'href="' || p_tax_name || '.xsd#' || l_parent_descr,
1091: 1, 1);
1092: --
1093: l_element_defn_parent := '';
1094: IF (l_ref_pos > 0) AND (l_parent_descr <> l_element_xbrl_id)

Line 1104: dbms_lob.freetemporary(d_clob);

1100: SET parent_identifier = l_element_defn_parent
1101: WHERE CURRENT OF tax_el_storage;
1102: END LOOP;
1103: CLOSE tax_el_storage;
1104: dbms_lob.freetemporary(d_clob);
1105: COMMIT;
1106: END update_dfn_clob;
1107: --
1108: END RG_XBRL_PKG;