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

Line 708: p_id_list OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

704: --
705:
706: PROCEDURE Execute_GetID_QUERY(
707: p_query_block IN VARCHAR2,
708: p_id_list OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
709: return_code OUT NOCOPY NUMBER,
710: error_description OUT NOCOPY VARCHAR2)
711: IS
712: TYPE v_cursorType IS REF CURSOR;

Line 803: -- DBMS_SQL variables

799: PROCEDURE RunProc(p_NumParams IN NUMBER,
800: p_ProcName IN VARCHAR2,
801: p_Parameters IN OUT NOCOPY t_ParameterList) IS
802:
803: -- DBMS_SQL variables
804: v_Cursor NUMBER;
805: v_NumRows NUMBER;
806: lv_InOut DBMS_DESCRIBE.NUMBER_TABLE;
807:

Line 832: v_Cursor := DBMS_SQL.OPEN_CURSOR;

828:
829: v_ProcCall := v_ProcCall || '); END;';
830:
831: -- Open the cursor and parse the statement.
832: v_Cursor := DBMS_SQL.OPEN_CURSOR;
833: DBMS_SQL.PARSE(v_Cursor, v_ProcCall, DBMS_SQL.V7);
834:
835: -- Bind the procedure parameters.
836: FOR v_Counter IN 1..p_NumParams LOOP

Line 833: DBMS_SQL.PARSE(v_Cursor, v_ProcCall, DBMS_SQL.V7);

829: v_ProcCall := v_ProcCall || '); END;';
830:
831: -- Open the cursor and parse the statement.
832: v_Cursor := DBMS_SQL.OPEN_CURSOR;
833: DBMS_SQL.PARSE(v_Cursor, v_ProcCall, DBMS_SQL.V7);
834:
835: -- Bind the procedure parameters.
836: FOR v_Counter IN 1..p_NumParams LOOP
837:

Line 843: DBMS_SQL.BIND_VARIABLE(v_Cursor, p_Parameters(v_Counter).name,

839: p_Parameters(v_Counter).name := v_ArgumentName(v_Counter);
840:
841: -- Bind based on the parameter type.
842: IF p_Parameters(v_Counter).actual_type = 'NUMBER' THEN
843: DBMS_SQL.BIND_VARIABLE(v_Cursor, p_Parameters(v_Counter).name,
844: p_Parameters(v_Counter).num_param);
845: ELSIF p_Parameters(v_Counter).actual_type = 'VARCHAR2' THEN
846: DBMS_SQL.BIND_VARIABLE(v_Cursor, p_Parameters(v_Counter).name,
847: p_Parameters(v_Counter).vchar_param, 32767);

Line 846: DBMS_SQL.BIND_VARIABLE(v_Cursor, p_Parameters(v_Counter).name,

842: IF p_Parameters(v_Counter).actual_type = 'NUMBER' THEN
843: DBMS_SQL.BIND_VARIABLE(v_Cursor, p_Parameters(v_Counter).name,
844: p_Parameters(v_Counter).num_param);
845: ELSIF p_Parameters(v_Counter).actual_type = 'VARCHAR2' THEN
846: DBMS_SQL.BIND_VARIABLE(v_Cursor, p_Parameters(v_Counter).name,
847: p_Parameters(v_Counter).vchar_param, 32767);
848: ELSIF p_Parameters(v_Counter).actual_type = 'DATE' THEN
849: DBMS_SQL.BIND_VARIABLE(v_Cursor, p_Parameters(v_Counter).name,
850: p_Parameters(v_Counter).date_param);

Line 849: DBMS_SQL.BIND_VARIABLE(v_Cursor, p_Parameters(v_Counter).name,

845: ELSIF p_Parameters(v_Counter).actual_type = 'VARCHAR2' THEN
846: DBMS_SQL.BIND_VARIABLE(v_Cursor, p_Parameters(v_Counter).name,
847: p_Parameters(v_Counter).vchar_param, 32767);
848: ELSIF p_Parameters(v_Counter).actual_type = 'DATE' THEN
849: DBMS_SQL.BIND_VARIABLE(v_Cursor, p_Parameters(v_Counter).name,
850: p_Parameters(v_Counter).date_param);
851: ELSIF p_Parameters(v_Counter).actual_type = 'CHAR' THEN
852: DBMS_SQL.BIND_VARIABLE_CHAR(v_Cursor, p_Parameters(v_Counter).name,
853: p_Parameters(v_Counter).char_param, 500);

Line 852: DBMS_SQL.BIND_VARIABLE_CHAR(v_Cursor, p_Parameters(v_Counter).name,

848: ELSIF p_Parameters(v_Counter).actual_type = 'DATE' THEN
849: DBMS_SQL.BIND_VARIABLE(v_Cursor, p_Parameters(v_Counter).name,
850: p_Parameters(v_Counter).date_param);
851: ELSIF p_Parameters(v_Counter).actual_type = 'CHAR' THEN
852: DBMS_SQL.BIND_VARIABLE_CHAR(v_Cursor, p_Parameters(v_Counter).name,
853: p_Parameters(v_Counter).char_param, 500);
854: ELSE
855: RAISE_APPLICATION_ERROR(-20501, 'Dynamic PL/SQL error: Invalid parameter type');
856: END IF;

Line 860: v_NumRows := DBMS_SQL.EXECUTE(v_Cursor);

856: END IF;
857: END LOOP;
858:
859: -- Execute the procedure.
860: v_NumRows := DBMS_SQL.EXECUTE(v_Cursor);
861:
862: -- Call VARIABLE_VALUE for any OUT or IN OUT parameters.
863: FOR v_Counter IN 1..p_NumParams LOOP
864: IF lv_InOut(v_Counter) = 1 OR lv_InOut(v_Counter) = 2 THEN

Line 866: DBMS_SQL.VARIABLE_VALUE(v_Cursor, ':' || p_Parameters(v_Counter).name,

862: -- Call VARIABLE_VALUE for any OUT or IN OUT parameters.
863: FOR v_Counter IN 1..p_NumParams LOOP
864: IF lv_InOut(v_Counter) = 1 OR lv_InOut(v_Counter) = 2 THEN
865: IF p_Parameters(v_Counter).actual_type = 'NUMBER' THEN
866: DBMS_SQL.VARIABLE_VALUE(v_Cursor, ':' || p_Parameters(v_Counter).name,
867: p_Parameters(v_Counter).num_param);
868: ELSIF p_Parameters(v_Counter).actual_type = 'VARCHAR2' THEN
869: DBMS_SQL.VARIABLE_VALUE(v_Cursor, ':' || p_Parameters(v_Counter).name,
870: p_Parameters(v_Counter).vchar_param);

Line 869: DBMS_SQL.VARIABLE_VALUE(v_Cursor, ':' || p_Parameters(v_Counter).name,

865: IF p_Parameters(v_Counter).actual_type = 'NUMBER' THEN
866: DBMS_SQL.VARIABLE_VALUE(v_Cursor, ':' || p_Parameters(v_Counter).name,
867: p_Parameters(v_Counter).num_param);
868: ELSIF p_Parameters(v_Counter).actual_type = 'VARCHAR2' THEN
869: DBMS_SQL.VARIABLE_VALUE(v_Cursor, ':' || p_Parameters(v_Counter).name,
870: p_Parameters(v_Counter).vchar_param);
871: ELSIF p_Parameters(v_Counter).actual_type = 'DATE' THEN
872: DBMS_SQL.VARIABLE_VALUE(v_Cursor, ':' || p_Parameters(v_Counter).name,
873: p_Parameters(v_Counter).date_param);

Line 872: DBMS_SQL.VARIABLE_VALUE(v_Cursor, ':' || p_Parameters(v_Counter).name,

868: ELSIF p_Parameters(v_Counter).actual_type = 'VARCHAR2' THEN
869: DBMS_SQL.VARIABLE_VALUE(v_Cursor, ':' || p_Parameters(v_Counter).name,
870: p_Parameters(v_Counter).vchar_param);
871: ELSIF p_Parameters(v_Counter).actual_type = 'DATE' THEN
872: DBMS_SQL.VARIABLE_VALUE(v_Cursor, ':' || p_Parameters(v_Counter).name,
873: p_Parameters(v_Counter).date_param);
874: ELSIF p_Parameters(v_Counter).actual_type = 'CHAR' THEN
875: DBMS_SQL.VARIABLE_VALUE_CHAR(v_Cursor, ':' || p_Parameters(v_Counter).name,
876: p_Parameters(v_Counter).char_param);

Line 875: DBMS_SQL.VARIABLE_VALUE_CHAR(v_Cursor, ':' || p_Parameters(v_Counter).name,

871: ELSIF p_Parameters(v_Counter).actual_type = 'DATE' THEN
872: DBMS_SQL.VARIABLE_VALUE(v_Cursor, ':' || p_Parameters(v_Counter).name,
873: p_Parameters(v_Counter).date_param);
874: ELSIF p_Parameters(v_Counter).actual_type = 'CHAR' THEN
875: DBMS_SQL.VARIABLE_VALUE_CHAR(v_Cursor, ':' || p_Parameters(v_Counter).name,
876: p_Parameters(v_Counter).char_param);
877: ELSE
878: RAISE_APPLICATION_ERROR(-20501, 'Dynamic PL/SQL error: Invalid parameter type');
879: END IF;

Line 882: DBMS_SQL.CLOSE_CURSOR(v_Cursor);

878: RAISE_APPLICATION_ERROR(-20501, 'Dynamic PL/SQL error: Invalid parameter type');
879: END IF;
880: END IF;
881: END LOOP;
882: DBMS_SQL.CLOSE_CURSOR(v_Cursor);
883:
884: EXCEPTION
885: WHEN OTHERS THEN
886: DBMS_SQL.CLOSE_CURSOR(v_Cursor);

Line 886: DBMS_SQL.CLOSE_CURSOR(v_Cursor);

882: DBMS_SQL.CLOSE_CURSOR(v_Cursor);
883:
884: EXCEPTION
885: WHEN OTHERS THEN
886: DBMS_SQL.CLOSE_CURSOR(v_Cursor);
887: raise;
888: END RunProc;
889:
890: PROCEDURE Printparams(p_Parameters IN t_ParameterList,

Line 2108: P_ID_LIST OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

2104: P_PHONE_NUMBER IN VARCHAR2,
2105: P_DUE_DATE IN VARCHAR2,
2106: P_ACCOUNT_ID IN VARCHAR2,
2107: P_QUERY_BLOCK IN VARCHAR2,
2108: P_ID_LIST OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
2109: RETURN_CODE OUT NOCOPY NUMBER,
2110: ERROR_DESCRIPTION OUT NOCOPY VARCHAR2)
2111: IS
2112: