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

Line 215: x_sql_statement IN OUT NOCOPY DBMS_SQL.VARCHAR2S);

211: p_excluded_array IN AMV_CHAR_VARRAY_TYPE,
212:
213: p_index IN OUT NOCOPY PLS_INTEGER,
214:
215: x_sql_statement IN OUT NOCOPY DBMS_SQL.VARCHAR2S);
216:
217: --------------------------------------------------------------------------------
218:
219: PROCEDURE get_item_attr_stmt(

Line 243: x_sql_statement IN OUT NOCOPY DBMS_SQL.VARCHAR2S);

239: p_excluded_array IN AMV_CHAR_VARRAY_TYPE,
240:
241: p_index IN OUT NOCOPY PLS_INTEGER,
242:
243: x_sql_statement IN OUT NOCOPY DBMS_SQL.VARCHAR2S);
244:
245: --------------------------------------------------------------------------------
246:
247: PROCEDURE get_user_accessable_channels(

Line 293: x_sql_statement IN OUT NOCOPY DBMS_SQL.VARCHAR2S

289: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
290:
291: p_days IN NUMBER,
292:
293: x_sql_statement IN OUT NOCOPY DBMS_SQL.VARCHAR2S
294:
295: );
296:
297: --------------------------------------------------------------------------------

Line 317: x_sql_statement IN OUT NOCOPY DBMS_SQL.VARCHAR2S

313: p_excluded_flag IN VARCHAR2,
314:
315: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
316:
317: x_sql_statement IN OUT NOCOPY DBMS_SQL.VARCHAR2S
318:
319: );
320:
321: --------------------------------------------------------------------------------

Line 341: x_sql_statement IN OUT NOCOPY DBMS_SQL.VARCHAR2S

337: p_excluded_flag IN VARCHAR2,
338:
339: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
340:
341: x_sql_statement IN OUT NOCOPY DBMS_SQL.VARCHAR2S
342:
343: );
344:
345: --------------------------------------------------------------------------------

Line 365: x_sql_statement IN OUT NOCOPY DBMS_SQL.VARCHAR2S

361: p_excluded_flag IN VARCHAR2,
362:
363: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
364:
365: x_sql_statement IN OUT NOCOPY DBMS_SQL.VARCHAR2S
366:
367: );
368:
369: --------------------------------------------------------------------------------

Line 389: x_sql_statement IN OUT NOCOPY DBMS_SQL.VARCHAR2S

385: p_excluded_flag IN VARCHAR2,
386:
387: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
388:
389: x_sql_statement IN OUT NOCOPY DBMS_SQL.VARCHAR2S
390:
391: );
392:
393: --------------------------------------------------------------------------------

Line 401: PROCEDURE insert_temp_ids(p_stmt IN OUT NOCOPY DBMS_SQL.VARCHAR2S,

397: x_status OUT NOCOPY VARCHAR2);
398:
399: --------------------------------------------------------------------------------
400:
401: PROCEDURE insert_temp_ids(p_stmt IN OUT NOCOPY DBMS_SQL.VARCHAR2S,
402:
403: p_start_index IN PLS_INTEGER,
404:
405: p_end_index IN PLS_INTEGER,

Line 469: x_chan_sql_stmt OUT NOCOPY DBMS_SQL.VARCHAR2S,

465: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
466:
467: p_index IN OUT NOCOPY PLS_INTEGER,
468:
469: x_chan_sql_stmt OUT NOCOPY DBMS_SQL.VARCHAR2S,
470:
471: x_chan_sql_status OUT NOCOPY VARCHAR2);
472:
473: --------------------------------------------------------------------------------

Line 503: x_item_sql_stmt OUT NOCOPY DBMS_SQL.VARCHAR2S,

499: p_external_contents IN VARCHAR2,
500:
501: p_index IN OUT NOCOPY PLS_INTEGER,
502:
503: x_item_sql_stmt OUT NOCOPY DBMS_SQL.VARCHAR2S,
504:
505: x_item_sql_status OUT NOCOPY VARCHAR2);
506:
507: --------------------------------------------------------------------------------

Line 947: x_sql_statement IN OUT NOCOPY DBMS_SQL.VARCHAR2S)

943: p_excluded_array IN AMV_CHAR_VARRAY_TYPE,
944:
945: p_index IN OUT NOCOPY PLS_INTEGER,
946:
947: x_sql_statement IN OUT NOCOPY DBMS_SQL.VARCHAR2S)
948:
949: IS
950:
951: l_where_clause varchar2(10);

Line 1251: x_sql_statement IN OUT NOCOPY DBMS_SQL.VARCHAR2S)

1247: p_excluded_array IN AMV_CHAR_VARRAY_TYPE,
1248:
1249: p_index IN OUT NOCOPY PLS_INTEGER,
1250:
1251: x_sql_statement IN OUT NOCOPY DBMS_SQL.VARCHAR2S)
1252:
1253: IS
1254:
1255: l_where_clause varchar2(10);

Line 1296: x_sqlSubSql DBMS_SQL.VARCHAR2S;

1292: l_subSelect varchar2(100);
1293: l_subFrom varchar2(400);
1294: l_subWhere varchar2(1000);
1295:
1296: x_sqlSubSql DBMS_SQL.VARCHAR2S;
1297: sqlSubSql_index PLS_INTEGER := 0;
1298:
1299: -- End Following are variable declaration used by new code
1300:

Line 1889: x_sql_statement IN OUT NOCOPY DBMS_SQL.VARCHAR2S

1885: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
1886:
1887: p_days IN NUMBER,
1888:
1889: x_sql_statement IN OUT NOCOPY DBMS_SQL.VARCHAR2S
1890:
1891: )
1892:
1893: IS

Line 2177: x_sql_statement IN OUT NOCOPY DBMS_SQL.VARCHAR2S

2173: p_excluded_flag IN VARCHAR2,
2174:
2175: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
2176:
2177: x_sql_statement IN OUT NOCOPY DBMS_SQL.VARCHAR2S
2178:
2179: )
2180:
2181: IS

Line 2614: x_sql_statement IN OUT NOCOPY DBMS_SQL.VARCHAR2S

2610: p_excluded_flag IN VARCHAR2,
2611:
2612: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
2613:
2614: x_sql_statement IN OUT NOCOPY DBMS_SQL.VARCHAR2S
2615:
2616: )
2617:
2618: IS

Line 3000: x_sql_statement IN OUT NOCOPY DBMS_SQL.VARCHAR2S

2996: p_excluded_flag IN VARCHAR2,
2997:
2998: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
2999:
3000: x_sql_statement IN OUT NOCOPY DBMS_SQL.VARCHAR2S
3001:
3002: )
3003:
3004: IS

Line 3362: x_sql_statement IN OUT NOCOPY DBMS_SQL.VARCHAR2S

3358: p_excluded_flag IN VARCHAR2,
3359:
3360: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
3361:
3362: x_sql_statement IN OUT NOCOPY DBMS_SQL.VARCHAR2S
3363:
3364: )
3365:
3366: IS

Line 4140: PROCEDURE insert_temp_ids(p_stmt IN OUT NOCOPY DBMS_SQL.VARCHAR2S,

4136: --
4137:
4138: --------------------------------------------------------------------------------
4139:
4140: PROCEDURE insert_temp_ids(p_stmt IN OUT NOCOPY DBMS_SQL.VARCHAR2S,
4141:
4142: p_start_index IN PLS_INTEGER,
4143:
4144: p_end_index IN PLS_INTEGER,

Line 4206: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

4202:
4203:
4204: -- prepare a cursor for getting the results
4205:
4206: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
4207:
4208:
4209:
4210: -- parse dbms sql

Line 4210: -- parse dbms sql

4206: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
4207:
4208:
4209:
4210: -- parse dbms sql
4211:
4212: DBMS_SQL.PARSE( l_cursor_id, -- Cursor identifier
4213:
4214: p_stmt, -- SQL statement in VARCHAR2S table

Line 4212: DBMS_SQL.PARSE( l_cursor_id, -- Cursor identifier

4208:
4209:
4210: -- parse dbms sql
4211:
4212: DBMS_SQL.PARSE( l_cursor_id, -- Cursor identifier
4213:
4214: p_stmt, -- SQL statement in VARCHAR2S table
4215:
4216: p_start_index-1, -- Index to first row of statement

Line 4222: DBMS_SQL.NATIVE);

4218: p_end_index-1, -- Index to last row of statement
4219:
4220: TRUE, -- Insert linefeed for each row
4221:
4222: DBMS_SQL.NATIVE);
4223:
4224:
4225:
4226: -- execute dbms_sql

Line 4226: -- execute dbms_sql

4222: DBMS_SQL.NATIVE);
4223:
4224:
4225:
4226: -- execute dbms_sql
4227:
4228: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor_id);
4229:
4230: --DBMS_OUTPUT.PUT_LINE('# Rows Executed:' || l_rows_processed);

Line 4228: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor_id);

4224:
4225:
4226: -- execute dbms_sql
4227:
4228: l_rows_processed := DBMS_SQL.EXECUTE(l_cursor_id);
4229:
4230: --DBMS_OUTPUT.PUT_LINE('# Rows Executed:' || l_rows_processed);
4231:
4232:

Line 4236: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

4232:
4233:
4234: -- close cursor
4235:
4236: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
4237:
4238:
4239:
4240: x_status := FND_API.G_TRUE;

Line 4820: x_chan_sql_stmt OUT NOCOPY DBMS_SQL.VARCHAR2S,

4816: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
4817:
4818: p_index IN OUT NOCOPY PLS_INTEGER,
4819:
4820: x_chan_sql_stmt OUT NOCOPY DBMS_SQL.VARCHAR2S,
4821:
4822: x_chan_sql_status OUT NOCOPY VARCHAR2)
4823:
4824: IS

Line 5098: x_item_sql_stmt OUT NOCOPY DBMS_SQL.VARCHAR2S,

5094: p_external_contents IN VARCHAR2,
5095:
5096: p_index IN OUT NOCOPY PLS_INTEGER,
5097:
5098: x_item_sql_stmt OUT NOCOPY DBMS_SQL.VARCHAR2S,
5099:
5100: x_item_sql_status OUT NOCOPY VARCHAR2)
5101:
5102: IS

Line 5876: l_chan_sql_stmt DBMS_SQL.VARCHAR2S;

5872: l_item_insert_status varchar2(1);
5873:
5874:
5875:
5876: l_chan_sql_stmt DBMS_SQL.VARCHAR2S;
5877:
5878: l_item_sql_stmt DBMS_SQL.VARCHAR2S;
5879:
5880: l_start_index PLS_INTEGER := 2;

Line 5878: l_item_sql_stmt DBMS_SQL.VARCHAR2S;

5874:
5875:
5876: l_chan_sql_stmt DBMS_SQL.VARCHAR2S;
5877:
5878: l_item_sql_stmt DBMS_SQL.VARCHAR2S;
5879:
5880: l_start_index PLS_INTEGER := 2;
5881:
5882: l_index PLS_INTEGER := 2;