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

Line 1079: l_cursor := DBMS_SQL.OPEN_CURSOR;

1075: ----------------------------------------------------------------------
1076: -- open cursor for dynamic SQL
1077: ----------------------------------------------------------------------
1078:
1079: l_cursor := DBMS_SQL.OPEN_CURSOR;
1080: x_error_code := 0 ;
1081: x_error_message := NULL ;
1082:
1083: ----------------------------------------------------------------------

Line 1087: DBMS_SQL.PARSE ( l_cursor, P_DYNAMIC_MSG_TEXT, DBMS_SQL.V7 ) ;

1083: ----------------------------------------------------------------------
1084: -- parse the SQL statement
1085: ----------------------------------------------------------------------
1086:
1087: DBMS_SQL.PARSE ( l_cursor, P_DYNAMIC_MSG_TEXT, DBMS_SQL.V7 ) ;
1088:
1089: ------------------------------------------------------------------
1090: -- bind all input and output variables
1091: ------------------------------------------------------------------

Line 1092: DBMS_SQL.BIND_VARIABLE ( l_cursor, ':msg_text', x_msg_text ) ;

1088:
1089: ------------------------------------------------------------------
1090: -- bind all input and output variables
1091: ------------------------------------------------------------------
1092: DBMS_SQL.BIND_VARIABLE ( l_cursor, ':msg_text', x_msg_text ) ;
1093: DBMS_SQL.BIND_VARIABLE ( l_cursor, ':error_code', x_error_code ) ;
1094: DBMS_SQL.BIND_VARIABLE ( l_cursor, ':error_message', x_error_message, 1024 ) ;
1095:
1096: ----------------------------------------------------------------------

Line 1093: DBMS_SQL.BIND_VARIABLE ( l_cursor, ':error_code', x_error_code ) ;

1089: ------------------------------------------------------------------
1090: -- bind all input and output variables
1091: ------------------------------------------------------------------
1092: DBMS_SQL.BIND_VARIABLE ( l_cursor, ':msg_text', x_msg_text ) ;
1093: DBMS_SQL.BIND_VARIABLE ( l_cursor, ':error_code', x_error_code ) ;
1094: DBMS_SQL.BIND_VARIABLE ( l_cursor, ':error_message', x_error_message, 1024 ) ;
1095:
1096: ----------------------------------------------------------------------
1097: -- execute the procedure call

Line 1094: DBMS_SQL.BIND_VARIABLE ( l_cursor, ':error_message', x_error_message, 1024 ) ;

1090: -- bind all input and output variables
1091: ------------------------------------------------------------------
1092: DBMS_SQL.BIND_VARIABLE ( l_cursor, ':msg_text', x_msg_text ) ;
1093: DBMS_SQL.BIND_VARIABLE ( l_cursor, ':error_code', x_error_code ) ;
1094: DBMS_SQL.BIND_VARIABLE ( l_cursor, ':error_message', x_error_message, 1024 ) ;
1095:
1096: ----------------------------------------------------------------------
1097: -- execute the procedure call
1098: ----------------------------------------------------------------------

Line 1100: l_num_rows := DBMS_SQL.EXECUTE ( l_cursor ) ;

1096: ----------------------------------------------------------------------
1097: -- execute the procedure call
1098: ----------------------------------------------------------------------
1099:
1100: l_num_rows := DBMS_SQL.EXECUTE ( l_cursor ) ;
1101:
1102: ----------------------------------------------------------------------
1103: -- retrieve the return values
1104: ----------------------------------------------------------------------

Line 1106: DBMS_SQL.VARIABLE_VALUE ( l_cursor, ':msg_text', x_msg_text ) ;

1102: ----------------------------------------------------------------------
1103: -- retrieve the return values
1104: ----------------------------------------------------------------------
1105:
1106: DBMS_SQL.VARIABLE_VALUE ( l_cursor, ':msg_text', x_msg_text ) ;
1107: DBMS_SQL.VARIABLE_VALUE ( l_cursor, ':error_code', x_error_code ) ;
1108: DBMS_SQL.VARIABLE_VALUE ( l_cursor, ':error_message', x_error_message ) ;
1109:
1110: ----------------------------------------------------------------------

Line 1107: DBMS_SQL.VARIABLE_VALUE ( l_cursor, ':error_code', x_error_code ) ;

1103: -- retrieve the return values
1104: ----------------------------------------------------------------------
1105:
1106: DBMS_SQL.VARIABLE_VALUE ( l_cursor, ':msg_text', x_msg_text ) ;
1107: DBMS_SQL.VARIABLE_VALUE ( l_cursor, ':error_code', x_error_code ) ;
1108: DBMS_SQL.VARIABLE_VALUE ( l_cursor, ':error_message', x_error_message ) ;
1109:
1110: ----------------------------------------------------------------------
1111: -- not processing the error message, an exception will be raised

Line 1108: DBMS_SQL.VARIABLE_VALUE ( l_cursor, ':error_message', x_error_message ) ;

1104: ----------------------------------------------------------------------
1105:
1106: DBMS_SQL.VARIABLE_VALUE ( l_cursor, ':msg_text', x_msg_text ) ;
1107: DBMS_SQL.VARIABLE_VALUE ( l_cursor, ':error_code', x_error_code ) ;
1108: DBMS_SQL.VARIABLE_VALUE ( l_cursor, ':error_message', x_error_message ) ;
1109:
1110: ----------------------------------------------------------------------
1111: -- not processing the error message, an exception will be raised
1112: ----------------------------------------------------------------------

Line 1114: DBMS_SQL.CLOSE_CURSOR ( l_cursor ) ;

1110: ----------------------------------------------------------------------
1111: -- not processing the error message, an exception will be raised
1112: ----------------------------------------------------------------------
1113:
1114: DBMS_SQL.CLOSE_CURSOR ( l_cursor ) ;
1115:
1116: END EXEC_DYNAMIC_CREATE_MSG ;
1117:
1118: ----------------------------------------------------------------------

Line 1143: l_cursor := DBMS_SQL.OPEN_CURSOR;

1139: ----------------------------------------------------------------------
1140: -- open cursor for dynamic SQL
1141: ----------------------------------------------------------------------
1142:
1143: l_cursor := DBMS_SQL.OPEN_CURSOR;
1144: x_error_code := 0 ;
1145: x_error_message := NULL ;
1146:
1147: ----------------------------------------------------------------------

Line 1151: DBMS_SQL.PARSE ( l_cursor, P_DYNAMIC_MSG_TEXT, DBMS_SQL.V7 ) ;

1147: ----------------------------------------------------------------------
1148: -- parse the SQL statement
1149: ----------------------------------------------------------------------
1150:
1151: DBMS_SQL.PARSE ( l_cursor, P_DYNAMIC_MSG_TEXT, DBMS_SQL.V7 ) ;
1152:
1153: ------------------------------------------------------------------
1154: -- bind all input and output variables
1155: ------------------------------------------------------------------

Line 1156: DBMS_SQL.BIND_VARIABLE ( l_cursor, ':msg_id', x_msg_id ) ;

1152:
1153: ------------------------------------------------------------------
1154: -- bind all input and output variables
1155: ------------------------------------------------------------------
1156: DBMS_SQL.BIND_VARIABLE ( l_cursor, ':msg_id', x_msg_id ) ;
1157: DBMS_SQL.BIND_VARIABLE ( l_cursor, ':error_code', x_error_code ) ;
1158: DBMS_SQL.BIND_VARIABLE ( l_cursor, ':error_message', x_error_message, 1024 ) ;
1159:
1160: ----------------------------------------------------------------------

Line 1157: DBMS_SQL.BIND_VARIABLE ( l_cursor, ':error_code', x_error_code ) ;

1153: ------------------------------------------------------------------
1154: -- bind all input and output variables
1155: ------------------------------------------------------------------
1156: DBMS_SQL.BIND_VARIABLE ( l_cursor, ':msg_id', x_msg_id ) ;
1157: DBMS_SQL.BIND_VARIABLE ( l_cursor, ':error_code', x_error_code ) ;
1158: DBMS_SQL.BIND_VARIABLE ( l_cursor, ':error_message', x_error_message, 1024 ) ;
1159:
1160: ----------------------------------------------------------------------
1161: -- execute the procedure call

Line 1158: DBMS_SQL.BIND_VARIABLE ( l_cursor, ':error_message', x_error_message, 1024 ) ;

1154: -- bind all input and output variables
1155: ------------------------------------------------------------------
1156: DBMS_SQL.BIND_VARIABLE ( l_cursor, ':msg_id', x_msg_id ) ;
1157: DBMS_SQL.BIND_VARIABLE ( l_cursor, ':error_code', x_error_code ) ;
1158: DBMS_SQL.BIND_VARIABLE ( l_cursor, ':error_message', x_error_message, 1024 ) ;
1159:
1160: ----------------------------------------------------------------------
1161: -- execute the procedure call
1162: ----------------------------------------------------------------------

Line 1164: l_num_rows := DBMS_SQL.EXECUTE ( l_cursor ) ;

1160: ----------------------------------------------------------------------
1161: -- execute the procedure call
1162: ----------------------------------------------------------------------
1163:
1164: l_num_rows := DBMS_SQL.EXECUTE ( l_cursor ) ;
1165:
1166: ----------------------------------------------------------------------
1167: -- retrieve the return values
1168: ----------------------------------------------------------------------

Line 1170: DBMS_SQL.VARIABLE_VALUE ( l_cursor, ':msg_id', x_msg_id ) ;

1166: ----------------------------------------------------------------------
1167: -- retrieve the return values
1168: ----------------------------------------------------------------------
1169:
1170: DBMS_SQL.VARIABLE_VALUE ( l_cursor, ':msg_id', x_msg_id ) ;
1171: DBMS_SQL.VARIABLE_VALUE ( l_cursor, ':error_code', x_error_code ) ;
1172: DBMS_SQL.VARIABLE_VALUE ( l_cursor, ':error_message', x_error_message ) ;
1173:
1174: ----------------------------------------------------------------------

Line 1171: DBMS_SQL.VARIABLE_VALUE ( l_cursor, ':error_code', x_error_code ) ;

1167: -- retrieve the return values
1168: ----------------------------------------------------------------------
1169:
1170: DBMS_SQL.VARIABLE_VALUE ( l_cursor, ':msg_id', x_msg_id ) ;
1171: DBMS_SQL.VARIABLE_VALUE ( l_cursor, ':error_code', x_error_code ) ;
1172: DBMS_SQL.VARIABLE_VALUE ( l_cursor, ':error_message', x_error_message ) ;
1173:
1174: ----------------------------------------------------------------------
1175: -- not processing the error message, an exception will be raised

Line 1172: DBMS_SQL.VARIABLE_VALUE ( l_cursor, ':error_message', x_error_message ) ;

1168: ----------------------------------------------------------------------
1169:
1170: DBMS_SQL.VARIABLE_VALUE ( l_cursor, ':msg_id', x_msg_id ) ;
1171: DBMS_SQL.VARIABLE_VALUE ( l_cursor, ':error_code', x_error_code ) ;
1172: DBMS_SQL.VARIABLE_VALUE ( l_cursor, ':error_message', x_error_message ) ;
1173:
1174: ----------------------------------------------------------------------
1175: -- not processing the error message, an exception will be raised
1176: ----------------------------------------------------------------------

Line 1178: DBMS_SQL.CLOSE_CURSOR ( l_cursor ) ;

1174: ----------------------------------------------------------------------
1175: -- not processing the error message, an exception will be raised
1176: ----------------------------------------------------------------------
1177:
1178: DBMS_SQL.CLOSE_CURSOR ( l_cursor ) ;
1179:
1180: END EXEC_DYNAMIC_SEND_PUBLISH ;
1181:
1182: ------------------------------------------------------------------