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

Line 177: ccid_cursor := dbms_sql.open_cursor;

173: ccid_update := ccid_update ||
174: 'AND code_combination_id >= :7 ' ||
175: 'AND template_id IS NOT NULL ';
176:
177: ccid_cursor := dbms_sql.open_cursor;
178: dbms_sql.parse(ccid_cursor, ccid_update, dbms_sql.v7);
179: IF (acct_tname IS NULL) THEN
180: dbms_sql.bind_variable(ccid_cursor, ':1', position_qualifier);
181: ELSE

Line 178: dbms_sql.parse(ccid_cursor, ccid_update, dbms_sql.v7);

174: 'AND code_combination_id >= :7 ' ||
175: 'AND template_id IS NOT NULL ';
176:
177: ccid_cursor := dbms_sql.open_cursor;
178: dbms_sql.parse(ccid_cursor, ccid_update, dbms_sql.v7);
179: IF (acct_tname IS NULL) THEN
180: dbms_sql.bind_variable(ccid_cursor, ':1', position_qualifier);
181: ELSE
182: IF(acct_attrib IS NOT NULL AND substr(acct_attrib, 1, 1) = '''') THEN

Line 180: dbms_sql.bind_variable(ccid_cursor, ':1', position_qualifier);

176:
177: ccid_cursor := dbms_sql.open_cursor;
178: dbms_sql.parse(ccid_cursor, ccid_update, dbms_sql.v7);
179: IF (acct_tname IS NULL) THEN
180: dbms_sql.bind_variable(ccid_cursor, ':1', position_qualifier);
181: ELSE
182: IF(acct_attrib IS NOT NULL AND substr(acct_attrib, 1, 1) = '''') THEN
183: dbms_sql.bind_variable(ccid_cursor, ':2', position_qualifier);
184: ELSIF(acct_attrib IS NOT NULL) THEN

Line 183: dbms_sql.bind_variable(ccid_cursor, ':2', position_qualifier);

179: IF (acct_tname IS NULL) THEN
180: dbms_sql.bind_variable(ccid_cursor, ':1', position_qualifier);
181: ELSE
182: IF(acct_attrib IS NOT NULL AND substr(acct_attrib, 1, 1) = '''') THEN
183: dbms_sql.bind_variable(ccid_cursor, ':2', position_qualifier);
184: ELSIF(acct_attrib IS NOT NULL) THEN
185: dbms_sql.bind_variable(ccid_cursor, ':3', position_qualifier);
186: END IF;
187: dbms_sql.bind_variable(ccid_cursor, ':4', position_qualifier);

Line 185: dbms_sql.bind_variable(ccid_cursor, ':3', position_qualifier);

181: ELSE
182: IF(acct_attrib IS NOT NULL AND substr(acct_attrib, 1, 1) = '''') THEN
183: dbms_sql.bind_variable(ccid_cursor, ':2', position_qualifier);
184: ELSIF(acct_attrib IS NOT NULL) THEN
185: dbms_sql.bind_variable(ccid_cursor, ':3', position_qualifier);
186: END IF;
187: dbms_sql.bind_variable(ccid_cursor, ':4', position_qualifier);
188: dbms_sql.bind_variable(ccid_cursor, ':5', acct_vsetid);
189: END IF;

Line 187: dbms_sql.bind_variable(ccid_cursor, ':4', position_qualifier);

183: dbms_sql.bind_variable(ccid_cursor, ':2', position_qualifier);
184: ELSIF(acct_attrib IS NOT NULL) THEN
185: dbms_sql.bind_variable(ccid_cursor, ':3', position_qualifier);
186: END IF;
187: dbms_sql.bind_variable(ccid_cursor, ':4', position_qualifier);
188: dbms_sql.bind_variable(ccid_cursor, ':5', acct_vsetid);
189: END IF;
190: dbms_sql.bind_variable(ccid_cursor, ':6', coa_id);
191: dbms_sql.bind_variable(ccid_cursor, ':7', min_ccid_processed);

Line 188: dbms_sql.bind_variable(ccid_cursor, ':5', acct_vsetid);

184: ELSIF(acct_attrib IS NOT NULL) THEN
185: dbms_sql.bind_variable(ccid_cursor, ':3', position_qualifier);
186: END IF;
187: dbms_sql.bind_variable(ccid_cursor, ':4', position_qualifier);
188: dbms_sql.bind_variable(ccid_cursor, ':5', acct_vsetid);
189: END IF;
190: dbms_sql.bind_variable(ccid_cursor, ':6', coa_id);
191: dbms_sql.bind_variable(ccid_cursor, ':7', min_ccid_processed);
192: rows_processed := dbms_sql.execute(ccid_cursor);

Line 190: dbms_sql.bind_variable(ccid_cursor, ':6', coa_id);

186: END IF;
187: dbms_sql.bind_variable(ccid_cursor, ':4', position_qualifier);
188: dbms_sql.bind_variable(ccid_cursor, ':5', acct_vsetid);
189: END IF;
190: dbms_sql.bind_variable(ccid_cursor, ':6', coa_id);
191: dbms_sql.bind_variable(ccid_cursor, ':7', min_ccid_processed);
192: rows_processed := dbms_sql.execute(ccid_cursor);
193: dbms_sql.close_cursor(ccid_cursor);
194:

Line 191: dbms_sql.bind_variable(ccid_cursor, ':7', min_ccid_processed);

187: dbms_sql.bind_variable(ccid_cursor, ':4', position_qualifier);
188: dbms_sql.bind_variable(ccid_cursor, ':5', acct_vsetid);
189: END IF;
190: dbms_sql.bind_variable(ccid_cursor, ':6', coa_id);
191: dbms_sql.bind_variable(ccid_cursor, ':7', min_ccid_processed);
192: rows_processed := dbms_sql.execute(ccid_cursor);
193: dbms_sql.close_cursor(ccid_cursor);
194:
195: EXCEPTION

Line 192: rows_processed := dbms_sql.execute(ccid_cursor);

188: dbms_sql.bind_variable(ccid_cursor, ':5', acct_vsetid);
189: END IF;
190: dbms_sql.bind_variable(ccid_cursor, ':6', coa_id);
191: dbms_sql.bind_variable(ccid_cursor, ':7', min_ccid_processed);
192: rows_processed := dbms_sql.execute(ccid_cursor);
193: dbms_sql.close_cursor(ccid_cursor);
194:
195: EXCEPTION
196: WHEN OTHERS THEN

Line 193: dbms_sql.close_cursor(ccid_cursor);

189: END IF;
190: dbms_sql.bind_variable(ccid_cursor, ':6', coa_id);
191: dbms_sql.bind_variable(ccid_cursor, ':7', min_ccid_processed);
192: rows_processed := dbms_sql.execute(ccid_cursor);
193: dbms_sql.close_cursor(ccid_cursor);
194:
195: EXCEPTION
196: WHEN OTHERS THEN
197: dbms_sql.close_cursor(ccid_cursor);

Line 197: dbms_sql.close_cursor(ccid_cursor);

193: dbms_sql.close_cursor(ccid_cursor);
194:
195: EXCEPTION
196: WHEN OTHERS THEN
197: dbms_sql.close_cursor(ccid_cursor);
198: IF (sqlcode = -1407) THEN
199: RAISE INVALID_COMBINATION;
200: ELSE
201: RAISE;