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

Line 986: if (DBMS_LOB.isOpen(lob_loc) = 1) then

982: PROCEDURE CLOSE_LOB(lob_loc IN OUT NOCOPY CLOB)
983: IS
984: BEGIN
985:
986: if (DBMS_LOB.isOpen(lob_loc) = 1) then
987: DBMS_LOB.Close(lob_loc);
988: end if;
989: if (dbms_lob.isTemporary(lob_loc)=1) then
990: DBMS_LOB.freeTemporary(lob_loc);

Line 987: DBMS_LOB.Close(lob_loc);

983: IS
984: BEGIN
985:
986: if (DBMS_LOB.isOpen(lob_loc) = 1) then
987: DBMS_LOB.Close(lob_loc);
988: end if;
989: if (dbms_lob.isTemporary(lob_loc)=1) then
990: DBMS_LOB.freeTemporary(lob_loc);
991: end if;

Line 989: if (dbms_lob.isTemporary(lob_loc)=1) then

985:
986: if (DBMS_LOB.isOpen(lob_loc) = 1) then
987: DBMS_LOB.Close(lob_loc);
988: end if;
989: if (dbms_lob.isTemporary(lob_loc)=1) then
990: DBMS_LOB.freeTemporary(lob_loc);
991: end if;
992:
993: END CLOSE_LOB ;

Line 990: DBMS_LOB.freeTemporary(lob_loc);

986: if (DBMS_LOB.isOpen(lob_loc) = 1) then
987: DBMS_LOB.Close(lob_loc);
988: end if;
989: if (dbms_lob.isTemporary(lob_loc)=1) then
990: DBMS_LOB.freeTemporary(lob_loc);
991: end if;
992:
993: END CLOSE_LOB ;
994:

Line 1097: DBMS_LOB.createtemporary(x_Complete_query,true);

1093: FETCH c_set_user_queries INTO l_set_query;
1094: exit when c_set_user_queries%NOTFOUND;
1095: if x_Complete_query is null
1096: then
1097: DBMS_LOB.createtemporary(x_Complete_query,true);
1098: DBMS_LOB.Trim ( lob_loc => x_Complete_query,newlen => 0 );
1099: DBMS_LOB.Write ( lob_loc => x_Complete_query
1100: , amount => Length (l_set_query)
1101: , offset => l_offset

Line 1098: DBMS_LOB.Trim ( lob_loc => x_Complete_query,newlen => 0 );

1094: exit when c_set_user_queries%NOTFOUND;
1095: if x_Complete_query is null
1096: then
1097: DBMS_LOB.createtemporary(x_Complete_query,true);
1098: DBMS_LOB.Trim ( lob_loc => x_Complete_query,newlen => 0 );
1099: DBMS_LOB.Write ( lob_loc => x_Complete_query
1100: , amount => Length (l_set_query)
1101: , offset => l_offset
1102: , buffer => l_set_query

Line 1099: DBMS_LOB.Write ( lob_loc => x_Complete_query

1095: if x_Complete_query is null
1096: then
1097: DBMS_LOB.createtemporary(x_Complete_query,true);
1098: DBMS_LOB.Trim ( lob_loc => x_Complete_query,newlen => 0 );
1099: DBMS_LOB.Write ( lob_loc => x_Complete_query
1100: , amount => Length (l_set_query)
1101: , offset => l_offset
1102: , buffer => l_set_query
1103: );

Line 1107: DBMS_LOB.WriteAppend ( lob_loc => x_Complete_query

1103: );
1104: -- insert into abc_table values('here in the null part');
1105: else
1106: l_set_query :=' UNION ALL ' || l_set_query;
1107: DBMS_LOB.WriteAppend ( lob_loc => x_Complete_query
1108: , amount => Length (l_set_query)
1109: , buffer => l_set_query
1110: );
1111: -- insert into abc_table values('here in the not null');

Line 1137: DBMS_LOB.createtemporary(x_Complete_query,true);

1133: FETCH c_set_group_queries INTO l_set_query;
1134: exit when c_set_group_queries%NOTFOUND;
1135: if x_Complete_query is null
1136: then
1137: DBMS_LOB.createtemporary(x_Complete_query,true);
1138: DBMS_LOB.Trim ( lob_loc => x_Complete_query,newlen => 0 );
1139: DBMS_LOB.Write ( lob_loc => x_Complete_query
1140: , amount => Length (l_set_query)
1141: , offset => l_offset

Line 1138: DBMS_LOB.Trim ( lob_loc => x_Complete_query,newlen => 0 );

1134: exit when c_set_group_queries%NOTFOUND;
1135: if x_Complete_query is null
1136: then
1137: DBMS_LOB.createtemporary(x_Complete_query,true);
1138: DBMS_LOB.Trim ( lob_loc => x_Complete_query,newlen => 0 );
1139: DBMS_LOB.Write ( lob_loc => x_Complete_query
1140: , amount => Length (l_set_query)
1141: , offset => l_offset
1142: , buffer => l_set_query

Line 1139: DBMS_LOB.Write ( lob_loc => x_Complete_query

1135: if x_Complete_query is null
1136: then
1137: DBMS_LOB.createtemporary(x_Complete_query,true);
1138: DBMS_LOB.Trim ( lob_loc => x_Complete_query,newlen => 0 );
1139: DBMS_LOB.Write ( lob_loc => x_Complete_query
1140: , amount => Length (l_set_query)
1141: , offset => l_offset
1142: , buffer => l_set_query
1143: );

Line 1150: DBMS_LOB.WriteAppend ( lob_loc => x_Complete_query

1146:
1147: else
1148: l_set_query :=' UNION ALL ' || l_set_query;
1149:
1150: DBMS_LOB.WriteAppend ( lob_loc => x_Complete_query
1151: , amount => Length (l_set_query)
1152: , buffer => l_set_query
1153: );
1154:

Line 1167: --DBMS_LOB.read(lob_loc => x_Complete_query,amount => l_amount ,offset => l_offset,buffer => text);

1163: end if;
1164: *********************************************************************/
1165:
1166: --Append_VARCHAR_to_LOB(x_Complete_query,' ' ,'END');
1167: --DBMS_LOB.read(lob_loc => x_Complete_query,amount => l_amount ,offset => l_offset,buffer => text);
1168:
1169: --DBMS_OUTPUT.put_line(' Aman == > ' ||' ' ||text);
1170:
1171:

Line 1175: if (DBMS_LOB.isOpen(x_Complete_query) = 1) then

1171:
1172: EXCEPTION
1173: WHEN OTHERS THEN
1174: -- closing and freeing the temp lob
1175: if (DBMS_LOB.isOpen(x_Complete_query) = 1) then
1176: DBMS_LOB.Close(x_Complete_query);
1177: end if;
1178:
1179: if (dbms_lob.isTemporary(x_Complete_query)=1) then

Line 1176: DBMS_LOB.Close(x_Complete_query);

1172: EXCEPTION
1173: WHEN OTHERS THEN
1174: -- closing and freeing the temp lob
1175: if (DBMS_LOB.isOpen(x_Complete_query) = 1) then
1176: DBMS_LOB.Close(x_Complete_query);
1177: end if;
1178:
1179: if (dbms_lob.isTemporary(x_Complete_query)=1) then
1180: DBMS_LOB.freeTemporary(x_Complete_query);

Line 1179: if (dbms_lob.isTemporary(x_Complete_query)=1) then

1175: if (DBMS_LOB.isOpen(x_Complete_query) = 1) then
1176: DBMS_LOB.Close(x_Complete_query);
1177: end if;
1178:
1179: if (dbms_lob.isTemporary(x_Complete_query)=1) then
1180: DBMS_LOB.freeTemporary(x_Complete_query);
1181: end if;
1182:
1183: RAISE ;

Line 1180: DBMS_LOB.freeTemporary(x_Complete_query);

1176: DBMS_LOB.Close(x_Complete_query);
1177: end if;
1178:
1179: if (dbms_lob.isTemporary(x_Complete_query)=1) then
1180: DBMS_LOB.freeTemporary(x_Complete_query);
1181: end if;
1182:
1183: RAISE ;
1184: