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

Line 9161: lcursor := dbms_sql.open_cursor;

9157: IF PG_DEBUG <> 0 THEN
9158: oe_debug_pub.add( 'Check_dup_item: '||'sql_str : '||sql_str, 3);
9159: END IF;
9160:
9161: lcursor := dbms_sql.open_cursor;
9162:
9163: dbms_sql.parse(lcursor, sql_str, dbms_sql.native);
9164:
9165: if pSegment1 is not null then

Line 9163: dbms_sql.parse(lcursor, sql_str, dbms_sql.native);

9159: END IF;
9160:
9161: lcursor := dbms_sql.open_cursor;
9162:
9163: dbms_sql.parse(lcursor, sql_str, dbms_sql.native);
9164:
9165: if pSegment1 is not null then
9166: dbms_sql.bind_variable(lcursor,'pSegment1', pSegment1);
9167: end if;

Line 9166: dbms_sql.bind_variable(lcursor,'pSegment1', pSegment1);

9162:
9163: dbms_sql.parse(lcursor, sql_str, dbms_sql.native);
9164:
9165: if pSegment1 is not null then
9166: dbms_sql.bind_variable(lcursor,'pSegment1', pSegment1);
9167: end if;
9168: if pSegment2 is not null then
9169: dbms_sql.bind_variable(lcursor,'pSegment2', pSegment2);
9170: end if;

Line 9169: dbms_sql.bind_variable(lcursor,'pSegment2', pSegment2);

9165: if pSegment1 is not null then
9166: dbms_sql.bind_variable(lcursor,'pSegment1', pSegment1);
9167: end if;
9168: if pSegment2 is not null then
9169: dbms_sql.bind_variable(lcursor,'pSegment2', pSegment2);
9170: end if;
9171: if pSegment3 is not null then
9172: dbms_sql.bind_variable(lcursor,'pSegment3', pSegment3);
9173: end if;

Line 9172: dbms_sql.bind_variable(lcursor,'pSegment3', pSegment3);

9168: if pSegment2 is not null then
9169: dbms_sql.bind_variable(lcursor,'pSegment2', pSegment2);
9170: end if;
9171: if pSegment3 is not null then
9172: dbms_sql.bind_variable(lcursor,'pSegment3', pSegment3);
9173: end if;
9174: if pSegment4 is not null then
9175: dbms_sql.bind_variable(lcursor,'pSegment4', pSegment4);
9176: end if;

Line 9175: dbms_sql.bind_variable(lcursor,'pSegment4', pSegment4);

9171: if pSegment3 is not null then
9172: dbms_sql.bind_variable(lcursor,'pSegment3', pSegment3);
9173: end if;
9174: if pSegment4 is not null then
9175: dbms_sql.bind_variable(lcursor,'pSegment4', pSegment4);
9176: end if;
9177: if pSegment5 is not null then
9178: dbms_sql.bind_variable(lcursor,'pSegment5', pSegment5);
9179: end if;

Line 9178: dbms_sql.bind_variable(lcursor,'pSegment5', pSegment5);

9174: if pSegment4 is not null then
9175: dbms_sql.bind_variable(lcursor,'pSegment4', pSegment4);
9176: end if;
9177: if pSegment5 is not null then
9178: dbms_sql.bind_variable(lcursor,'pSegment5', pSegment5);
9179: end if;
9180: if pSegment6 is not null then
9181: dbms_sql.bind_variable(lcursor,'pSegment6', pSegment6);
9182: end if;

Line 9181: dbms_sql.bind_variable(lcursor,'pSegment6', pSegment6);

9177: if pSegment5 is not null then
9178: dbms_sql.bind_variable(lcursor,'pSegment5', pSegment5);
9179: end if;
9180: if pSegment6 is not null then
9181: dbms_sql.bind_variable(lcursor,'pSegment6', pSegment6);
9182: end if;
9183: if pSegment7 is not null then
9184: dbms_sql.bind_variable(lcursor,'pSegment7', pSegment7);
9185: end if;

Line 9184: dbms_sql.bind_variable(lcursor,'pSegment7', pSegment7);

9180: if pSegment6 is not null then
9181: dbms_sql.bind_variable(lcursor,'pSegment6', pSegment6);
9182: end if;
9183: if pSegment7 is not null then
9184: dbms_sql.bind_variable(lcursor,'pSegment7', pSegment7);
9185: end if;
9186: if pSegment8 is not null then
9187: dbms_sql.bind_variable(lcursor,'pSegment8', pSegment8);
9188: end if;

Line 9187: dbms_sql.bind_variable(lcursor,'pSegment8', pSegment8);

9183: if pSegment7 is not null then
9184: dbms_sql.bind_variable(lcursor,'pSegment7', pSegment7);
9185: end if;
9186: if pSegment8 is not null then
9187: dbms_sql.bind_variable(lcursor,'pSegment8', pSegment8);
9188: end if;
9189: if pSegment9 is not null then
9190: dbms_sql.bind_variable(lcursor,'pSegment9', pSegment9);
9191: end if;

Line 9190: dbms_sql.bind_variable(lcursor,'pSegment9', pSegment9);

9186: if pSegment8 is not null then
9187: dbms_sql.bind_variable(lcursor,'pSegment8', pSegment8);
9188: end if;
9189: if pSegment9 is not null then
9190: dbms_sql.bind_variable(lcursor,'pSegment9', pSegment9);
9191: end if;
9192: if pSegment10 is not null then
9193: dbms_sql.bind_variable(lcursor,'pSegment10', pSegment10);
9194: end if;

Line 9193: dbms_sql.bind_variable(lcursor,'pSegment10', pSegment10);

9189: if pSegment9 is not null then
9190: dbms_sql.bind_variable(lcursor,'pSegment9', pSegment9);
9191: end if;
9192: if pSegment10 is not null then
9193: dbms_sql.bind_variable(lcursor,'pSegment10', pSegment10);
9194: end if;
9195: if pSegment11 is not null then
9196: dbms_sql.bind_variable(lcursor,'pSegment11', pSegment11);
9197: end if;

Line 9196: dbms_sql.bind_variable(lcursor,'pSegment11', pSegment11);

9192: if pSegment10 is not null then
9193: dbms_sql.bind_variable(lcursor,'pSegment10', pSegment10);
9194: end if;
9195: if pSegment11 is not null then
9196: dbms_sql.bind_variable(lcursor,'pSegment11', pSegment11);
9197: end if;
9198: if pSegment12 is not null then
9199: dbms_sql.bind_variable(lcursor,'pSegment12', pSegment12);
9200: end if;

Line 9199: dbms_sql.bind_variable(lcursor,'pSegment12', pSegment12);

9195: if pSegment11 is not null then
9196: dbms_sql.bind_variable(lcursor,'pSegment11', pSegment11);
9197: end if;
9198: if pSegment12 is not null then
9199: dbms_sql.bind_variable(lcursor,'pSegment12', pSegment12);
9200: end if;
9201: if pSegment13 is not null then
9202: dbms_sql.bind_variable(lcursor,'pSegment13', pSegment13);
9203: end if;

Line 9202: dbms_sql.bind_variable(lcursor,'pSegment13', pSegment13);

9198: if pSegment12 is not null then
9199: dbms_sql.bind_variable(lcursor,'pSegment12', pSegment12);
9200: end if;
9201: if pSegment13 is not null then
9202: dbms_sql.bind_variable(lcursor,'pSegment13', pSegment13);
9203: end if;
9204: if pSegment14 is not null then
9205: dbms_sql.bind_variable(lcursor,'pSegment14', pSegment14);
9206: end if;

Line 9205: dbms_sql.bind_variable(lcursor,'pSegment14', pSegment14);

9201: if pSegment13 is not null then
9202: dbms_sql.bind_variable(lcursor,'pSegment13', pSegment13);
9203: end if;
9204: if pSegment14 is not null then
9205: dbms_sql.bind_variable(lcursor,'pSegment14', pSegment14);
9206: end if;
9207: if pSegment15 is not null then
9208: dbms_sql.bind_variable(lcursor,'pSegment15', pSegment15);
9209: end if;

Line 9208: dbms_sql.bind_variable(lcursor,'pSegment15', pSegment15);

9204: if pSegment14 is not null then
9205: dbms_sql.bind_variable(lcursor,'pSegment14', pSegment14);
9206: end if;
9207: if pSegment15 is not null then
9208: dbms_sql.bind_variable(lcursor,'pSegment15', pSegment15);
9209: end if;
9210: if pSegment16 is not null then
9211: dbms_sql.bind_variable(lcursor,'pSegment16', pSegment16);
9212: end if;

Line 9211: dbms_sql.bind_variable(lcursor,'pSegment16', pSegment16);

9207: if pSegment15 is not null then
9208: dbms_sql.bind_variable(lcursor,'pSegment15', pSegment15);
9209: end if;
9210: if pSegment16 is not null then
9211: dbms_sql.bind_variable(lcursor,'pSegment16', pSegment16);
9212: end if;
9213: if pSegment17 is not null then
9214: dbms_sql.bind_variable(lcursor,'pSegment17', pSegment17);
9215: end if;

Line 9214: dbms_sql.bind_variable(lcursor,'pSegment17', pSegment17);

9210: if pSegment16 is not null then
9211: dbms_sql.bind_variable(lcursor,'pSegment16', pSegment16);
9212: end if;
9213: if pSegment17 is not null then
9214: dbms_sql.bind_variable(lcursor,'pSegment17', pSegment17);
9215: end if;
9216: if pSegment18 is not null then
9217: dbms_sql.bind_variable(lcursor,'pSegment18', pSegment18);
9218: end if;

Line 9217: dbms_sql.bind_variable(lcursor,'pSegment18', pSegment18);

9213: if pSegment17 is not null then
9214: dbms_sql.bind_variable(lcursor,'pSegment17', pSegment17);
9215: end if;
9216: if pSegment18 is not null then
9217: dbms_sql.bind_variable(lcursor,'pSegment18', pSegment18);
9218: end if;
9219: if pSegment19 is not null then
9220: dbms_sql.bind_variable(lcursor,'pSegment19', pSegment19);
9221: end if;

Line 9220: dbms_sql.bind_variable(lcursor,'pSegment19', pSegment19);

9216: if pSegment18 is not null then
9217: dbms_sql.bind_variable(lcursor,'pSegment18', pSegment18);
9218: end if;
9219: if pSegment19 is not null then
9220: dbms_sql.bind_variable(lcursor,'pSegment19', pSegment19);
9221: end if;
9222: if pSegment20 is not null then
9223: dbms_sql.bind_variable(lcursor,'pSegment20', pSegment20);
9224: end if;

Line 9223: dbms_sql.bind_variable(lcursor,'pSegment20', pSegment20);

9219: if pSegment19 is not null then
9220: dbms_sql.bind_variable(lcursor,'pSegment19', pSegment19);
9221: end if;
9222: if pSegment20 is not null then
9223: dbms_sql.bind_variable(lcursor,'pSegment20', pSegment20);
9224: end if;
9225:
9226: dbms_sql.define_column(lcursor, 1, xdummy);
9227:

Line 9226: dbms_sql.define_column(lcursor, 1, xdummy);

9222: if pSegment20 is not null then
9223: dbms_sql.bind_variable(lcursor,'pSegment20', pSegment20);
9224: end if;
9225:
9226: dbms_sql.define_column(lcursor, 1, xdummy);
9227:
9228: rows_processed := dbms_sql.execute_and_fetch(lcursor);
9229:
9230: dbms_sql.close_cursor(lcursor);

Line 9228: rows_processed := dbms_sql.execute_and_fetch(lcursor);

9224: end if;
9225:
9226: dbms_sql.define_column(lcursor, 1, xdummy);
9227:
9228: rows_processed := dbms_sql.execute_and_fetch(lcursor);
9229:
9230: dbms_sql.close_cursor(lcursor);
9231:
9232: if rows_processed > 0 then

Line 9230: dbms_sql.close_cursor(lcursor);

9226: dbms_sql.define_column(lcursor, 1, xdummy);
9227:
9228: rows_processed := dbms_sql.execute_and_fetch(lcursor);
9229:
9230: dbms_sql.close_cursor(lcursor);
9231:
9232: if rows_processed > 0 then
9233: IF PG_DEBUG <> 0 THEN
9234: oe_debug_pub.add( 'Check_dup_item: '||'Duplicate item name found.');