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 8860: lcursor := dbms_sql.open_cursor;

8856: IF PG_DEBUG <> 0 THEN
8857: oe_debug_pub.add( 'Check_dup_item: '||'sql_str : '||sql_str, 3);
8858: END IF;
8859:
8860: lcursor := dbms_sql.open_cursor;
8861:
8862: dbms_sql.parse(lcursor, sql_str, dbms_sql.native);
8863:
8864: if pSegment1 is not null then

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

8858: END IF;
8859:
8860: lcursor := dbms_sql.open_cursor;
8861:
8862: dbms_sql.parse(lcursor, sql_str, dbms_sql.native);
8863:
8864: if pSegment1 is not null then
8865: dbms_sql.bind_variable(lcursor,'pSegment1', pSegment1);
8866: end if;

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

8861:
8862: dbms_sql.parse(lcursor, sql_str, dbms_sql.native);
8863:
8864: if pSegment1 is not null then
8865: dbms_sql.bind_variable(lcursor,'pSegment1', pSegment1);
8866: end if;
8867: if pSegment2 is not null then
8868: dbms_sql.bind_variable(lcursor,'pSegment2', pSegment2);
8869: end if;

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

8864: if pSegment1 is not null then
8865: dbms_sql.bind_variable(lcursor,'pSegment1', pSegment1);
8866: end if;
8867: if pSegment2 is not null then
8868: dbms_sql.bind_variable(lcursor,'pSegment2', pSegment2);
8869: end if;
8870: if pSegment3 is not null then
8871: dbms_sql.bind_variable(lcursor,'pSegment3', pSegment3);
8872: end if;

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

8867: if pSegment2 is not null then
8868: dbms_sql.bind_variable(lcursor,'pSegment2', pSegment2);
8869: end if;
8870: if pSegment3 is not null then
8871: dbms_sql.bind_variable(lcursor,'pSegment3', pSegment3);
8872: end if;
8873: if pSegment4 is not null then
8874: dbms_sql.bind_variable(lcursor,'pSegment4', pSegment4);
8875: end if;

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

8870: if pSegment3 is not null then
8871: dbms_sql.bind_variable(lcursor,'pSegment3', pSegment3);
8872: end if;
8873: if pSegment4 is not null then
8874: dbms_sql.bind_variable(lcursor,'pSegment4', pSegment4);
8875: end if;
8876: if pSegment5 is not null then
8877: dbms_sql.bind_variable(lcursor,'pSegment5', pSegment5);
8878: end if;

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

8873: if pSegment4 is not null then
8874: dbms_sql.bind_variable(lcursor,'pSegment4', pSegment4);
8875: end if;
8876: if pSegment5 is not null then
8877: dbms_sql.bind_variable(lcursor,'pSegment5', pSegment5);
8878: end if;
8879: if pSegment6 is not null then
8880: dbms_sql.bind_variable(lcursor,'pSegment6', pSegment6);
8881: end if;

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

8876: if pSegment5 is not null then
8877: dbms_sql.bind_variable(lcursor,'pSegment5', pSegment5);
8878: end if;
8879: if pSegment6 is not null then
8880: dbms_sql.bind_variable(lcursor,'pSegment6', pSegment6);
8881: end if;
8882: if pSegment7 is not null then
8883: dbms_sql.bind_variable(lcursor,'pSegment7', pSegment7);
8884: end if;

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

8879: if pSegment6 is not null then
8880: dbms_sql.bind_variable(lcursor,'pSegment6', pSegment6);
8881: end if;
8882: if pSegment7 is not null then
8883: dbms_sql.bind_variable(lcursor,'pSegment7', pSegment7);
8884: end if;
8885: if pSegment8 is not null then
8886: dbms_sql.bind_variable(lcursor,'pSegment8', pSegment8);
8887: end if;

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

8882: if pSegment7 is not null then
8883: dbms_sql.bind_variable(lcursor,'pSegment7', pSegment7);
8884: end if;
8885: if pSegment8 is not null then
8886: dbms_sql.bind_variable(lcursor,'pSegment8', pSegment8);
8887: end if;
8888: if pSegment9 is not null then
8889: dbms_sql.bind_variable(lcursor,'pSegment9', pSegment9);
8890: end if;

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

8885: if pSegment8 is not null then
8886: dbms_sql.bind_variable(lcursor,'pSegment8', pSegment8);
8887: end if;
8888: if pSegment9 is not null then
8889: dbms_sql.bind_variable(lcursor,'pSegment9', pSegment9);
8890: end if;
8891: if pSegment10 is not null then
8892: dbms_sql.bind_variable(lcursor,'pSegment10', pSegment10);
8893: end if;

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

8888: if pSegment9 is not null then
8889: dbms_sql.bind_variable(lcursor,'pSegment9', pSegment9);
8890: end if;
8891: if pSegment10 is not null then
8892: dbms_sql.bind_variable(lcursor,'pSegment10', pSegment10);
8893: end if;
8894: if pSegment11 is not null then
8895: dbms_sql.bind_variable(lcursor,'pSegment11', pSegment11);
8896: end if;

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

8891: if pSegment10 is not null then
8892: dbms_sql.bind_variable(lcursor,'pSegment10', pSegment10);
8893: end if;
8894: if pSegment11 is not null then
8895: dbms_sql.bind_variable(lcursor,'pSegment11', pSegment11);
8896: end if;
8897: if pSegment12 is not null then
8898: dbms_sql.bind_variable(lcursor,'pSegment12', pSegment12);
8899: end if;

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

8894: if pSegment11 is not null then
8895: dbms_sql.bind_variable(lcursor,'pSegment11', pSegment11);
8896: end if;
8897: if pSegment12 is not null then
8898: dbms_sql.bind_variable(lcursor,'pSegment12', pSegment12);
8899: end if;
8900: if pSegment13 is not null then
8901: dbms_sql.bind_variable(lcursor,'pSegment13', pSegment13);
8902: end if;

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

8897: if pSegment12 is not null then
8898: dbms_sql.bind_variable(lcursor,'pSegment12', pSegment12);
8899: end if;
8900: if pSegment13 is not null then
8901: dbms_sql.bind_variable(lcursor,'pSegment13', pSegment13);
8902: end if;
8903: if pSegment14 is not null then
8904: dbms_sql.bind_variable(lcursor,'pSegment14', pSegment14);
8905: end if;

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

8900: if pSegment13 is not null then
8901: dbms_sql.bind_variable(lcursor,'pSegment13', pSegment13);
8902: end if;
8903: if pSegment14 is not null then
8904: dbms_sql.bind_variable(lcursor,'pSegment14', pSegment14);
8905: end if;
8906: if pSegment15 is not null then
8907: dbms_sql.bind_variable(lcursor,'pSegment15', pSegment15);
8908: end if;

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

8903: if pSegment14 is not null then
8904: dbms_sql.bind_variable(lcursor,'pSegment14', pSegment14);
8905: end if;
8906: if pSegment15 is not null then
8907: dbms_sql.bind_variable(lcursor,'pSegment15', pSegment15);
8908: end if;
8909: if pSegment16 is not null then
8910: dbms_sql.bind_variable(lcursor,'pSegment16', pSegment16);
8911: end if;

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

8906: if pSegment15 is not null then
8907: dbms_sql.bind_variable(lcursor,'pSegment15', pSegment15);
8908: end if;
8909: if pSegment16 is not null then
8910: dbms_sql.bind_variable(lcursor,'pSegment16', pSegment16);
8911: end if;
8912: if pSegment17 is not null then
8913: dbms_sql.bind_variable(lcursor,'pSegment17', pSegment17);
8914: end if;

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

8909: if pSegment16 is not null then
8910: dbms_sql.bind_variable(lcursor,'pSegment16', pSegment16);
8911: end if;
8912: if pSegment17 is not null then
8913: dbms_sql.bind_variable(lcursor,'pSegment17', pSegment17);
8914: end if;
8915: if pSegment18 is not null then
8916: dbms_sql.bind_variable(lcursor,'pSegment18', pSegment18);
8917: end if;

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

8912: if pSegment17 is not null then
8913: dbms_sql.bind_variable(lcursor,'pSegment17', pSegment17);
8914: end if;
8915: if pSegment18 is not null then
8916: dbms_sql.bind_variable(lcursor,'pSegment18', pSegment18);
8917: end if;
8918: if pSegment19 is not null then
8919: dbms_sql.bind_variable(lcursor,'pSegment19', pSegment19);
8920: end if;

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

8915: if pSegment18 is not null then
8916: dbms_sql.bind_variable(lcursor,'pSegment18', pSegment18);
8917: end if;
8918: if pSegment19 is not null then
8919: dbms_sql.bind_variable(lcursor,'pSegment19', pSegment19);
8920: end if;
8921: if pSegment20 is not null then
8922: dbms_sql.bind_variable(lcursor,'pSegment20', pSegment20);
8923: end if;

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

8918: if pSegment19 is not null then
8919: dbms_sql.bind_variable(lcursor,'pSegment19', pSegment19);
8920: end if;
8921: if pSegment20 is not null then
8922: dbms_sql.bind_variable(lcursor,'pSegment20', pSegment20);
8923: end if;
8924:
8925: dbms_sql.define_column(lcursor, 1, xdummy);
8926:

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

8921: if pSegment20 is not null then
8922: dbms_sql.bind_variable(lcursor,'pSegment20', pSegment20);
8923: end if;
8924:
8925: dbms_sql.define_column(lcursor, 1, xdummy);
8926:
8927: rows_processed := dbms_sql.execute_and_fetch(lcursor);
8928:
8929: dbms_sql.close_cursor(lcursor);

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

8923: end if;
8924:
8925: dbms_sql.define_column(lcursor, 1, xdummy);
8926:
8927: rows_processed := dbms_sql.execute_and_fetch(lcursor);
8928:
8929: dbms_sql.close_cursor(lcursor);
8930:
8931: if rows_processed > 0 then

Line 8929: dbms_sql.close_cursor(lcursor);

8925: dbms_sql.define_column(lcursor, 1, xdummy);
8926:
8927: rows_processed := dbms_sql.execute_and_fetch(lcursor);
8928:
8929: dbms_sql.close_cursor(lcursor);
8930:
8931: if rows_processed > 0 then
8932: IF PG_DEBUG <> 0 THEN
8933: oe_debug_pub.add( 'Check_dup_item: '||'Duplicate item name found.');