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

Line 1569: v_cursor_id := DBMS_SQL.OPEN_CURSOR;

1565: );
1566: valueset_cur valueset_cur_type;
1567:
1568: BEGIN
1569: v_cursor_id := DBMS_SQL.OPEN_CURSOR;
1570: --Commented out for 2621644
1571: --IF (p_table_r.id_column_name IS NOT NULL) THEN -- Bug 1982009
1572:
1573: /* Added for 2492020 */

Line 1704: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

1700: open v_cursor for v_selectstmt using p_value;
1701: fetch v_cursor into valueset_cur;
1702: IF v_Cursor%NOTFOUND THEN
1703: CLOSE v_cursor;
1704: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1705: RETURN FALSE;
1706: END IF;
1707: x_id := valueset_cur.valueset_id;
1708: x_value := valueset_cur.valueset_value;

Line 1710: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

1706: END IF;
1707: x_id := valueset_cur.valueset_id;
1708: x_value := valueset_cur.valueset_value;
1709: CLOSE v_cursor;
1710: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1711: RETURN TRUE;
1712:
1713:
1714: /*

Line 1717: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);

1713:
1714: /*
1715: -- parse the query
1716:
1717: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
1718: oe_debug_pub.add('after parse1');
1719: -- Bind the input variables
1720: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
1721: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);

Line 1720: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);

1716:
1717: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
1718: oe_debug_pub.add('after parse1');
1719: -- Bind the input variables
1720: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
1721: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
1722: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);
1723: LOOP
1724: -- Fetch rows in to buffer and check the exit condition from the loop

Line 1721: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);

1717: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
1718: oe_debug_pub.add('after parse1');
1719: -- Bind the input variables
1720: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
1721: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
1722: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);
1723: LOOP
1724: -- Fetch rows in to buffer and check the exit condition from the loop
1725: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN

Line 1722: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);

1718: oe_debug_pub.add('after parse1');
1719: -- Bind the input variables
1720: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
1721: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
1722: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);
1723: LOOP
1724: -- Fetch rows in to buffer and check the exit condition from the loop
1725: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN
1726: EXIT;

Line 1725: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN

1721: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
1722: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);
1723: LOOP
1724: -- Fetch rows in to buffer and check the exit condition from the loop
1725: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN
1726: EXIT;
1727: END IF;
1728: -- Retrieve the rows from buffer into PLSQL variables
1729: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);

Line 1729: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);

1725: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN
1726: EXIT;
1727: END IF;
1728: -- Retrieve the rows from buffer into PLSQL variables
1729: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);
1730: DBMS_SQL.COLUMN_VALUE(v_cursor_id,2,v_id);
1731:
1732: IF v_id IS NULL AND (p_value = v_value) THEN
1733: oe_debug_pub.add('id null, passing value'||p_value||','||v_value);

Line 1730: DBMS_SQL.COLUMN_VALUE(v_cursor_id,2,v_id);

1726: EXIT;
1727: END IF;
1728: -- Retrieve the rows from buffer into PLSQL variables
1729: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);
1730: DBMS_SQL.COLUMN_VALUE(v_cursor_id,2,v_id);
1731:
1732: IF v_id IS NULL AND (p_value = v_value) THEN
1733: oe_debug_pub.add('id null, passing value'||p_value||','||v_value);
1734: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

Line 1734: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

1730: DBMS_SQL.COLUMN_VALUE(v_cursor_id,2,v_id);
1731:
1732: IF v_id IS NULL AND (p_value = v_value) THEN
1733: oe_debug_pub.add('id null, passing value'||p_value||','||v_value);
1734: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1735: x_id := v_id;
1736: x_value := v_value;
1737: RETURN TRUE;
1738: ELSIF (p_value = v_id) THEN

Line 1740: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

1736: x_value := v_value;
1737: RETURN TRUE;
1738: ELSIF (p_value = v_id) THEN
1739: oe_debug_pub.add('id exists, passing id'||p_value||','||v_id);
1740: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1741: x_id := v_id;
1742: x_value := v_value;
1743: RETURN TRUE;
1744: ELSE

Line 1749: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

1745: Null;
1746: oe_debug_pub.add('value does notmatch, continue search'||p_value||','||v_id);
1747: END IF;
1748: END LOOP;
1749: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1750: RETURN FALSE;
1751: */
1752: EXCEPTION
1753: WHEN OTHERS THEN

Line 1755: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

1751: */
1752: EXCEPTION
1753: WHEN OTHERS THEN
1754: oe_debug_pub.add('value_exists_in_table exception');
1755: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1756: RETURN FALSE;
1757: END value_exists_in_table;
1758:
1759: -- =============================================================================

Line 3738: v_cursor_id := DBMS_SQL.OPEN_CURSOR;

3734: valueset_cur valueset_cur_type;
3735:
3736:
3737: BEGIN
3738: v_cursor_id := DBMS_SQL.OPEN_CURSOR;
3739:
3740: --Commented out for 2621644
3741: --IF (p_table_r.id_column_name IS NOT NULL) THEN -- Bug 1982009
3742:

Line 3875: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

3871: open v_cursor for v_selectstmt using p_value;
3872: fetch v_cursor into valueset_cur;
3873: IF v_Cursor%NOTFOUND THEN
3874: CLOSE v_cursor;
3875: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
3876: RETURN FALSE;
3877: END IF;
3878: x_id := valueset_cur.valueset_id;
3879: x_value := valueset_cur.valueset_value;

Line 3886: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

3882: Else
3883: x_meaning:= valueset_cur.valueset_value;
3884: End If;
3885: CLOSE v_cursor;
3886: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
3887: RETURN TRUE;
3888:
3889: /*
3890: -- parse the query

Line 3892: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);

3888:
3889: /*
3890: -- parse the query
3891:
3892: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
3893: oe_debug_pub.add('after parse2');
3894: -- Bind the input variables
3895: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
3896: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);

Line 3895: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);

3891:
3892: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
3893: oe_debug_pub.add('after parse2');
3894: -- Bind the input variables
3895: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
3896: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
3897: if p_table_r.meaning_column_name IS NOT NULL THEN
3898: -- julin (2271729) - increased size for UTF8
3899: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,3,v_meaning,1000);

Line 3896: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);

3892: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
3893: oe_debug_pub.add('after parse2');
3894: -- Bind the input variables
3895: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
3896: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
3897: if p_table_r.meaning_column_name IS NOT NULL THEN
3898: -- julin (2271729) - increased size for UTF8
3899: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,3,v_meaning,1000);
3900: end if;

Line 3899: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,3,v_meaning,1000);

3895: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
3896: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
3897: if p_table_r.meaning_column_name IS NOT NULL THEN
3898: -- julin (2271729) - increased size for UTF8
3899: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,3,v_meaning,1000);
3900: end if;
3901: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);
3902: LOOP
3903: -- Fetch rows in to buffer and check the exit condition from the loop

Line 3901: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);

3897: if p_table_r.meaning_column_name IS NOT NULL THEN
3898: -- julin (2271729) - increased size for UTF8
3899: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,3,v_meaning,1000);
3900: end if;
3901: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);
3902: LOOP
3903: -- Fetch rows in to buffer and check the exit condition from the loop
3904: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN
3905: EXIT;

Line 3904: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN

3900: end if;
3901: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);
3902: LOOP
3903: -- Fetch rows in to buffer and check the exit condition from the loop
3904: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN
3905: EXIT;
3906: END IF;
3907: -- Retrieve the rows from buffer into PLSQL variables
3908: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);

Line 3908: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);

3904: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN
3905: EXIT;
3906: END IF;
3907: -- Retrieve the rows from buffer into PLSQL variables
3908: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);
3909: DBMS_SQL.COLUMN_VALUE(v_cursor_id,2,v_id);
3910: if p_table_r.meaning_column_name IS NOT NULL THEN
3911: DBMS_SQL.COLUMN_VALUE(v_cursor_id,3,v_meaning);
3912: end if;

Line 3909: DBMS_SQL.COLUMN_VALUE(v_cursor_id,2,v_id);

3905: EXIT;
3906: END IF;
3907: -- Retrieve the rows from buffer into PLSQL variables
3908: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);
3909: DBMS_SQL.COLUMN_VALUE(v_cursor_id,2,v_id);
3910: if p_table_r.meaning_column_name IS NOT NULL THEN
3911: DBMS_SQL.COLUMN_VALUE(v_cursor_id,3,v_meaning);
3912: end if;
3913:

Line 3911: DBMS_SQL.COLUMN_VALUE(v_cursor_id,3,v_meaning);

3907: -- Retrieve the rows from buffer into PLSQL variables
3908: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);
3909: DBMS_SQL.COLUMN_VALUE(v_cursor_id,2,v_id);
3910: if p_table_r.meaning_column_name IS NOT NULL THEN
3911: DBMS_SQL.COLUMN_VALUE(v_cursor_id,3,v_meaning);
3912: end if;
3913:
3914:
3915: IF v_id IS NULL AND (p_value = v_value) THEN

Line 3917: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

3913:
3914:
3915: IF v_id IS NULL AND (p_value = v_value) THEN
3916: oe_debug_pub.add('id null, passing value'||p_value||','||v_value||' '||v_meaning);
3917: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
3918: x_id := v_id;
3919: x_value := v_value;
3920: --added this to return meaning
3921: x_meaning := v_meaning;

Line 3925: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

3921: x_meaning := v_meaning;
3922: RETURN TRUE;
3923: ELSIF (p_value = v_id) THEN
3924: oe_debug_pub.add('id exists, passing id'||p_value||','||v_id||' '||v_meaning);
3925: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
3926: x_id := v_id;
3927: x_value := v_value;
3928: --added this to return meaning
3929: if v_meaning is not null then

Line 3940: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

3936: Null;
3937: oe_debug_pub.add('value does notmatch, continue search'||p_value||','||v_id);
3938: END IF;
3939: END LOOP;
3940: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
3941: RETURN FALSE;
3942: */
3943: EXCEPTION
3944: WHEN OTHERS THEN

Line 3946: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

3942: */
3943: EXCEPTION
3944: WHEN OTHERS THEN
3945: oe_debug_pub.add('value_exists_in_table exception');
3946: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
3947: RETURN FALSE;
3948: END value_exists_in_table;
3949:
3950: PROCEDURE CORRECT_ACTIVE_DATES(p_active_date_first_type IN OUT NOCOPY VARCHAR2,