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

Line 862: l_start_index := dbms_lob.instr(p_document,l_class_attr,1,1);

858: pa_debug.set_err_stack('PA_WORKFLOW_UTILS.modify_wf_clob_content');
859: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
860: l_debug_mode := NVL(l_debug_mode, 'Y');
861: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
862: l_start_index := dbms_lob.instr(p_document,l_class_attr,1,1);
863: while l_start_index <> 0 loop
864: l_end_index := dbms_lob.instr(p_document,l_end_quote,l_start_index+length(l_class_attr),1);
865: l_amount := l_end_index-l_start_index+1;
866: dbms_lob.erase(p_document,l_amount,l_start_index);

Line 864: l_end_index := dbms_lob.instr(p_document,l_end_quote,l_start_index+length(l_class_attr),1);

860: l_debug_mode := NVL(l_debug_mode, 'Y');
861: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
862: l_start_index := dbms_lob.instr(p_document,l_class_attr,1,1);
863: while l_start_index <> 0 loop
864: l_end_index := dbms_lob.instr(p_document,l_end_quote,l_start_index+length(l_class_attr),1);
865: l_amount := l_end_index-l_start_index+1;
866: dbms_lob.erase(p_document,l_amount,l_start_index);
867: l_start_index := dbms_lob.instr(p_document,l_class_attr,l_end_index,1);
868: end loop;

Line 866: dbms_lob.erase(p_document,l_amount,l_start_index);

862: l_start_index := dbms_lob.instr(p_document,l_class_attr,1,1);
863: while l_start_index <> 0 loop
864: l_end_index := dbms_lob.instr(p_document,l_end_quote,l_start_index+length(l_class_attr),1);
865: l_amount := l_end_index-l_start_index+1;
866: dbms_lob.erase(p_document,l_amount,l_start_index);
867: l_start_index := dbms_lob.instr(p_document,l_class_attr,l_end_index,1);
868: end loop;
869:
870: --Identify the start and the end indices of the base tag and erase it from

Line 867: l_start_index := dbms_lob.instr(p_document,l_class_attr,l_end_index,1);

863: while l_start_index <> 0 loop
864: l_end_index := dbms_lob.instr(p_document,l_end_quote,l_start_index+length(l_class_attr),1);
865: l_amount := l_end_index-l_start_index+1;
866: dbms_lob.erase(p_document,l_amount,l_start_index);
867: l_start_index := dbms_lob.instr(p_document,l_class_attr,l_end_index,1);
868: end loop;
869:
870: --Identify the start and the end indices of the base tag and erase it from
871: --the clob contents.

Line 872: l_start_index := dbms_lob.instr(p_document,BASE_TAG,1,1);

868: end loop;
869:
870: --Identify the start and the end indices of the base tag and erase it from
871: --the clob contents.
872: l_start_index := dbms_lob.instr(p_document,BASE_TAG,1,1);
873:
874: -- dbms_lob will throw error if l_start_index <> 0 is not present -- changes commented for bug 4350867
875: -- if(l_start_index <> 0) then -- Added If condition for 4289078
876: -- l_end_index := dbms_lob.instr(p_document,END_TAG,l_start_index,1);

Line 874: -- dbms_lob will throw error if l_start_index <> 0 is not present -- changes commented for bug 4350867

870: --Identify the start and the end indices of the base tag and erase it from
871: --the clob contents.
872: l_start_index := dbms_lob.instr(p_document,BASE_TAG,1,1);
873:
874: -- dbms_lob will throw error if l_start_index <> 0 is not present -- changes commented for bug 4350867
875: -- if(l_start_index <> 0) then -- Added If condition for 4289078
876: -- l_end_index := dbms_lob.instr(p_document,END_TAG,l_start_index,1);
877: -- l_amount := l_end_index-l_start_index+1;
878: -- dbms_lob.erase(p_document,l_amount,l_start_index);

Line 876: -- l_end_index := dbms_lob.instr(p_document,END_TAG,l_start_index,1);

872: l_start_index := dbms_lob.instr(p_document,BASE_TAG,1,1);
873:
874: -- dbms_lob will throw error if l_start_index <> 0 is not present -- changes commented for bug 4350867
875: -- if(l_start_index <> 0) then -- Added If condition for 4289078
876: -- l_end_index := dbms_lob.instr(p_document,END_TAG,l_start_index,1);
877: -- l_amount := l_end_index-l_start_index+1;
878: -- dbms_lob.erase(p_document,l_amount,l_start_index);
879: -- end if;
880:

Line 878: -- dbms_lob.erase(p_document,l_amount,l_start_index);

874: -- dbms_lob will throw error if l_start_index <> 0 is not present -- changes commented for bug 4350867
875: -- if(l_start_index <> 0) then -- Added If condition for 4289078
876: -- l_end_index := dbms_lob.instr(p_document,END_TAG,l_start_index,1);
877: -- l_amount := l_end_index-l_start_index+1;
878: -- dbms_lob.erase(p_document,l_amount,l_start_index);
879: -- end if;
880:
881: --Identify the start and the end indices of the style sheet tag and erase it from
882: --the clob contents.

Line 883: l_start_index := dbms_lob.instr(p_document,STYLE_TAG,1,1);

879: -- end if;
880:
881: --Identify the start and the end indices of the style sheet tag and erase it from
882: --the clob contents.
883: l_start_index := dbms_lob.instr(p_document,STYLE_TAG,1,1);
884: if(l_start_index <> 0) then -- Added If condition for 4289078
885: l_end_index := dbms_lob.instr(p_document,END_TAG,l_start_index,1);
886: l_amount := l_end_index-l_start_index+1;
887: dbms_lob.erase(p_document,l_amount,l_start_index);

Line 885: l_end_index := dbms_lob.instr(p_document,END_TAG,l_start_index,1);

881: --Identify the start and the end indices of the style sheet tag and erase it from
882: --the clob contents.
883: l_start_index := dbms_lob.instr(p_document,STYLE_TAG,1,1);
884: if(l_start_index <> 0) then -- Added If condition for 4289078
885: l_end_index := dbms_lob.instr(p_document,END_TAG,l_start_index,1);
886: l_amount := l_end_index-l_start_index+1;
887: dbms_lob.erase(p_document,l_amount,l_start_index);
888: end if;
889:

Line 887: dbms_lob.erase(p_document,l_amount,l_start_index);

883: l_start_index := dbms_lob.instr(p_document,STYLE_TAG,1,1);
884: if(l_start_index <> 0) then -- Added If condition for 4289078
885: l_end_index := dbms_lob.instr(p_document,END_TAG,l_start_index,1);
886: l_amount := l_end_index-l_start_index+1;
887: dbms_lob.erase(p_document,l_amount,l_start_index);
888: end if;
889:
890: --Identify the start and the end indices of the input tag and erase it from
891: --the clob contents.

Line 892: l_start_index := dbms_lob.instr(p_document,INPUT_TAG,1,1);

888: end if;
889:
890: --Identify the start and the end indices of the input tag and erase it from
891: --the clob contents.
892: l_start_index := dbms_lob.instr(p_document,INPUT_TAG,1,1);
893: while l_start_index <> 0 loop
894: l_end_index := dbms_lob.instr(p_document,END_TAG,l_start_index+length(INPUT_TAG),1);
895: l_amount := l_end_index-l_start_index+1;
896: dbms_lob.erase(p_document,l_amount,l_start_index);

Line 894: l_end_index := dbms_lob.instr(p_document,END_TAG,l_start_index+length(INPUT_TAG),1);

890: --Identify the start and the end indices of the input tag and erase it from
891: --the clob contents.
892: l_start_index := dbms_lob.instr(p_document,INPUT_TAG,1,1);
893: while l_start_index <> 0 loop
894: l_end_index := dbms_lob.instr(p_document,END_TAG,l_start_index+length(INPUT_TAG),1);
895: l_amount := l_end_index-l_start_index+1;
896: dbms_lob.erase(p_document,l_amount,l_start_index);
897: l_start_index := dbms_lob.instr(p_document,INPUT_TAG,l_end_index,1);
898: end loop;

Line 896: dbms_lob.erase(p_document,l_amount,l_start_index);

892: l_start_index := dbms_lob.instr(p_document,INPUT_TAG,1,1);
893: while l_start_index <> 0 loop
894: l_end_index := dbms_lob.instr(p_document,END_TAG,l_start_index+length(INPUT_TAG),1);
895: l_amount := l_end_index-l_start_index+1;
896: dbms_lob.erase(p_document,l_amount,l_start_index);
897: l_start_index := dbms_lob.instr(p_document,INPUT_TAG,l_end_index,1);
898: end loop;
899: pa_debug.reset_err_stack;
900:

Line 897: l_start_index := dbms_lob.instr(p_document,INPUT_TAG,l_end_index,1);

893: while l_start_index <> 0 loop
894: l_end_index := dbms_lob.instr(p_document,END_TAG,l_start_index+length(INPUT_TAG),1);
895: l_amount := l_end_index-l_start_index+1;
896: dbms_lob.erase(p_document,l_amount,l_start_index);
897: l_start_index := dbms_lob.instr(p_document,INPUT_TAG,l_end_index,1);
898: end loop;
899: pa_debug.reset_err_stack;
900:
901: IF P_PA_DEBUG_MODE = 'Y' Then