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.AMS_DISCOVERER_PVT dependencies on AMS_DISCOVERER_SQL

Line 109: -- to The AMS_DISCOVERER_SQL table.

105: -- EUL_TRIGGER$POST_SAVE_DOCUMENT
106:
107: -- PURPOSE
108: -- 1. This Function is used by Oracle Discoverer to save a WorkSheets SQL
109: -- to The AMS_DISCOVERER_SQL table.
110:
111: -- 2. This Function must be Registered as a valid Function using Oracle
112: -- Discoverer's Administration Edition before any WorkBook SQL will be
113: -- saved.

Line 147: SELECT ams_discoverer_sql_s.NEXTVAL

143: l_sqlerrm varchar2(600);
144: l_sqlcode varchar2(100);
145:
146: CURSOR c_get_seq IS
147: SELECT ams_discoverer_sql_s.NEXTVAL
148: FROM DUAL;
149:
150: l_discoverer_sql_id NUMBER;
151:

Line 159: FROM ams_discoverer_sql

155: -- to determine if the requested worksheet is a replacement
156: -- or a continuation, and if source type code is defined
157: CURSOR c_disco (p_workbook_name IN VARCHAR2, p_worksheet_name IN VARCHAR2) IS
158: SELECT MIN (discoverer_sql_id), MAX (sequence_order), MAX (source_type_code)
159: FROM ams_discoverer_sql
160: WHERE workbook_name = p_workbook_name
161: AND worksheet_name = p_worksheet_name
162: ;
163:

Line 164: l_source_type_code ams_discoverer_sql.source_type_code%TYPE;

160: WHERE workbook_name = p_workbook_name
161: AND worksheet_name = p_worksheet_name
162: ;
163:
164: l_source_type_code ams_discoverer_sql.source_type_code%TYPE;
165: BEGIN
166: OPEN c_disco (p_workbookname, p_worksheetname);
167: FETCH c_disco INTO l_discoverer_sql_id, l_max_sequence_number, l_source_type_code;
168: CLOSE c_disco;

Line 174: from ams_discoverer_sql

170: /* choang - 24-jun-2002 - replaced with new logic
171: --checking for an existing set of entries for this workbook and worksheet combination.
172: select max(sequence_order)
173: into l_max_sequence_number
174: from ams_discoverer_sql
175: where workbook_name = P_WorkBookName
176: and WORKSHEET_NAME = P_WorkSheetName;
177: */
178:

Line 184: from ams_discoverer_sql

180: -- checking the start discoverer_sql_id for this workbook and worksheet
181: -- combination
182: select min(discoverer_sql_id)
183: into l_start_id
184: from ams_discoverer_sql
185: where workbook_name = P_WorkBookName
186: and worksheet_name = P_WorkSheetName;
187: */
188:

Line 189: --if the workbook and worksheet combination exists in the AMS_DISCOVERER_SQL table

185: where workbook_name = P_WorkBookName
186: and worksheet_name = P_WorkSheetName;
187: */
188:
189: --if the workbook and worksheet combination exists in the AMS_DISCOVERER_SQL table
190: --then delete all entries , then we can insert the new records for the newest version
191: --of this workbook - worksheet.
192: IF ((l_max_sequence_number >= p_sequence) OR (l_max_sequence_number = 0)) THEN
193: DELETE FROM ams_discoverer_sql

Line 193: DELETE FROM ams_discoverer_sql

189: --if the workbook and worksheet combination exists in the AMS_DISCOVERER_SQL table
190: --then delete all entries , then we can insert the new records for the newest version
191: --of this workbook - worksheet.
192: IF ((l_max_sequence_number >= p_sequence) OR (l_max_sequence_number = 0)) THEN
193: DELETE FROM ams_discoverer_sql
194: WHERE workbook_name = p_workbookname
195: AND WORKSHEET_NAME = p_worksheetname;
196: END IF;
197:

Line 218: INSERT INTO ams_discoverer_sql (

214: FETCH c_get_seq INTO l_discoverer_sql_id;
215: CLOSE c_get_seq;
216: END IF;
217:
218: INSERT INTO ams_discoverer_sql (
219: discoverer_sql_id,
220: workbook_owner_name,
221: workbook_name,
222: worksheet_name,

Line 254: UPDATE ams_discoverer_sql

250: x_source_type_code => l_source_type_code
251: );
252:
253: IF l_source_type_code IS NOT NULL THEN
254: UPDATE ams_discoverer_sql
255: SET source_type_code = l_source_type_code
256: WHERE workbook_name = p_workbookname
257: AND worksheet_name = p_worksheetname
258: AND (source_type_code <> l_source_type_code OR source_type_code IS NULL)

Line 278: -- AMS_DISCOVERER_SQL table.

274:
275: -- PURPOSE
276: -- 1. Will search for the p_search_string variable in the set of strings
277: -- which compose a workbook SQL statement and are stored in the
278: -- AMS_DISCOVERER_SQL table.
279:
280: -- 2. p_found will return FND_API.G_TRUE if the string has been found.
281:
282: -- 3. p_found_in_str returns the number of the sql string in which the search

Line 366: From Ams_Discoverer_SQL

362: l_sqlcode varchar2(100);
363:
364: Cursor C_SQL_string IS
365: Select Sql_String
366: From Ams_Discoverer_SQL
367: Where Workbook_name = p_workbook_name
368: And Worksheet_name = p_worksheet_name
369: Order by Sequence_Order;
370:

Line 383: From ams_discoverer_sql

379:
380: --getting the total number of strings that compose the sql statement.
381: Select Count(*)
382: into l_str_count
383: From ams_discoverer_sql
384: Where Workbook_name = p_workbook_name
385: And Worksheet_name = p_worksheet_name;
386:
387: if (l_str_count = 0) then

Line 637: l_source_type_code ams_discoverer_sql.source_type_code%TYPE; --VARCHAR2(30);

633: x_source_type_code OUT NOCOPY VARCHAR2
634: )
635: IS
636: -- by musman bug:4655422:fix start
637: l_source_type_code ams_discoverer_sql.source_type_code%TYPE; --VARCHAR2(30);
638: l_search_code VARCHAR2(50);-- VARCHAR2(30);
639: --end
640:
641: -- variables used to call search_sql_string

Line 722: FROM ams_discoverer_sql

718: l_end_offset NUMBER := MAX_FRAGMENTS;
719:
720: CURSOR c_sql_string IS
721: SELECT sql_string
722: FROM ams_discoverer_sql
723: WHERE workbook_name = p_workbook_name
724: AND worksheet_name = p_worksheet_name
725: ORDER BY sequence_order;
726: BEGIN