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: --8923075 No validation can be done if there is a bind variable

Line 1717: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

1713: open v_cursor for v_selectstmt using p_value;
1714: fetch v_cursor into valueset_cur;
1715: IF v_Cursor%NOTFOUND THEN
1716: CLOSE v_cursor;
1717: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1718: RETURN FALSE;
1719: END IF;
1720: x_id := valueset_cur.valueset_id;
1721: x_value := valueset_cur.valueset_value;

Line 1723: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

1719: END IF;
1720: x_id := valueset_cur.valueset_id;
1721: x_value := valueset_cur.valueset_value;
1722: CLOSE v_cursor;
1723: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1724: RETURN TRUE;
1725:
1726:
1727: /*

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

1726:
1727: /*
1728: -- parse the query
1729:
1730: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
1731: oe_debug_pub.add('after parse1');
1732: -- Bind the input variables
1733: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
1734: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);

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

1729:
1730: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
1731: oe_debug_pub.add('after parse1');
1732: -- Bind the input variables
1733: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
1734: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
1735: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);
1736: LOOP
1737: -- Fetch rows in to buffer and check the exit condition from the loop

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

1730: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
1731: oe_debug_pub.add('after parse1');
1732: -- Bind the input variables
1733: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
1734: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
1735: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);
1736: LOOP
1737: -- Fetch rows in to buffer and check the exit condition from the loop
1738: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN

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

1731: oe_debug_pub.add('after parse1');
1732: -- Bind the input variables
1733: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
1734: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
1735: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);
1736: LOOP
1737: -- Fetch rows in to buffer and check the exit condition from the loop
1738: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN
1739: EXIT;

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

1734: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
1735: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);
1736: LOOP
1737: -- Fetch rows in to buffer and check the exit condition from the loop
1738: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN
1739: EXIT;
1740: END IF;
1741: -- Retrieve the rows from buffer into PLSQL variables
1742: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);

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

1738: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN
1739: EXIT;
1740: END IF;
1741: -- Retrieve the rows from buffer into PLSQL variables
1742: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);
1743: DBMS_SQL.COLUMN_VALUE(v_cursor_id,2,v_id);
1744:
1745: IF v_id IS NULL AND (p_value = v_value) THEN
1746: oe_debug_pub.add('id null, passing value'||p_value||','||v_value);

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

1739: EXIT;
1740: END IF;
1741: -- Retrieve the rows from buffer into PLSQL variables
1742: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);
1743: DBMS_SQL.COLUMN_VALUE(v_cursor_id,2,v_id);
1744:
1745: IF v_id IS NULL AND (p_value = v_value) THEN
1746: oe_debug_pub.add('id null, passing value'||p_value||','||v_value);
1747: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

Line 1747: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

1743: DBMS_SQL.COLUMN_VALUE(v_cursor_id,2,v_id);
1744:
1745: IF v_id IS NULL AND (p_value = v_value) THEN
1746: oe_debug_pub.add('id null, passing value'||p_value||','||v_value);
1747: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1748: x_id := v_id;
1749: x_value := v_value;
1750: RETURN TRUE;
1751: ELSIF (p_value = v_id) THEN

Line 1753: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

1749: x_value := v_value;
1750: RETURN TRUE;
1751: ELSIF (p_value = v_id) THEN
1752: oe_debug_pub.add('id exists, passing id'||p_value||','||v_id);
1753: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1754: x_id := v_id;
1755: x_value := v_value;
1756: RETURN TRUE;
1757: ELSE

Line 1762: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

1758: Null;
1759: oe_debug_pub.add('value does notmatch, continue search'||p_value||','||v_id);
1760: END IF;
1761: END LOOP;
1762: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1763: RETURN FALSE;
1764: */
1765: EXCEPTION
1766: WHEN OTHERS THEN

Line 1768: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

1764: */
1765: EXCEPTION
1766: WHEN OTHERS THEN
1767: oe_debug_pub.add('value_exists_in_table exception');
1768: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
1769: RETURN FALSE;
1770: END value_exists_in_table;
1771:
1772: -- =============================================================================

Line 3751: v_cursor_id := DBMS_SQL.OPEN_CURSOR;

3747: valueset_cur valueset_cur_type;
3748:
3749:
3750: BEGIN
3751: v_cursor_id := DBMS_SQL.OPEN_CURSOR;
3752:
3753: --Commented out for 2621644
3754: --IF (p_table_r.id_column_name IS NOT NULL) THEN -- Bug 1982009
3755:

Line 3898: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

3894: open v_cursor for v_selectstmt using p_value;
3895: fetch v_cursor into valueset_cur;
3896: IF v_Cursor%NOTFOUND THEN
3897: CLOSE v_cursor;
3898: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
3899: RETURN FALSE;
3900: END IF;
3901: x_id := valueset_cur.valueset_id;
3902: x_value := valueset_cur.valueset_value;

Line 3909: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

3905: Else
3906: x_meaning:= valueset_cur.valueset_value;
3907: End If;
3908: CLOSE v_cursor;
3909: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
3910: RETURN TRUE;
3911:
3912: /*
3913: -- parse the query

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

3911:
3912: /*
3913: -- parse the query
3914:
3915: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
3916: oe_debug_pub.add('after parse2');
3917: -- Bind the input variables
3918: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
3919: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);

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

3914:
3915: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
3916: oe_debug_pub.add('after parse2');
3917: -- Bind the input variables
3918: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
3919: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
3920: if p_table_r.meaning_column_name IS NOT NULL THEN
3921: -- julin (2271729) - increased size for UTF8
3922: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,3,v_meaning,1000);

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

3915: DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);
3916: oe_debug_pub.add('after parse2');
3917: -- Bind the input variables
3918: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
3919: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
3920: if p_table_r.meaning_column_name IS NOT NULL THEN
3921: -- julin (2271729) - increased size for UTF8
3922: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,3,v_meaning,1000);
3923: end if;

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

3918: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,1,v_value,150);
3919: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,2,v_id,150);
3920: if p_table_r.meaning_column_name IS NOT NULL THEN
3921: -- julin (2271729) - increased size for UTF8
3922: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,3,v_meaning,1000);
3923: end if;
3924: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);
3925: LOOP
3926: -- Fetch rows in to buffer and check the exit condition from the loop

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

3920: if p_table_r.meaning_column_name IS NOT NULL THEN
3921: -- julin (2271729) - increased size for UTF8
3922: DBMS_SQL.DEFINE_COLUMN(v_cursor_id,3,v_meaning,1000);
3923: end if;
3924: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);
3925: LOOP
3926: -- Fetch rows in to buffer and check the exit condition from the loop
3927: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN
3928: EXIT;

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

3923: end if;
3924: v_retval := DBMS_SQL.EXECUTE(v_cursor_id);
3925: LOOP
3926: -- Fetch rows in to buffer and check the exit condition from the loop
3927: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN
3928: EXIT;
3929: END IF;
3930: -- Retrieve the rows from buffer into PLSQL variables
3931: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);

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

3927: IF( DBMS_SQL.FETCH_ROWS(v_cursor_id) = 0) THEN
3928: EXIT;
3929: END IF;
3930: -- Retrieve the rows from buffer into PLSQL variables
3931: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);
3932: DBMS_SQL.COLUMN_VALUE(v_cursor_id,2,v_id);
3933: if p_table_r.meaning_column_name IS NOT NULL THEN
3934: DBMS_SQL.COLUMN_VALUE(v_cursor_id,3,v_meaning);
3935: end if;

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

3928: EXIT;
3929: END IF;
3930: -- Retrieve the rows from buffer into PLSQL variables
3931: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);
3932: DBMS_SQL.COLUMN_VALUE(v_cursor_id,2,v_id);
3933: if p_table_r.meaning_column_name IS NOT NULL THEN
3934: DBMS_SQL.COLUMN_VALUE(v_cursor_id,3,v_meaning);
3935: end if;
3936:

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

3930: -- Retrieve the rows from buffer into PLSQL variables
3931: DBMS_SQL.COLUMN_VALUE(v_cursor_id,1,v_value);
3932: DBMS_SQL.COLUMN_VALUE(v_cursor_id,2,v_id);
3933: if p_table_r.meaning_column_name IS NOT NULL THEN
3934: DBMS_SQL.COLUMN_VALUE(v_cursor_id,3,v_meaning);
3935: end if;
3936:
3937:
3938: IF v_id IS NULL AND (p_value = v_value) THEN

Line 3940: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

3936:
3937:
3938: IF v_id IS NULL AND (p_value = v_value) THEN
3939: oe_debug_pub.add('id null, passing value'||p_value||','||v_value||' '||v_meaning);
3940: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
3941: x_id := v_id;
3942: x_value := v_value;
3943: --added this to return meaning
3944: x_meaning := v_meaning;

Line 3948: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

3944: x_meaning := v_meaning;
3945: RETURN TRUE;
3946: ELSIF (p_value = v_id) THEN
3947: oe_debug_pub.add('id exists, passing id'||p_value||','||v_id||' '||v_meaning);
3948: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
3949: x_id := v_id;
3950: x_value := v_value;
3951: --added this to return meaning
3952: if v_meaning is not null then

Line 3963: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

3959: Null;
3960: oe_debug_pub.add('value does notmatch, continue search'||p_value||','||v_id);
3961: END IF;
3962: END LOOP;
3963: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
3964: RETURN FALSE;
3965: */
3966: EXCEPTION
3967: WHEN OTHERS THEN

Line 3969: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);

3965: */
3966: EXCEPTION
3967: WHEN OTHERS THEN
3968: oe_debug_pub.add('value_exists_in_table exception');
3969: DBMS_SQL.CLOSE_CURSOR(v_cursor_id);
3970: RETURN FALSE;
3971: END value_exists_in_table;
3972:
3973: PROCEDURE CORRECT_ACTIVE_DATES(p_active_date_first_type IN OUT NOCOPY VARCHAR2,