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

Line 92: v_cursor := DBMS_SQL.OPEN_CURSOR;

88: v_query := v_query || 'WHERE LOWER (DOCS.FILE_NAME) = LOWER (:pfile) ';
89: ELSE
90: v_query := v_query || 'WHERE DOCS.DOCUMENT_ID = :docId ';
91: END IF;
92: v_cursor := DBMS_SQL.OPEN_CURSOR;
93: DBMS_SQL.PARSE (v_cursor, v_query, DBMS_SQL.NATIVE);
94: -- G HOOKER 09-May-2003 SQL Bind Compliance
95: IF (p_file IS NOT NULL) THEN
96: DBMS_SQL.BIND_VARIABLE(v_cursor, ':pfile', P_FILE);

Line 93: DBMS_SQL.PARSE (v_cursor, v_query, DBMS_SQL.NATIVE);

89: ELSE
90: v_query := v_query || 'WHERE DOCS.DOCUMENT_ID = :docId ';
91: END IF;
92: v_cursor := DBMS_SQL.OPEN_CURSOR;
93: DBMS_SQL.PARSE (v_cursor, v_query, DBMS_SQL.NATIVE);
94: -- G HOOKER 09-May-2003 SQL Bind Compliance
95: IF (p_file IS NOT NULL) THEN
96: DBMS_SQL.BIND_VARIABLE(v_cursor, ':pfile', P_FILE);
97: ELSE

Line 96: DBMS_SQL.BIND_VARIABLE(v_cursor, ':pfile', P_FILE);

92: v_cursor := DBMS_SQL.OPEN_CURSOR;
93: DBMS_SQL.PARSE (v_cursor, v_query, DBMS_SQL.NATIVE);
94: -- G HOOKER 09-May-2003 SQL Bind Compliance
95: IF (p_file IS NOT NULL) THEN
96: DBMS_SQL.BIND_VARIABLE(v_cursor, ':pfile', P_FILE);
97: ELSE
98: DBMS_SQL.BIND_VARIABLE(v_cursor, ':docId', P_DOCUMENTID);
99: END IF;
100:

Line 98: DBMS_SQL.BIND_VARIABLE(v_cursor, ':docId', P_DOCUMENTID);

94: -- G HOOKER 09-May-2003 SQL Bind Compliance
95: IF (p_file IS NOT NULL) THEN
96: DBMS_SQL.BIND_VARIABLE(v_cursor, ':pfile', P_FILE);
97: ELSE
98: DBMS_SQL.BIND_VARIABLE(v_cursor, ':docId', P_DOCUMENTID);
99: END IF;
100:
101: DBMS_SQL.DEFINE_COLUMN (v_cursor, 1, v_file, 350);
102: DBMS_SQL.DEFINE_COLUMN (v_cursor, 2, v_media_id);

Line 101: DBMS_SQL.DEFINE_COLUMN (v_cursor, 1, v_file, 350);

97: ELSE
98: DBMS_SQL.BIND_VARIABLE(v_cursor, ':docId', P_DOCUMENTID);
99: END IF;
100:
101: DBMS_SQL.DEFINE_COLUMN (v_cursor, 1, v_file, 350);
102: DBMS_SQL.DEFINE_COLUMN (v_cursor, 2, v_media_id);
103: DBMS_SQL.DEFINE_COLUMN (v_cursor, 3, v_datatype_id);
104: DBMS_SQL.DEFINE_COLUMN (v_cursor, 4, v_descr, 255);
105: DBMS_SQL.DEFINE_COLUMN (v_cursor, 5, v_file_name, 2048);

Line 102: DBMS_SQL.DEFINE_COLUMN (v_cursor, 2, v_media_id);

98: DBMS_SQL.BIND_VARIABLE(v_cursor, ':docId', P_DOCUMENTID);
99: END IF;
100:
101: DBMS_SQL.DEFINE_COLUMN (v_cursor, 1, v_file, 350);
102: DBMS_SQL.DEFINE_COLUMN (v_cursor, 2, v_media_id);
103: DBMS_SQL.DEFINE_COLUMN (v_cursor, 3, v_datatype_id);
104: DBMS_SQL.DEFINE_COLUMN (v_cursor, 4, v_descr, 255);
105: DBMS_SQL.DEFINE_COLUMN (v_cursor, 5, v_file_name, 2048);
106: DBMS_SQL.DEFINE_COLUMN (v_cursor, 6, v_cat_appid);

Line 103: DBMS_SQL.DEFINE_COLUMN (v_cursor, 3, v_datatype_id);

99: END IF;
100:
101: DBMS_SQL.DEFINE_COLUMN (v_cursor, 1, v_file, 350);
102: DBMS_SQL.DEFINE_COLUMN (v_cursor, 2, v_media_id);
103: DBMS_SQL.DEFINE_COLUMN (v_cursor, 3, v_datatype_id);
104: DBMS_SQL.DEFINE_COLUMN (v_cursor, 4, v_descr, 255);
105: DBMS_SQL.DEFINE_COLUMN (v_cursor, 5, v_file_name, 2048);
106: DBMS_SQL.DEFINE_COLUMN (v_cursor, 6, v_cat_appid);
107: DBMS_SQL.DEFINE_COLUMN (v_cursor, 7, v_cat_name, 255);

Line 104: DBMS_SQL.DEFINE_COLUMN (v_cursor, 4, v_descr, 255);

100:
101: DBMS_SQL.DEFINE_COLUMN (v_cursor, 1, v_file, 350);
102: DBMS_SQL.DEFINE_COLUMN (v_cursor, 2, v_media_id);
103: DBMS_SQL.DEFINE_COLUMN (v_cursor, 3, v_datatype_id);
104: DBMS_SQL.DEFINE_COLUMN (v_cursor, 4, v_descr, 255);
105: DBMS_SQL.DEFINE_COLUMN (v_cursor, 5, v_file_name, 2048);
106: DBMS_SQL.DEFINE_COLUMN (v_cursor, 6, v_cat_appid);
107: DBMS_SQL.DEFINE_COLUMN (v_cursor, 7, v_cat_name, 255);
108:

Line 105: DBMS_SQL.DEFINE_COLUMN (v_cursor, 5, v_file_name, 2048);

101: DBMS_SQL.DEFINE_COLUMN (v_cursor, 1, v_file, 350);
102: DBMS_SQL.DEFINE_COLUMN (v_cursor, 2, v_media_id);
103: DBMS_SQL.DEFINE_COLUMN (v_cursor, 3, v_datatype_id);
104: DBMS_SQL.DEFINE_COLUMN (v_cursor, 4, v_descr, 255);
105: DBMS_SQL.DEFINE_COLUMN (v_cursor, 5, v_file_name, 2048);
106: DBMS_SQL.DEFINE_COLUMN (v_cursor, 6, v_cat_appid);
107: DBMS_SQL.DEFINE_COLUMN (v_cursor, 7, v_cat_name, 255);
108:
109: v_dummy := DBMS_SQL.EXECUTE (v_cursor);

Line 106: DBMS_SQL.DEFINE_COLUMN (v_cursor, 6, v_cat_appid);

102: DBMS_SQL.DEFINE_COLUMN (v_cursor, 2, v_media_id);
103: DBMS_SQL.DEFINE_COLUMN (v_cursor, 3, v_datatype_id);
104: DBMS_SQL.DEFINE_COLUMN (v_cursor, 4, v_descr, 255);
105: DBMS_SQL.DEFINE_COLUMN (v_cursor, 5, v_file_name, 2048);
106: DBMS_SQL.DEFINE_COLUMN (v_cursor, 6, v_cat_appid);
107: DBMS_SQL.DEFINE_COLUMN (v_cursor, 7, v_cat_name, 255);
108:
109: v_dummy := DBMS_SQL.EXECUTE (v_cursor);
110: v_dummy := DBMS_SQL.fetch_rows (v_cursor);

Line 107: DBMS_SQL.DEFINE_COLUMN (v_cursor, 7, v_cat_name, 255);

103: DBMS_SQL.DEFINE_COLUMN (v_cursor, 3, v_datatype_id);
104: DBMS_SQL.DEFINE_COLUMN (v_cursor, 4, v_descr, 255);
105: DBMS_SQL.DEFINE_COLUMN (v_cursor, 5, v_file_name, 2048);
106: DBMS_SQL.DEFINE_COLUMN (v_cursor, 6, v_cat_appid);
107: DBMS_SQL.DEFINE_COLUMN (v_cursor, 7, v_cat_name, 255);
108:
109: v_dummy := DBMS_SQL.EXECUTE (v_cursor);
110: v_dummy := DBMS_SQL.fetch_rows (v_cursor);
111: DBMS_SQL.column_value (v_cursor, 1, v_file);

Line 109: v_dummy := DBMS_SQL.EXECUTE (v_cursor);

105: DBMS_SQL.DEFINE_COLUMN (v_cursor, 5, v_file_name, 2048);
106: DBMS_SQL.DEFINE_COLUMN (v_cursor, 6, v_cat_appid);
107: DBMS_SQL.DEFINE_COLUMN (v_cursor, 7, v_cat_name, 255);
108:
109: v_dummy := DBMS_SQL.EXECUTE (v_cursor);
110: v_dummy := DBMS_SQL.fetch_rows (v_cursor);
111: DBMS_SQL.column_value (v_cursor, 1, v_file);
112:
113: -- Added items for fnd_lobs changes

Line 110: v_dummy := DBMS_SQL.fetch_rows (v_cursor);

106: DBMS_SQL.DEFINE_COLUMN (v_cursor, 6, v_cat_appid);
107: DBMS_SQL.DEFINE_COLUMN (v_cursor, 7, v_cat_name, 255);
108:
109: v_dummy := DBMS_SQL.EXECUTE (v_cursor);
110: v_dummy := DBMS_SQL.fetch_rows (v_cursor);
111: DBMS_SQL.column_value (v_cursor, 1, v_file);
112:
113: -- Added items for fnd_lobs changes
114: DBMS_SQL.column_value (v_cursor, 2, v_media_id);

Line 111: DBMS_SQL.column_value (v_cursor, 1, v_file);

107: DBMS_SQL.DEFINE_COLUMN (v_cursor, 7, v_cat_name, 255);
108:
109: v_dummy := DBMS_SQL.EXECUTE (v_cursor);
110: v_dummy := DBMS_SQL.fetch_rows (v_cursor);
111: DBMS_SQL.column_value (v_cursor, 1, v_file);
112:
113: -- Added items for fnd_lobs changes
114: DBMS_SQL.column_value (v_cursor, 2, v_media_id);
115: DBMS_SQL.column_value (v_cursor, 3, v_datatype_id);

Line 114: DBMS_SQL.column_value (v_cursor, 2, v_media_id);

110: v_dummy := DBMS_SQL.fetch_rows (v_cursor);
111: DBMS_SQL.column_value (v_cursor, 1, v_file);
112:
113: -- Added items for fnd_lobs changes
114: DBMS_SQL.column_value (v_cursor, 2, v_media_id);
115: DBMS_SQL.column_value (v_cursor, 3, v_datatype_id);
116: DBMS_SQL.column_value (v_cursor, 4, v_descr);
117: DBMS_SQL.column_value (v_cursor, 5, v_file_name);
118: DBMS_SQL.column_value (v_cursor, 6, v_cat_appid);

Line 115: DBMS_SQL.column_value (v_cursor, 3, v_datatype_id);

111: DBMS_SQL.column_value (v_cursor, 1, v_file);
112:
113: -- Added items for fnd_lobs changes
114: DBMS_SQL.column_value (v_cursor, 2, v_media_id);
115: DBMS_SQL.column_value (v_cursor, 3, v_datatype_id);
116: DBMS_SQL.column_value (v_cursor, 4, v_descr);
117: DBMS_SQL.column_value (v_cursor, 5, v_file_name);
118: DBMS_SQL.column_value (v_cursor, 6, v_cat_appid);
119: DBMS_SQL.column_value (v_cursor, 7, v_cat_name);

Line 116: DBMS_SQL.column_value (v_cursor, 4, v_descr);

112:
113: -- Added items for fnd_lobs changes
114: DBMS_SQL.column_value (v_cursor, 2, v_media_id);
115: DBMS_SQL.column_value (v_cursor, 3, v_datatype_id);
116: DBMS_SQL.column_value (v_cursor, 4, v_descr);
117: DBMS_SQL.column_value (v_cursor, 5, v_file_name);
118: DBMS_SQL.column_value (v_cursor, 6, v_cat_appid);
119: DBMS_SQL.column_value (v_cursor, 7, v_cat_name);
120:

Line 117: DBMS_SQL.column_value (v_cursor, 5, v_file_name);

113: -- Added items for fnd_lobs changes
114: DBMS_SQL.column_value (v_cursor, 2, v_media_id);
115: DBMS_SQL.column_value (v_cursor, 3, v_datatype_id);
116: DBMS_SQL.column_value (v_cursor, 4, v_descr);
117: DBMS_SQL.column_value (v_cursor, 5, v_file_name);
118: DBMS_SQL.column_value (v_cursor, 6, v_cat_appid);
119: DBMS_SQL.column_value (v_cursor, 7, v_cat_name);
120:
121: DBMS_SQL.close_cursor(v_cursor);

Line 118: DBMS_SQL.column_value (v_cursor, 6, v_cat_appid);

114: DBMS_SQL.column_value (v_cursor, 2, v_media_id);
115: DBMS_SQL.column_value (v_cursor, 3, v_datatype_id);
116: DBMS_SQL.column_value (v_cursor, 4, v_descr);
117: DBMS_SQL.column_value (v_cursor, 5, v_file_name);
118: DBMS_SQL.column_value (v_cursor, 6, v_cat_appid);
119: DBMS_SQL.column_value (v_cursor, 7, v_cat_name);
120:
121: DBMS_SQL.close_cursor(v_cursor);
122:

Line 119: DBMS_SQL.column_value (v_cursor, 7, v_cat_name);

115: DBMS_SQL.column_value (v_cursor, 3, v_datatype_id);
116: DBMS_SQL.column_value (v_cursor, 4, v_descr);
117: DBMS_SQL.column_value (v_cursor, 5, v_file_name);
118: DBMS_SQL.column_value (v_cursor, 6, v_cat_appid);
119: DBMS_SQL.column_value (v_cursor, 7, v_cat_name);
120:
121: DBMS_SQL.close_cursor(v_cursor);
122:
123: if (icx_sec.validateSession) then

Line 121: DBMS_SQL.close_cursor(v_cursor);

117: DBMS_SQL.column_value (v_cursor, 5, v_file_name);
118: DBMS_SQL.column_value (v_cursor, 6, v_cat_appid);
119: DBMS_SQL.column_value (v_cursor, 7, v_cat_name);
120:
121: DBMS_SQL.close_cursor(v_cursor);
122:
123: if (icx_sec.validateSession) then
124: if (v_datatype_id = 6) then
125: v_display_flag := FALSE;