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.XDP_PROC_CTL dependencies on DBMS_SQL

Line 1113: l_cursorID := DBMS_SQL.OPEN_CURSOR;

1109: begin
1110: ErrCode := 0;
1111: ErrStr := null;
1112:
1113: l_cursorID := DBMS_SQL.OPEN_CURSOR;
1114:
1115:
1116: l_temp_str := ProcStr;
1117:

Line 1225: DBMS_SQL.PARSE(l_cursorID, l_final_str, DBMS_SQL.V7);

1221:
1222: /*
1223: * Parse the string for any errors. This is the dynamic generation of the procedure
1224: */
1225: DBMS_SQL.PARSE(l_cursorID, l_final_str, DBMS_SQL.V7);
1226:
1227: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
1228: COMMIT;
1229: ErrCode := 0;

Line 1227: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

1223: * Parse the string for any errors. This is the dynamic generation of the procedure
1224: */
1225: DBMS_SQL.PARSE(l_cursorID, l_final_str, DBMS_SQL.V7);
1226:
1227: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
1228: COMMIT;
1229: ErrCode := 0;
1230: ErrStr := 'Successfully generated the stored procedure ' || ProcName;
1231:

Line 1236: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

1232: exception
1233: when others then
1234: ErrCode := SQLCODE;
1235: ErrStr := 'Unhandeled Exception in XDP_PROC_CTL.GENERATE_PROC. Procedure to be generated: ' || ProcName || ' Error: ' || SUBSTR(SQLERRM,1,200);
1236: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
1237: end GENERATE_PROC;
1238:
1239:
1240: