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

Line 1064: l_cursorid := DBMS_SQL.open_cursor;

1060: || l_dsql
1061: || ' )';
1062:
1063: --open database cursor
1064: l_cursorid := DBMS_SQL.open_cursor;
1065: --parse and execute the sql
1066: DBMS_SQL.parse(l_cursorid, l_dsql, DBMS_SQL.v7);
1067: l_result := DBMS_SQL.execute(l_cursorid);
1068: DBMS_SQL.close_cursor (l_cursorid);

Line 1066: DBMS_SQL.parse(l_cursorid, l_dsql, DBMS_SQL.v7);

1062:
1063: --open database cursor
1064: l_cursorid := DBMS_SQL.open_cursor;
1065: --parse and execute the sql
1066: DBMS_SQL.parse(l_cursorid, l_dsql, DBMS_SQL.v7);
1067: l_result := DBMS_SQL.execute(l_cursorid);
1068: DBMS_SQL.close_cursor (l_cursorid);
1069:
1070: END IF; --END l_primary_key_value IS NULL (for delete case)

Line 1067: l_result := DBMS_SQL.execute(l_cursorid);

1063: --open database cursor
1064: l_cursorid := DBMS_SQL.open_cursor;
1065: --parse and execute the sql
1066: DBMS_SQL.parse(l_cursorid, l_dsql, DBMS_SQL.v7);
1067: l_result := DBMS_SQL.execute(l_cursorid);
1068: DBMS_SQL.close_cursor (l_cursorid);
1069:
1070: END IF; --END l_primary_key_value IS NULL (for delete case)
1071:

Line 1068: DBMS_SQL.close_cursor (l_cursorid);

1064: l_cursorid := DBMS_SQL.open_cursor;
1065: --parse and execute the sql
1066: DBMS_SQL.parse(l_cursorid, l_dsql, DBMS_SQL.v7);
1067: l_result := DBMS_SQL.execute(l_cursorid);
1068: DBMS_SQL.close_cursor (l_cursorid);
1069:
1070: END IF; --END l_primary_key_value IS NULL (for delete case)
1071:
1072: /********** END DELETES **************/

Line 1135: l_cursorid := DBMS_SQL.open_cursor;

1131: || '), LAST_UPDATED_BY = fnd_global.user_id WHERE '
1132: || ' access_id = ' || l_access_id;
1133:
1134: --open database cursor
1135: l_cursorid := DBMS_SQL.open_cursor;
1136: --parse and execute the sql
1137: DBMS_SQL.parse(l_cursorid, l_upd_dsql, DBMS_SQL.v7);
1138: l_result := DBMS_SQL.execute(l_cursorid);
1139: DBMS_SQL.close_cursor (l_cursorid);

Line 1137: DBMS_SQL.parse(l_cursorid, l_upd_dsql, DBMS_SQL.v7);

1133:
1134: --open database cursor
1135: l_cursorid := DBMS_SQL.open_cursor;
1136: --parse and execute the sql
1137: DBMS_SQL.parse(l_cursorid, l_upd_dsql, DBMS_SQL.v7);
1138: l_result := DBMS_SQL.execute(l_cursorid);
1139: DBMS_SQL.close_cursor (l_cursorid);
1140:
1141: END LOOP;

Line 1138: l_result := DBMS_SQL.execute(l_cursorid);

1134: --open database cursor
1135: l_cursorid := DBMS_SQL.open_cursor;
1136: --parse and execute the sql
1137: DBMS_SQL.parse(l_cursorid, l_upd_dsql, DBMS_SQL.v7);
1138: l_result := DBMS_SQL.execute(l_cursorid);
1139: DBMS_SQL.close_cursor (l_cursorid);
1140:
1141: END LOOP;
1142: -- END Updates to non TL table

Line 1139: DBMS_SQL.close_cursor (l_cursorid);

1135: l_cursorid := DBMS_SQL.open_cursor;
1136: --parse and execute the sql
1137: DBMS_SQL.parse(l_cursorid, l_upd_dsql, DBMS_SQL.v7);
1138: l_result := DBMS_SQL.execute(l_cursorid);
1139: DBMS_SQL.close_cursor (l_cursorid);
1140:
1141: END LOOP;
1142: -- END Updates to non TL table
1143:

Line 1202: l_cursorid := DBMS_SQL.open_cursor;

1198: || '), LAST_UPDATED_BY = fnd_global.user_id WHERE '
1199: || ' access_id = ' || l_access_id;
1200:
1201: --open database cursor
1202: l_cursorid := DBMS_SQL.open_cursor;
1203: --parse and execute the sql
1204: DBMS_SQL.parse(l_cursorid, l_upd_dsql, DBMS_SQL.v7);
1205: l_result := DBMS_SQL.execute(l_cursorid);
1206: DBMS_SQL.close_cursor (l_cursorid);

Line 1204: DBMS_SQL.parse(l_cursorid, l_upd_dsql, DBMS_SQL.v7);

1200:
1201: --open database cursor
1202: l_cursorid := DBMS_SQL.open_cursor;
1203: --parse and execute the sql
1204: DBMS_SQL.parse(l_cursorid, l_upd_dsql, DBMS_SQL.v7);
1205: l_result := DBMS_SQL.execute(l_cursorid);
1206: DBMS_SQL.close_cursor (l_cursorid);
1207:
1208: END LOOP;

Line 1205: l_result := DBMS_SQL.execute(l_cursorid);

1201: --open database cursor
1202: l_cursorid := DBMS_SQL.open_cursor;
1203: --parse and execute the sql
1204: DBMS_SQL.parse(l_cursorid, l_upd_dsql, DBMS_SQL.v7);
1205: l_result := DBMS_SQL.execute(l_cursorid);
1206: DBMS_SQL.close_cursor (l_cursorid);
1207:
1208: END LOOP;
1209:

Line 1206: DBMS_SQL.close_cursor (l_cursorid);

1202: l_cursorid := DBMS_SQL.open_cursor;
1203: --parse and execute the sql
1204: DBMS_SQL.parse(l_cursorid, l_upd_dsql, DBMS_SQL.v7);
1205: l_result := DBMS_SQL.execute(l_cursorid);
1206: DBMS_SQL.close_cursor (l_cursorid);
1207:
1208: END LOOP;
1209:
1210: END IF; --END IF l_tl_table_name is not null

Line 1306: l_cursorid := DBMS_SQL.open_cursor;

1302: || l_primary_key_value;
1303: END IF;
1304:
1305: --open database cursor
1306: l_cursorid := DBMS_SQL.open_cursor;
1307: --parse and execute the sql
1308: DBMS_SQL.parse(l_cursorid, l_dsql, DBMS_SQL.v7);
1309: l_result := DBMS_SQL.execute(l_cursorid);
1310: DBMS_SQL.close_cursor (l_cursorid);

Line 1308: DBMS_SQL.parse(l_cursorid, l_dsql, DBMS_SQL.v7);

1304:
1305: --open database cursor
1306: l_cursorid := DBMS_SQL.open_cursor;
1307: --parse and execute the sql
1308: DBMS_SQL.parse(l_cursorid, l_dsql, DBMS_SQL.v7);
1309: l_result := DBMS_SQL.execute(l_cursorid);
1310: DBMS_SQL.close_cursor (l_cursorid);
1311:
1312: /********** END INSERTS **************/

Line 1309: l_result := DBMS_SQL.execute(l_cursorid);

1305: --open database cursor
1306: l_cursorid := DBMS_SQL.open_cursor;
1307: --parse and execute the sql
1308: DBMS_SQL.parse(l_cursorid, l_dsql, DBMS_SQL.v7);
1309: l_result := DBMS_SQL.execute(l_cursorid);
1310: DBMS_SQL.close_cursor (l_cursorid);
1311:
1312: /********** END INSERTS **************/
1313:

Line 1310: DBMS_SQL.close_cursor (l_cursorid);

1306: l_cursorid := DBMS_SQL.open_cursor;
1307: --parse and execute the sql
1308: DBMS_SQL.parse(l_cursorid, l_dsql, DBMS_SQL.v7);
1309: l_result := DBMS_SQL.execute(l_cursorid);
1310: DBMS_SQL.close_cursor (l_cursorid);
1311:
1312: /********** END INSERTS **************/
1313:
1314: END LOOP;