APPS.AMV_SEARCH_PVT dependencies on FND_API

Line 205: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,

201: p_application_id IN NUMBER,
202:
203: p_days IN NUMBER,
204:
205: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
206:
207: p_optional_array IN AMV_CHAR_VARRAY_TYPE,
208:
209: p_required_array IN AMV_CHAR_VARRAY_TYPE,

Line 225: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

221: p_table_name IN VARCHAR2,
222:
223: p_where_column IN VARCHAR2,
224:
225: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
226:
227: p_days IN NUMBER,
228:
229: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

Line 229: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

225: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
226:
227: p_days IN NUMBER,
228:
229: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
230:
231: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
232:
233: p_search_level IN VARCHAR2,

Line 231: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,

227: p_days IN NUMBER,
228:
229: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
230:
231: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
232:
233: p_search_level IN VARCHAR2,
234:
235: p_optional_array IN AMV_CHAR_VARRAY_TYPE,

Line 289: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,

285: p_application_id IN NUMBER,
286:
287: p_excluded_flag IN VARCHAR2,
288:
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

Line 305: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

301: p_index IN OUT NOCOPY PLS_INTEGER,
302:
303: p_imt_string IN VARCHAR2,
304:
305: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
306:
307: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
308:
309: p_days IN NUMBER,

Line 307: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,

303: p_imt_string IN VARCHAR2,
304:
305: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
306:
307: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
308:
309: p_days IN NUMBER,
310:
311: p_search_level IN VARCHAR2,

Line 315: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

311: p_search_level IN VARCHAR2,
312:
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: );

Line 329: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

325: p_index IN OUT NOCOPY PLS_INTEGER,
326:
327: p_imt_string IN VARCHAR2,
328:
329: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
330:
331: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
332:
333: p_days IN NUMBER,

Line 331: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,

327: p_imt_string IN VARCHAR2,
328:
329: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
330:
331: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
332:
333: p_days IN NUMBER,
334:
335: p_search_level IN VARCHAR2,

Line 339: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

335: p_search_level IN VARCHAR2,
336:
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: );

Line 353: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

349: p_index IN OUT NOCOPY PLS_INTEGER,
350:
351: p_imt_string IN VARCHAR2,
352:
353: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
354:
355: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
356:
357: p_days IN NUMBER,

Line 355: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,

351: p_imt_string IN VARCHAR2,
352:
353: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
354:
355: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
356:
357: p_days IN NUMBER,
358:
359: p_search_level IN VARCHAR2,

Line 363: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

359: p_search_level IN VARCHAR2,
360:
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: );

Line 377: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

373: p_index IN OUT NOCOPY PLS_INTEGER,
374:
375: p_imt_string IN VARCHAR2,
376:
377: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
378:
379: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
380:
381: p_days IN NUMBER,

Line 379: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,

375: p_imt_string IN VARCHAR2,
376:
377: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
378:
379: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
380:
381: p_days IN NUMBER,
382:
383: p_search_level IN VARCHAR2,

Line 387: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

383: p_search_level IN VARCHAR2,
384:
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: );

Line 453: p_keywords_search IN VARCHAR2 := FND_API.G_TRUE,

449: p_required_array IN AMV_CHAR_VARRAY_TYPE,
450:
451: p_excluded_array IN AMV_CHAR_VARRAY_TYPE,
452:
453: p_keywords_search IN VARCHAR2 := FND_API.G_TRUE,
454:
455: p_excluded_flag IN VARCHAR2 := FND_API.G_FALSE,
456:
457: p_application_id IN NUMBER,

Line 455: p_excluded_flag IN VARCHAR2 := FND_API.G_FALSE,

451: p_excluded_array IN AMV_CHAR_VARRAY_TYPE,
452:
453: p_keywords_search IN VARCHAR2 := FND_API.G_TRUE,
454:
455: p_excluded_flag IN VARCHAR2 := FND_API.G_FALSE,
456:
457: p_application_id IN NUMBER,
458:
459: p_days IN NUMBER,

Line 461: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,

457: p_application_id IN NUMBER,
458:
459: p_days IN NUMBER,
460:
461: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
462:
463: p_search_level IN VARCHAR2 := G_CHANNEL,
464:
465: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

Line 465: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

461: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
462:
463: p_search_level IN VARCHAR2 := G_CHANNEL,
464:
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,

Line 485: p_keywords_search IN VARCHAR2 := FND_API.G_TRUE,

481: p_required_array IN AMV_CHAR_VARRAY_TYPE,
482:
483: p_excluded_array IN AMV_CHAR_VARRAY_TYPE,
484:
485: p_keywords_search IN VARCHAR2 := FND_API.G_TRUE,
486:
487: p_excluded_flag IN VARCHAR2 := FND_API.G_FALSE,
488:
489: p_imt_string IN VARCHAR2,

Line 487: p_excluded_flag IN VARCHAR2 := FND_API.G_FALSE,

483: p_excluded_array IN AMV_CHAR_VARRAY_TYPE,
484:
485: p_keywords_search IN VARCHAR2 := FND_API.G_TRUE,
486:
487: p_excluded_flag IN VARCHAR2 := FND_API.G_FALSE,
488:
489: p_imt_string IN VARCHAR2,
490:
491: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

Line 491: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

487: p_excluded_flag IN VARCHAR2 := FND_API.G_FALSE,
488:
489: p_imt_string IN VARCHAR2,
490:
491: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
492:
493: p_days IN NUMBER,
494:
495: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,

Line 495: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,

491: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
492:
493: p_days IN NUMBER,
494:
495: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
496:
497: p_search_level IN VARCHAR2,
498:
499: p_external_contents IN VARCHAR2,

Line 745: x_keywords_search := FND_API.G_TRUE;

741: END IF;
742:
743: END LOOP;
744:
745: x_keywords_search := FND_API.G_TRUE;
746:
747: ELSE
748:
749: x_keywords_search := FND_API.G_FALSE;

Line 749: x_keywords_search := FND_API.G_FALSE;

745: x_keywords_search := FND_API.G_TRUE;
746:
747: ELSE
748:
749: x_keywords_search := FND_API.G_FALSE;
750:
751: END IF;
752:
753: --DBMS_OUTPUT.PUT_LINE('Exit : parse_parameter_array');

Line 857: x_exc_flag := FND_API.G_FALSE;

853: x_imt_string := x_imt_string|| l_req_string;
854:
855: end if;
856:
857: x_exc_flag := FND_API.G_FALSE;
858:
859: else
860:
861: if l_opt_string is not null then

Line 865: x_exc_flag := FND_API.G_FALSE;

861: if l_opt_string is not null then
862:
863: x_imt_string := x_imt_string|| l_opt_string;
864:
865: x_exc_flag := FND_API.G_FALSE;
866:
867: end if;
868:
869: end if;

Line 881: x_exc_flag := FND_API.G_TRUE;

877: if x_imt_string is null then
878:
879: x_imt_string := x_imt_string || '(' ;
880:
881: x_exc_flag := FND_API.G_TRUE;
882:
883: else
884:
885: x_imt_string := x_imt_string || ' ~ (' ;

Line 887: x_exc_flag := FND_API.G_FALSE;

883: else
884:
885: x_imt_string := x_imt_string || ' ~ (' ;
886:
887: x_exc_flag := FND_API.G_FALSE;
888:
889: end if;
890:
891:

Line 937: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,

933: p_application_id IN NUMBER,
934:
935: p_days IN NUMBER,
936:
937: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
938:
939: p_optional_array IN AMV_CHAR_VARRAY_TYPE,
940:
941: p_required_array IN AMV_CHAR_VARRAY_TYPE,

Line 997: IF p_include_chns = FND_API.G_TRUE THEN

993: l_from := ' FROM '|| p_table_name ||' a ';
994:
995: l_from := l_from || ' , amv_c_channels_vl b ';
996:
997: IF p_include_chns = FND_API.G_TRUE THEN
998:
999: l_from := l_from || ' , amv_temp_numbers id ';
1000:
1001: END IF;

Line 1017: IF p_include_chns = FND_API.G_TRUE THEN

1013: l_where := l_where || ' and a.last_update_date >= (sysdate - ' || p_days || ' )';
1014:
1015: END IF;
1016:
1017: IF p_include_chns = FND_API.G_TRUE THEN
1018:
1019: l_where := l_where || ' AND b.channel_id = id.number_value ';
1020:
1021: END IF;

Line 1233: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

1229: p_table_name IN VARCHAR2,
1230:
1231: p_where_column IN VARCHAR2,
1232:
1233: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1234:
1235: p_days IN NUMBER,
1236:
1237: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

Line 1237: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

1233: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1234:
1235: p_days IN NUMBER,
1236:
1237: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
1238:
1239: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
1240:
1241: p_search_level IN VARCHAR2,

Line 1239: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,

1235: p_days IN NUMBER,
1236:
1237: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
1238:
1239: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
1240:
1241: p_search_level IN VARCHAR2,
1242:
1243: p_optional_array IN AMV_CHAR_VARRAY_TYPE,

Line 1371: IF p_include_chns = FND_API.G_TRUE THEN

1367:
1368: ' , jtf_amv_items_b b ';
1369:
1370: --ss
1371: IF p_include_chns = FND_API.G_TRUE THEN
1372:
1373: --Commented for new SQL
1374: --l_from := l_from || ' , amv_c_chl_item_match cim ';
1375:

Line 1423: IF p_application_id <> FND_API.G_MISS_NUM THEN

1419:
1420:
1421:
1422:
1423: IF p_application_id <> FND_API.G_MISS_NUM THEN
1424:
1425: --commented for new sql code
1426: --l_where := l_where || ' AND b.application_id = ' || p_application_id;
1427:

Line 1437: IF p_external_contents <> FND_API.G_FALSE THEN

1433: END IF;
1434:
1435:
1436:
1437: IF p_external_contents <> FND_API.G_FALSE THEN
1438:
1439: ----commented for new sql code
1440: --l_where := l_where || ' AND b.external_access_flag = ''' ||
1441:

Line 1455: IF p_include_chns = FND_API.G_TRUE THEN

1451: END IF;
1452:
1453:
1454:
1455: IF p_include_chns = FND_API.G_TRUE THEN
1456:
1457: --commented for new sql code
1458: --l_where1 := l_where1 || ' AND b.item_id = cim.item_id ';
1459:

Line 1563: --IF p_include_chns = FND_API.G_TRUE THEN

1559:
1560:
1561: --commented for new sql code
1562:
1563: --IF p_include_chns = FND_API.G_TRUE THEN
1564:
1565: --x_sql_statement(p_index) := l_where1;
1566:
1567: --p_index := p_index + 1;

Line 1719: --IF p_include_chns = FND_API.G_TRUE THEN

1715:
1716: --p_index := p_index + 1;
1717:
1718:
1719: --IF p_include_chns = FND_API.G_TRUE THEN
1720:
1721: --x_sql_statement(p_index) := l_where1;
1722:
1723: --p_index := p_index + 1;

Line 1885: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,

1881: p_application_id IN NUMBER,
1882:
1883: p_excluded_flag IN VARCHAR2,
1884:
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

Line 1935: IF p_include_chns = FND_API.G_TRUE THEN

1931: x_sql_statement(p_index) := ' from amv_c_channels_vl b ';
1932:
1933: p_index := p_index + 1;
1934:
1935: IF p_include_chns = FND_API.G_TRUE THEN
1936:
1937: x_sql_statement(p_index) := ' , amv_temp_numbers id ';
1938:
1939: p_index := p_index + 1;

Line 1945: IF p_excluded_flag = FND_API.G_TRUE THEN

1941: END IF;
1942:
1943:
1944:
1945: IF p_excluded_flag = FND_API.G_TRUE THEN
1946:
1947: x_sql_statement(p_index) := ' where ( contains( b.channel_name,';
1948:
1949: p_index := p_index + 1;

Line 2109: IF p_include_chns = FND_API.G_TRUE THEN

2105: x_sql_statement(p_index) := ' and b.application_id = ' || p_application_id;
2106:
2107: p_index := p_index + 1;
2108:
2109: IF p_include_chns = FND_API.G_TRUE THEN
2110:
2111: x_sql_statement(p_index) := ' and b.channel_id = id.number_value';
2112:
2113: p_index := p_index + 1;

Line 2165: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

2161: p_index IN OUT NOCOPY PLS_INTEGER,
2162:
2163: p_imt_string IN VARCHAR2,
2164:
2165: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
2166:
2167: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
2168:
2169: p_days IN NUMBER,

Line 2167: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,

2163: p_imt_string IN VARCHAR2,
2164:
2165: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
2166:
2167: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
2168:
2169: p_days IN NUMBER,
2170:
2171: p_search_level IN VARCHAR2,

Line 2175: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

2171: p_search_level IN VARCHAR2,
2172:
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: )

Line 2302: IF p_include_chns = FND_API.G_TRUE THEN

2298: x_sql_statement(p_index) := ' from jtf_amv_items_vl b ';
2299:
2300: p_index := p_index + 1;
2301:
2302: IF p_include_chns = FND_API.G_TRUE THEN
2303:
2304: x_sql_statement(p_index) := ' , amv_c_chl_item_match cim ';
2305:
2306: p_index := p_index + 1;

Line 2314: IF p_excluded_flag = FND_API.G_TRUE THEN

2310: p_index := p_index + 1;
2311:
2312: END IF;
2313:
2314: IF p_excluded_flag = FND_API.G_TRUE THEN
2315:
2316: x_sql_statement(p_index) := ' where (contains( b.item_name, ';
2317:
2318: p_index := p_index + 1;

Line 2474: IF p_application_id <> FND_API.G_MISS_NUM THEN

2470:
2471:
2472: END IF;
2473:
2474: IF p_application_id <> FND_API.G_MISS_NUM THEN
2475:
2476: x_sql_statement(p_index) :=
2477:
2478: ' and b.application_id = ' || p_application_id;

Line 2484: IF p_external_contents <> FND_API.G_FALSE THEN

2480: p_index := p_index + 1;
2481:
2482: END IF;
2483:
2484: IF p_external_contents <> FND_API.G_FALSE THEN
2485:
2486: x_sql_statement(p_index) :=
2487:
2488: ' and b.external_access_flag = '''|| p_external_contents ||'''';

Line 2516: IF p_include_chns = FND_API.G_TRUE THEN

2512: p_index := p_index + 1;
2513:
2514: END IF;
2515:
2516: IF p_include_chns = FND_API.G_TRUE THEN
2517:
2518: x_sql_statement(p_index) := ' and b.item_id = cim.item_id';
2519:
2520: p_index := p_index + 1;

Line 2602: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

2598: p_index IN OUT NOCOPY PLS_INTEGER,
2599:
2600: p_imt_string IN VARCHAR2,
2601:
2602: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
2603:
2604: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
2605:
2606: p_days IN NUMBER,

Line 2604: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,

2600: p_imt_string IN VARCHAR2,
2601:
2602: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
2603:
2604: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
2605:
2606: p_days IN NUMBER,
2607:
2608: p_search_level IN VARCHAR2,

Line 2612: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

2608: p_search_level IN VARCHAR2,
2609:
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: )

Line 2750: IF p_include_chns = FND_API.G_TRUE THEN

2746: x_sql_statement(p_index) := ' , fnd_lobs fl ';
2747:
2748: p_index := p_index + 1;
2749:
2750: IF p_include_chns = FND_API.G_TRUE THEN
2751:
2752: x_sql_statement(p_index) := ' , amv_c_chl_item_match cim ';
2753:
2754: p_index := p_index + 1;

Line 2766: IF p_excluded_flag = FND_API.G_TRUE THEN

2762: --p_index := p_index + 1;
2763:
2764: END IF;
2765:
2766: IF p_excluded_flag = FND_API.G_TRUE THEN
2767:
2768: x_sql_statement(p_index) := ' where contains(fl.file_data, ';
2769:
2770: p_index := p_index + 1;

Line 2848: IF p_application_id <> FND_API.G_MISS_NUM THEN

2844:
2845:
2846: END IF;
2847:
2848: IF p_application_id <> FND_API.G_MISS_NUM THEN
2849:
2850: x_sql_statement(p_index) :=
2851:
2852: ' and b.application_id = ' || p_application_id;

Line 2858: IF p_external_contents <> FND_API.G_FALSE THEN

2854: p_index := p_index + 1;
2855:
2856: END IF;
2857:
2858: IF p_external_contents <> FND_API.G_FALSE THEN
2859:
2860: x_sql_statement(p_index) :=
2861:
2862: ' and b.external_access_flag = '''|| p_external_contents ||'''';

Line 2906: IF p_include_chns = FND_API.G_TRUE THEN

2902: x_sql_statement(p_index) := ' and a.file_id = fl.file_id ';
2903:
2904: p_index := p_index + 1;
2905:
2906: IF p_include_chns = FND_API.G_TRUE THEN
2907:
2908: x_sql_statement(p_index) := ' and b.item_id = cim.item_id';
2909:
2910: p_index := p_index + 1;

Line 2988: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

2984: p_index IN OUT NOCOPY PLS_INTEGER,
2985:
2986: p_imt_string IN VARCHAR2,
2987:
2988: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
2989:
2990: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
2991:
2992: p_days IN NUMBER,

Line 2990: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,

2986: p_imt_string IN VARCHAR2,
2987:
2988: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
2989:
2990: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
2991:
2992: p_days IN NUMBER,
2993:
2994: p_search_level IN VARCHAR2,

Line 2998: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

2994: p_search_level IN VARCHAR2,
2995:
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: )

Line 3130: IF p_include_chns = FND_API.G_TRUE THEN

3126: x_sql_statement(p_index) := ' from jtf_amv_items_vl b ';
3127:
3128: p_index := p_index + 1;
3129:
3130: IF p_include_chns = FND_API.G_TRUE THEN
3131:
3132: x_sql_statement(p_index) := ' , amv_c_chl_item_match cim ';
3133:
3134: p_index := p_index + 1;

Line 3144: IF p_excluded_flag = FND_API.G_TRUE THEN

3140: --p_index := p_index + 1;
3141:
3142: END IF;
3143:
3144: IF p_excluded_flag = FND_API.G_TRUE THEN
3145:
3146: x_sql_statement(p_index) := ' where contains(b.text_string, ';
3147:
3148: p_index := p_index + 1;

Line 3226: IF p_application_id <> FND_API.G_MISS_NUM THEN

3222:
3223:
3224: END IF;
3225:
3226: IF p_application_id <> FND_API.G_MISS_NUM THEN
3227:
3228: x_sql_statement(p_index) :=
3229:
3230: ' and b.application_id = ' || p_application_id;

Line 3236: IF p_external_contents <> FND_API.G_FALSE THEN

3232: p_index := p_index + 1;
3233:
3234: END IF;
3235:
3236: IF p_external_contents <> FND_API.G_FALSE THEN
3237:
3238: x_sql_statement(p_index) :=
3239:
3240: ' and b.external_access_flag = '''|| p_external_contents ||'''';

Line 3268: IF p_include_chns = FND_API.G_TRUE THEN

3264: p_index := p_index + 1;
3265:
3266: END IF;
3267:
3268: IF p_include_chns = FND_API.G_TRUE THEN
3269:
3270: x_sql_statement(p_index) := ' and b.item_id = cim.item_id';
3271:
3272: p_index := p_index + 1;

Line 3350: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

3346: p_index IN OUT NOCOPY PLS_INTEGER,
3347:
3348: p_imt_string IN VARCHAR2,
3349:
3350: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
3351:
3352: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
3353:
3354: p_days IN NUMBER,

Line 3352: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,

3348: p_imt_string IN VARCHAR2,
3349:
3350: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
3351:
3352: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
3353:
3354: p_days IN NUMBER,
3355:
3356: p_search_level IN VARCHAR2,

Line 3360: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

3356: p_search_level IN VARCHAR2,
3357:
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: )

Line 3492: IF p_include_chns = FND_API.G_TRUE THEN

3488: x_sql_statement(p_index) := ' from jtf_amv_items_vl b ';
3489:
3490: p_index := p_index + 1;
3491:
3492: IF p_include_chns = FND_API.G_TRUE THEN
3493:
3494: x_sql_statement(p_index) := ' , amv_c_chl_item_match cim ';
3495:
3496: p_index := p_index + 1;

Line 3506: IF p_excluded_flag = FND_API.G_TRUE THEN

3502: --p_index := p_index + 1;
3503:
3504: END IF;
3505:
3506: IF p_excluded_flag = FND_API.G_TRUE THEN
3507:
3508: x_sql_statement(p_index) := ' where contains(b.url_string, ';
3509:
3510: p_index := p_index + 1;

Line 3588: IF p_application_id <> FND_API.G_MISS_NUM THEN

3584:
3585:
3586: END IF;
3587:
3588: IF p_application_id <> FND_API.G_MISS_NUM THEN
3589:
3590: x_sql_statement(p_index) :=
3591:
3592: ' and b.application_id = ' || p_application_id;

Line 3598: IF p_external_contents <> FND_API.G_FALSE THEN

3594: p_index := p_index + 1;
3595:
3596: END IF;
3597:
3598: IF p_external_contents <> FND_API.G_FALSE THEN
3599:
3600: x_sql_statement(p_index) :=
3601:
3602: ' and b.external_access_flag = '''|| p_external_contents ||'''';

Line 3630: IF p_include_chns = FND_API.G_TRUE THEN

3626: p_index := p_index + 1;
3627:
3628: END IF;
3629:
3630: IF p_include_chns = FND_API.G_TRUE THEN
3631:
3632: x_sql_statement(p_index) := ' and b.item_id = cim.item_id';
3633:
3634: p_index := p_index + 1;

Line 3968: IF p_include_subcats = FND_API.G_FALSE THEN

3964: FOR i in 1..l_category_id.count LOOP
3965:
3966: IF AMV_UTILITY_PVT.Is_CategoryIdValid(l_category_id(i)) THEN
3967:
3968: IF p_include_subcats = FND_API.G_FALSE THEN
3969:
3970: l_cat_count := l_cat_count + 1;
3971:
3972: x_category_array.extend;

Line 3982: P_INIT_MSG_LIST => FND_API.G_FALSE,

3978: AMV_CATEGORY_PVT.Get_CatChildrenHierarchy(
3979:
3980: P_API_VERSION => l_api_version,
3981:
3982: P_INIT_MSG_LIST => FND_API.G_FALSE,
3983:
3984: P_VALIDATION_LEVEL => l_validation_level,
3985:
3986: X_RETURN_STATUS => l_return_status,

Line 3992: P_CHECK_LOGIN_USER => FND_API.G_FALSE,

3988: X_MSG_COUNT => l_msg_count,
3989:
3990: X_MSG_DATA => l_msg_data,
3991:
3992: P_CHECK_LOGIN_USER => FND_API.G_FALSE,
3993:
3994: P_CATEGORY_ID => l_category_id(i),
3995:
3996: X_CATEGORY_HIERARCHY => l_categoryhr_array );

Line 4018: P_INIT_MSG_LIST => FND_API.G_FALSE,

4014: AMV_CATEGORY_PVT.Get_ChannelsPerCategory(
4015:
4016: P_API_VERSION => l_api_version,
4017:
4018: P_INIT_MSG_LIST => FND_API.G_FALSE,
4019:
4020: P_VALIDATION_LEVEL => l_validation_level,
4021:
4022: X_RETURN_STATUS => l_return_status,

Line 4028: P_CHECK_LOGIN_USER => FND_API.G_FALSE,

4024: X_MSG_COUNT => l_msg_count,
4025:
4026: X_MSG_DATA => l_msg_data,
4027:
4028: P_CHECK_LOGIN_USER => FND_API.G_FALSE,
4029:
4030: P_CATEGORY_ID => l_category_id(i),
4031:
4032: P_INCLUDE_SUBCATS => p_include_subcats,

Line 4118: x_status := FND_API.G_TRUE;

4114: END LOOP;
4115:
4116:
4117:
4118: x_status := FND_API.G_TRUE;
4119:
4120: --
4121:
4122: --DBMS_OUTPUT.PUT_LINE('Exit : insert_temp_numbers' );

Line 4128: x_status := FND_API.G_FALSE;

4124: EXCEPTION
4125:
4126: WHEN OTHERS THEN
4127:
4128: x_status := FND_API.G_FALSE;
4129:
4130: --DBMS_OUTPUT.PUT_LINE('Others : insert_temp_numbers' );
4131:
4132: --RAISE;

Line 4240: x_status := FND_API.G_TRUE;

4236: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
4237:
4238:
4239:
4240: x_status := FND_API.G_TRUE;
4241:
4242: --DBMS_OUTPUT.PUT_LINE('Exit : insert_temp_ids' );
4243:
4244: EXCEPTION

Line 4250: x_status := FND_API.G_FALSE;

4246:
4247:
4248: WHEN OTHERS THEN
4249:
4250: x_status := FND_API.G_FALSE;
4251:
4252: --DBMS_OUTPUT.PUT_LINE('Others : insert_temp_ids' );
4253:
4254: --DBMS_OUTPUT.PUT_LINE('Exception : insert_temp_ids' );

Line 4804: p_keywords_search IN VARCHAR2 := FND_API.G_TRUE,

4800: p_required_array IN AMV_CHAR_VARRAY_TYPE,
4801:
4802: p_excluded_array IN AMV_CHAR_VARRAY_TYPE,
4803:
4804: p_keywords_search IN VARCHAR2 := FND_API.G_TRUE,
4805:
4806: p_excluded_flag IN VARCHAR2 := FND_API.G_FALSE,
4807:
4808: p_application_id IN NUMBER,

Line 4806: p_excluded_flag IN VARCHAR2 := FND_API.G_FALSE,

4802: p_excluded_array IN AMV_CHAR_VARRAY_TYPE,
4803:
4804: p_keywords_search IN VARCHAR2 := FND_API.G_TRUE,
4805:
4806: p_excluded_flag IN VARCHAR2 := FND_API.G_FALSE,
4807:
4808: p_application_id IN NUMBER,
4809:
4810: p_days IN NUMBER,

Line 4812: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,

4808: p_application_id IN NUMBER,
4809:
4810: p_days IN NUMBER,
4811:
4812: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
4813:
4814: p_search_level IN VARCHAR2 := G_CHANNEL,
4815:
4816: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

Line 4816: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

4812: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
4813:
4814: p_search_level IN VARCHAR2 := G_CHANNEL,
4815:
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,

Line 4848: IF p_include_chns = FND_API.G_FALSE THEN

4844:
4845:
4846: --DBMS_OUTPUT.PUT_LINE('Enter : build_channel_stmt' );
4847:
4848: IF p_include_chns = FND_API.G_FALSE THEN
4849:
4850: l_search_level := FND_API.G_MISS_CHAR;
4851:
4852: ELSE

Line 4850: l_search_level := FND_API.G_MISS_CHAR;

4846: --DBMS_OUTPUT.PUT_LINE('Enter : build_channel_stmt' );
4847:
4848: IF p_include_chns = FND_API.G_FALSE THEN
4849:
4850: l_search_level := FND_API.G_MISS_CHAR;
4851:
4852: ELSE
4853:
4854: l_search_level := p_search_level;

Line 4884: IF p_keywords_search = FND_API.G_TRUE THEN

4880:
4881:
4882: IF p_content_array(i) = G_AUTHOR THEN
4883:
4884: IF p_keywords_search = FND_API.G_TRUE THEN
4885:
4886: --l_index := p_index;
4887:
4888: get_chan_attr_stmt(

Line 4946: IF p_keywords_search = FND_API.G_TRUE THEN

4942: ELSIF p_content_array(i) = G_KEYWORD THEN
4943:
4944: -- build sql statement for keywords
4945:
4946: IF p_keywords_search = FND_API.G_TRUE THEN
4947:
4948: --l_index := p_index;
4949:
4950: get_chan_attr_stmt(

Line 5052: x_chan_sql_status := FND_API.G_TRUE;

5048:
5049:
5050:
5051:
5052: x_chan_sql_status := FND_API.G_TRUE;
5053:
5054: --DBMS_OUTPUT.PUT_LINE('Exit : build_channel_stmt' );
5055:
5056: EXCEPTION

Line 5060: x_chan_sql_status := FND_API.G_FALSE;

5056: EXCEPTION
5057:
5058: WHEN OTHERS THEN
5059:
5060: x_chan_sql_status := FND_API.G_FALSE;
5061:
5062: --DBMS_OUTPUT.PUT_LINE('Others : build_channel_stmt' );
5063:
5064: --RAISE;

Line 5080: p_keywords_search IN VARCHAR2 := FND_API.G_TRUE,

5076: p_required_array IN AMV_CHAR_VARRAY_TYPE,
5077:
5078: p_excluded_array IN AMV_CHAR_VARRAY_TYPE,
5079:
5080: p_keywords_search IN VARCHAR2 := FND_API.G_TRUE,
5081:
5082: p_excluded_flag IN VARCHAR2 := FND_API.G_FALSE,
5083:
5084: p_imt_string IN VARCHAR2,

Line 5082: p_excluded_flag IN VARCHAR2 := FND_API.G_FALSE,

5078: p_excluded_array IN AMV_CHAR_VARRAY_TYPE,
5079:
5080: p_keywords_search IN VARCHAR2 := FND_API.G_TRUE,
5081:
5082: p_excluded_flag IN VARCHAR2 := FND_API.G_FALSE,
5083:
5084: p_imt_string IN VARCHAR2,
5085:
5086: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

Line 5086: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

5082: p_excluded_flag IN VARCHAR2 := FND_API.G_FALSE,
5083:
5084: p_imt_string IN VARCHAR2,
5085:
5086: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
5087:
5088: p_days IN NUMBER,
5089:
5090: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,

Line 5090: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,

5086: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
5087:
5088: p_days IN NUMBER,
5089:
5090: p_include_chns IN VARCHAR2 := FND_API.G_TRUE,
5091:
5092: p_search_level IN VARCHAR2,
5093:
5094: p_external_contents IN VARCHAR2,

Line 5126: IF p_include_chns = FND_API.G_FALSE THEN

5122: BEGIN
5123:
5124: --DBMS_OUTPUT.PUT_LINE('Enter : build_item_stmt' );
5125:
5126: IF p_include_chns = FND_API.G_FALSE THEN
5127:
5128: l_search_level := FND_API.G_MISS_CHAR;
5129:
5130: ELSE

Line 5128: l_search_level := FND_API.G_MISS_CHAR;

5124: --DBMS_OUTPUT.PUT_LINE('Enter : build_item_stmt' );
5125:
5126: IF p_include_chns = FND_API.G_FALSE THEN
5127:
5128: l_search_level := FND_API.G_MISS_CHAR;
5129:
5130: ELSE
5131:
5132: l_search_level := p_search_level;

Line 5156: IF p_keywords_search = FND_API.G_TRUE THEN

5152:
5153:
5154: IF p_content_array(i) = G_AUTHOR THEN
5155:
5156: IF p_keywords_search = FND_API.G_TRUE THEN
5157:
5158: -- build sql statement for authors in items
5159:
5160: --l_index := p_index;

Line 5174: p_external_contents => FND_API.G_FALSE,

5170: p_application_id => p_application_id,
5171:
5172: p_days => p_days,
5173:
5174: p_external_contents => FND_API.G_FALSE,
5175:
5176: p_include_chns => p_include_chns,
5177:
5178: p_search_level => l_search_level,

Line 5220: IF p_external_contents = FND_API.G_TRUE THEN

5216: END IF;
5217:
5218:
5219:
5220: IF p_external_contents = FND_API.G_TRUE THEN
5221:
5222: --l_index := p_index;
5223:
5224: get_item_attr_stmt(

Line 5230: p_application_id => FND_API.G_MISS_NUM,

5226: p_table_name => 'jtf_amv_item_authors',
5227:
5228: p_where_column => 'author',
5229:
5230: p_application_id => FND_API.G_MISS_NUM,
5231:
5232: p_days => p_days,
5233:
5234: p_external_contents => p_external_contents,

Line 5282: IF p_keywords_search = FND_API.G_TRUE THEN

5278: ELSIF p_content_array(i) = G_KEYWORD THEN
5279:
5280: -- build sql statement for keywords in items
5281:
5282: IF p_keywords_search = FND_API.G_TRUE THEN
5283:
5284: --l_index := p_index;
5285:
5286: get_item_attr_stmt(

Line 5296: p_external_contents => FND_API.G_FALSE,

5292: p_application_id => p_application_id,
5293:
5294: p_days => p_days,
5295:
5296: p_external_contents => FND_API.G_FALSE,
5297:
5298: p_include_chns => p_include_chns,
5299:
5300: p_search_level => l_search_level,

Line 5340: IF p_external_contents = FND_API.G_TRUE THEN

5336: END IF;
5337:
5338:
5339:
5340: IF p_external_contents = FND_API.G_TRUE THEN
5341:
5342: --l_index := p_index;
5343:
5344: get_item_attr_stmt(

Line 5350: p_application_id => FND_API.G_MISS_NUM,

5346: p_table_name => 'jtf_amv_item_keywords',
5347:
5348: p_where_column => 'keyword',
5349:
5350: p_application_id => FND_API.G_MISS_NUM,
5351:
5352: p_days => p_days,
5353:
5354: p_external_contents => p_external_contents,

Line 5420: p_external_contents => FND_API.G_FALSE,

5416: p_search_level => l_search_level,
5417:
5418: p_excluded_flag => p_excluded_flag,
5419:
5420: p_external_contents => FND_API.G_FALSE,
5421:
5422: x_sql_statement => x_item_sql_stmt);
5423:
5424:

Line 5454: IF p_external_contents = FND_API.G_TRUE THEN

5450:
5451:
5452:
5453:
5454: IF p_external_contents = FND_API.G_TRUE THEN
5455:
5456: build_items_name_sql(p_index => p_index,
5457:
5458: p_imt_string => p_imt_string,

Line 5460: p_application_id => FND_API.G_MISS_NUM,

5456: build_items_name_sql(p_index => p_index,
5457:
5458: p_imt_string => p_imt_string,
5459:
5460: p_application_id => FND_API.G_MISS_NUM,
5461:
5462: p_include_chns => p_include_chns,
5463:
5464: p_days => p_days,

Line 5520: p_external_contents => FND_API.G_FALSE,

5516: p_search_level => l_search_level,
5517:
5518: p_excluded_flag => p_excluded_flag,
5519:
5520: p_external_contents => FND_API.G_FALSE,
5521:
5522: x_sql_statement => x_item_sql_stmt);
5523:
5524:

Line 5552: IF p_external_contents = FND_API.G_TRUE THEN

5548:
5549:
5550:
5551:
5552: IF p_external_contents = FND_API.G_TRUE THEN
5553:
5554: build_items_file_sql(p_index => p_index,
5555:
5556: p_imt_string => p_imt_string,

Line 5558: p_application_id => FND_API.G_MISS_NUM,

5554: build_items_file_sql(p_index => p_index,
5555:
5556: p_imt_string => p_imt_string,
5557:
5558: p_application_id => FND_API.G_MISS_NUM,
5559:
5560: p_include_chns => p_include_chns,
5561:
5562: p_days => p_days,

Line 5620: p_external_contents => FND_API.G_FALSE,

5616: p_search_level => l_search_level,
5617:
5618: p_excluded_flag => p_excluded_flag,
5619:
5620: p_external_contents => FND_API.G_FALSE,
5621:
5622: x_sql_statement => x_item_sql_stmt);
5623:
5624:

Line 5650: IF p_external_contents = FND_API.G_TRUE THEN

5646: p_index := l_start_index;
5647:
5648:
5649:
5650: IF p_external_contents = FND_API.G_TRUE THEN
5651:
5652: build_items_text_sql(p_index => p_index,
5653:
5654: p_imt_string => p_imt_string,

Line 5656: p_application_id => FND_API.G_MISS_NUM,

5652: build_items_text_sql(p_index => p_index,
5653:
5654: p_imt_string => p_imt_string,
5655:
5656: p_application_id => FND_API.G_MISS_NUM,
5657:
5658: p_include_chns => p_include_chns,
5659:
5660: p_days => p_days,

Line 5716: p_external_contents => FND_API.G_FALSE,

5712: p_search_level => l_search_level,
5713:
5714: p_excluded_flag => p_excluded_flag,
5715:
5716: p_external_contents => FND_API.G_FALSE,
5717:
5718: x_sql_statement => x_item_sql_stmt);
5719:
5720:

Line 5744: IF p_external_contents = FND_API.G_TRUE THEN

5740: p_index := l_start_index;
5741:
5742:
5743:
5744: IF p_external_contents = FND_API.G_TRUE THEN
5745:
5746: build_items_url_sql(p_index => p_index,
5747:
5748: p_imt_string => p_imt_string,

Line 5750: p_application_id => FND_API.G_MISS_NUM,

5746: build_items_url_sql(p_index => p_index,
5747:
5748: p_imt_string => p_imt_string,
5749:
5750: p_application_id => FND_API.G_MISS_NUM,
5751:
5752: p_include_chns => p_include_chns,
5753:
5754: p_days => p_days,

Line 5804: x_item_sql_status := FND_API.G_TRUE;

5800:
5801:
5802:
5803:
5804: x_item_sql_status := FND_API.G_TRUE;
5805:
5806: --DBMS_OUTPUT.PUT_LINE('Exit : build_item_stmt' );
5807:
5808: EXCEPTION

Line 5812: x_item_sql_status := FND_API.G_FALSE;

5808: EXCEPTION
5809:
5810: WHEN OTHERS THEN
5811:
5812: x_item_sql_status := FND_API.G_FALSE;
5813:
5814: --DBMS_OUTPUT.PUT_LINE('Others : build_item_stmt' );
5815:
5816: --RAISE;

Line 5886: l_category_flag varchar2(1) := FND_API.G_FALSE;

5882: l_index PLS_INTEGER := 2;
5883:
5884:
5885:
5886: l_category_flag varchar2(1) := FND_API.G_FALSE;
5887:
5888: l_item_flag varchar2(1) := FND_API.G_FALSE;
5889:
5890: l_content_flag varchar2(1) := FND_API.G_FALSE;

Line 5888: l_item_flag varchar2(1) := FND_API.G_FALSE;

5884:
5885:
5886: l_category_flag varchar2(1) := FND_API.G_FALSE;
5887:
5888: l_item_flag varchar2(1) := FND_API.G_FALSE;
5889:
5890: l_content_flag varchar2(1) := FND_API.G_FALSE;
5891:
5892:

Line 5890: l_content_flag varchar2(1) := FND_API.G_FALSE;

5886: l_category_flag varchar2(1) := FND_API.G_FALSE;
5887:
5888: l_item_flag varchar2(1) := FND_API.G_FALSE;
5889:
5890: l_content_flag varchar2(1) := FND_API.G_FALSE;
5891:
5892:
5893:
5894: BEGIN

Line 5906: l_category_flag := FND_API.G_TRUE;

5902: FOR j in 1..p_area_array.count LOOP
5903:
5904: IF p_area_array(j) = G_CATEGORY THEN
5905:
5906: l_category_flag := FND_API.G_TRUE;
5907:
5908: ELSIF p_area_array(j) = G_ITEM THEN
5909:
5910: l_item_flag := FND_API.G_TRUE;

Line 5910: l_item_flag := FND_API.G_TRUE;

5906: l_category_flag := FND_API.G_TRUE;
5907:
5908: ELSIF p_area_array(j) = G_ITEM THEN
5909:
5910: l_item_flag := FND_API.G_TRUE;
5911:
5912: END IF;
5913:
5914: END LOOP;

Line 5920: IF l_category_flag = FND_API.G_TRUE THEN

5916:
5917:
5918: -- channels/categories search
5919:
5920: IF l_category_flag = FND_API.G_TRUE THEN
5921:
5922: -- no search on channel done at category level
5923:
5924: IF p_search_level <> G_CATEGORY THEN

Line 6006: IF l_item_flag = FND_API.G_TRUE THEN

6002:
6003:
6004: -- Items search
6005:
6006: IF l_item_flag = FND_API.G_TRUE THEN
6007:
6008: -- build sql statement for searching items
6009:
6010: l_index := l_start_index;

Line 6090: l_flag := FND_API.G_TRUE;

6086: WHEN OTHERS THEN
6087:
6088: --DBMS_OUTPUT.PUT_LINE('Others : search_items' );
6089:
6090: l_flag := FND_API.G_TRUE;
6091:
6092: --RAISE;
6093:
6094: END search_items;

Line 6252: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

6248: PROCEDURE find_repositories
6249:
6250: (p_api_version IN NUMBER,
6251:
6252: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6253:
6254: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6255:
6256: x_return_status OUT NOCOPY VARCHAR2,

Line 6254: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

6250: (p_api_version IN NUMBER,
6251:
6252: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6253:
6254: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6255:
6256: x_return_status OUT NOCOPY VARCHAR2,
6257:
6258: x_msg_count OUT NOCOPY NUMBER,

Line 6262: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

6258: x_msg_count OUT NOCOPY NUMBER,
6259:
6260: x_msg_data OUT NOCOPY VARCHAR2,
6261:
6262: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
6263:
6264: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
6265:
6266: p_repository_id IN NUMBER := FND_API.G_MISS_NUM,

Line 6264: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,

6260: x_msg_data OUT NOCOPY VARCHAR2,
6261:
6262: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
6263:
6264: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
6265:
6266: p_repository_id IN NUMBER := FND_API.G_MISS_NUM,
6267:
6268: p_repository_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 6266: p_repository_id IN NUMBER := FND_API.G_MISS_NUM,

6262: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
6263:
6264: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
6265:
6266: p_repository_id IN NUMBER := FND_API.G_MISS_NUM,
6267:
6268: p_repository_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
6269:
6270: p_repository_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 6268: p_repository_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

6264: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
6265:
6266: p_repository_id IN NUMBER := FND_API.G_MISS_NUM,
6267:
6268: p_repository_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
6269:
6270: p_repository_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
6271:
6272: p_status IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 6270: p_repository_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

6266: p_repository_id IN NUMBER := FND_API.G_MISS_NUM,
6267:
6268: p_repository_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
6269:
6270: p_repository_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
6271:
6272: p_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
6273:
6274: x_searchrep_array OUT NOCOPY amv_searchrep_varray_type)

Line 6272: p_status IN VARCHAR2 := FND_API.G_MISS_CHAR,

6268: p_repository_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
6269:
6270: p_repository_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
6271:
6272: p_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
6273:
6274: x_searchrep_array OUT NOCOPY amv_searchrep_varray_type)
6275:
6276: IS

Line 6332: IF NOT FND_API.Compatible_API_Call (

6328: SAVEPOINT Find_Repositories;
6329:
6330: -- Standard call to check for call compatibility.
6331:
6332: IF NOT FND_API.Compatible_API_Call (
6333:
6334: l_api_version,
6335:
6336: p_api_version,

Line 6344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6340: G_PKG_NAME)
6341:
6342: THEN
6343:
6344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6345:
6346: END IF;
6347:
6348: -- Debug Message

Line 6362: IF FND_API.To_Boolean (p_init_msg_list) THEN

6358: END IF;
6359:
6360: --Initialize message list if p_init_msg_list is TRUE.
6361:
6362: IF FND_API.To_Boolean (p_init_msg_list) THEN
6363:
6364: FND_MSG_PUB.initialize;
6365:
6366: END IF;

Line 6384: IF (p_check_login_user = FND_API.G_TRUE) THEN

6380: );
6381:
6382: -- check login user
6383:
6384: IF (p_check_login_user = FND_API.G_TRUE) THEN
6385:
6386: -- Check if user is login and has the required privilege.
6387:
6388: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

Line 6388: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

6384: IF (p_check_login_user = FND_API.G_TRUE) THEN
6385:
6386: -- Check if user is login and has the required privilege.
6387:
6388: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
6389:
6390: -- User is not login.
6391:
6392: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 6400: RAISE FND_API.G_EXC_ERROR;

6396: FND_MSG_PUB.Add;
6397:
6398: END IF;
6399:
6400: RAISE FND_API.G_EXC_ERROR;
6401:
6402: END IF;
6403:
6404: END IF;

Line 6408: x_return_status := FND_API.G_RET_STS_SUCCESS;

6404: END IF;
6405:
6406: -- Initialize API return status to sucess
6407:
6408: x_return_status := FND_API.G_RET_STS_SUCCESS;
6409:
6410:
6411:
6412: --

Line 6438: IF (p_repository_id <> FND_API.G_MISS_NUM) THEN

6434:
6435:
6436: --Construct the WHERE clause
6437:
6438: IF (p_repository_id <> FND_API.G_MISS_NUM) THEN
6439:
6440: l_where_clause :=l_where_clause ||' AND b.application_id = ' || p_repository_id;
6441:
6442: END IF;

Line 6446: IF (p_repository_code <> FND_API.G_MISS_CHAR) THEN

6442: END IF;
6443:
6444:
6445:
6446: IF (p_repository_code <> FND_API.G_MISS_CHAR) THEN
6447:
6448: l_where_clause:=l_where_clause||' AND b.table_name = ''' ||
6449:
6450: p_repository_code||'''';

Line 6456: IF (p_status <> FND_API.G_MISS_CHAR) THEN

6452: END IF;
6453:
6454:
6455:
6456: IF (p_status <> FND_API.G_MISS_CHAR) THEN
6457:
6458: l_where_clause := l_where_clause || ' AND b.status = ''' ||
6459:
6460: p_status||'''';

Line 6466: IF (p_repository_name <> FND_API.G_MISS_CHAR) THEN

6462: END IF;
6463:
6464:
6465:
6466: IF (p_repository_name <> FND_API.G_MISS_CHAR) THEN
6467:
6468: l_where_clause:=l_where_clause||' AND tl.entity_name=''' ||
6469:
6470: p_repository_name||'''';

Line 6578: p_encoded => FND_API.G_FALSE,

6574: --Standard call to get message count and if count=1, get the message
6575:
6576: FND_MSG_PUB.Count_And_Get (
6577:
6578: p_encoded => FND_API.G_FALSE,
6579:
6580: p_count => x_msg_count,
6581:
6582: p_data => x_msg_data

Line 6590: WHEN FND_API.G_EXC_ERROR THEN

6586: --DBMS_OUTPUT.PUT_LINE('Exit : find_repositories' );
6587:
6588: EXCEPTION
6589:
6590: WHEN FND_API.G_EXC_ERROR THEN
6591:
6592: ROLLBACK TO Find_Repositories;
6593:
6594: x_return_status := FND_API.G_RET_STS_ERROR;

Line 6594: x_return_status := FND_API.G_RET_STS_ERROR;

6590: WHEN FND_API.G_EXC_ERROR THEN
6591:
6592: ROLLBACK TO Find_Repositories;
6593:
6594: x_return_status := FND_API.G_RET_STS_ERROR;
6595:
6596: -- Standard call to get message count and if count=1, get the message
6597:
6598: FND_MSG_PUB.Count_And_Get (

Line 6600: p_encoded => FND_API.G_FALSE,

6596: -- Standard call to get message count and if count=1, get the message
6597:
6598: FND_MSG_PUB.Count_And_Get (
6599:
6600: p_encoded => FND_API.G_FALSE,
6601:
6602: p_count => x_msg_count,
6603:
6604: p_data => x_msg_data

Line 6608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6604: p_data => x_msg_data
6605:
6606: );
6607:
6608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6609:
6610: ROLLBACK TO Find_Repositories;
6611:
6612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6609:
6610: ROLLBACK TO Find_Repositories;
6611:
6612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6613:
6614: -- Standard call to get message count and if count=1, get the message
6615:
6616: FND_MSG_PUB.Count_And_Get (

Line 6618: p_encoded => FND_API.G_FALSE,

6614: -- Standard call to get message count and if count=1, get the message
6615:
6616: FND_MSG_PUB.Count_And_Get (
6617:
6618: p_encoded => FND_API.G_FALSE,
6619:
6620: p_count => x_msg_count,
6621:
6622: p_data => x_msg_data

Line 6630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6626: WHEN OTHERS THEN
6627:
6628: ROLLBACK TO Find_Repositories;
6629:
6630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6631:
6632: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6633:
6634: THEN

Line 6644: p_encoded => FND_API.G_FALSE,

6640: -- Standard call to get message count and if count=1, get the message
6641:
6642: FND_MSG_PUB.Count_And_Get (
6643:
6644: p_encoded => FND_API.G_FALSE,
6645:
6646: p_count => x_msg_count,
6647:
6648: p_data => x_msg_data

Line 6862: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

6858: PROCEDURE find_repository_areas
6859:
6860: (p_api_version IN NUMBER,
6861:
6862: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6863:
6864: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6865:
6866: x_return_status OUT NOCOPY VARCHAR2,

Line 6864: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

6860: (p_api_version IN NUMBER,
6861:
6862: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6863:
6864: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6865:
6866: x_return_status OUT NOCOPY VARCHAR2,
6867:
6868: x_msg_count OUT NOCOPY NUMBER,

Line 6872: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

6868: x_msg_count OUT NOCOPY NUMBER,
6869:
6870: x_msg_data OUT NOCOPY VARCHAR2,
6871:
6872: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
6873:
6874: p_searcharea_obj IN amv_searchara_obj_type,
6875:
6876: x_searcharea_array OUT NOCOPY amv_searchara_varray_type)

Line 6942: IF NOT FND_API.Compatible_API_Call (

6938: SAVEPOINT Find_RepositoryAreas;
6939:
6940: -- Standard call to check for call compatibility.
6941:
6942: IF NOT FND_API.Compatible_API_Call (
6943:
6944: l_api_version,
6945:
6946: p_api_version,

Line 6954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6950: G_PKG_NAME)
6951:
6952: THEN
6953:
6954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6955:
6956: END IF;
6957:
6958: -- Debug Message

Line 6972: IF FND_API.To_Boolean (p_init_msg_list) THEN

6968: END IF;
6969:
6970: --Initialize message list if p_init_msg_list is TRUE.
6971:
6972: IF FND_API.To_Boolean (p_init_msg_list) THEN
6973:
6974: FND_MSG_PUB.initialize;
6975:
6976: END IF;

Line 6994: IF (p_check_login_user = FND_API.G_TRUE) THEN

6990: );
6991:
6992: -- check login user
6993:
6994: IF (p_check_login_user = FND_API.G_TRUE) THEN
6995:
6996: -- Check if user is login and has the required privilege.
6997:
6998: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

Line 6998: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

6994: IF (p_check_login_user = FND_API.G_TRUE) THEN
6995:
6996: -- Check if user is login and has the required privilege.
6997:
6998: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
6999:
7000: -- User is not login.
7001:
7002: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 7010: RAISE FND_API.G_EXC_ERROR;

7006: FND_MSG_PUB.Add;
7007:
7008: END IF;
7009:
7010: RAISE FND_API.G_EXC_ERROR;
7011:
7012: END IF;
7013:
7014: END IF;

Line 7018: x_return_status := FND_API.G_RET_STS_SUCCESS;

7014: END IF;
7015:
7016: -- Initialize API return status to sucess
7017:
7018: x_return_status := FND_API.G_RET_STS_SUCCESS;
7019:
7020:
7021:
7022: --

Line 7056: IF (p_searcharea_obj.repository_id <> FND_API.G_MISS_NUM) THEN

7052:
7053:
7054: --Construct the WHERE clause
7055:
7056: IF (p_searcharea_obj.repository_id <> FND_API.G_MISS_NUM) THEN
7057:
7058: l_where_clause :=l_where_clause ||' AND eb.application_id = '||
7059:
7060: p_searcharea_obj.repository_id;

Line 7066: IF (p_searcharea_obj.repository_code <> FND_API.G_MISS_CHAR) THEN

7062: END IF;
7063:
7064:
7065:
7066: IF (p_searcharea_obj.repository_code <> FND_API.G_MISS_CHAR) THEN
7067:
7068: l_where_clause:=l_where_clause||' AND eb.table_name = '''||
7069:
7070: p_searcharea_obj.repository_code||'''';

Line 7076: IF (p_searcharea_obj.area_id <> FND_API.G_MISS_NUM) THEN

7072: END IF;
7073:
7074:
7075:
7076: IF (p_searcharea_obj.area_id <> FND_API.G_MISS_NUM) THEN
7077:
7078: l_where_clause :=l_where_clause ||' AND ab.attribute_id = '||
7079:
7080: p_searcharea_obj.area_id;

Line 7086: IF (p_searcharea_obj.area_code <> FND_API.G_MISS_CHAR) THEN

7082: END IF;
7083:
7084:
7085:
7086: IF (p_searcharea_obj.area_code <> FND_API.G_MISS_CHAR) THEN
7087:
7088: l_where_clause:=l_where_clause||' AND ab.column_name = '''||
7089:
7090: p_searcharea_obj.area_code||'''';

Line 7096: IF (p_searcharea_obj.area_indicator <> FND_API.G_MISS_CHAR) THEN

7092: END IF;
7093:
7094:
7095:
7096: IF (p_searcharea_obj.area_indicator <> FND_API.G_MISS_CHAR) THEN
7097:
7098: l_where_clause:=l_where_clause||' AND ab.data_type = '''||
7099:
7100: p_searcharea_obj.area_indicator||'''';

Line 7106: IF (p_searcharea_obj.status <> FND_API.G_MISS_CHAR) THEN

7102: END IF;
7103:
7104:
7105:
7106: IF (p_searcharea_obj.status <> FND_API.G_MISS_CHAR) THEN
7107:
7108: l_where_clause := l_where_clause || ' AND ab.status = '''||
7109:
7110: p_searcharea_obj.status||'''';

Line 7116: IF (p_searcharea_obj.area_name <> FND_API.G_MISS_CHAR) THEN

7112: END IF;
7113:
7114:
7115:
7116: IF (p_searcharea_obj.area_name <> FND_API.G_MISS_CHAR) THEN
7117:
7118: l_where_clause:=l_where_clause||' AND atl.attribute_name='''||
7119:
7120: p_searcharea_obj.area_name||'''';

Line 7248: p_encoded => FND_API.G_FALSE,

7244: --Standard call to get message count and if count=1, get the message
7245:
7246: FND_MSG_PUB.Count_And_Get (
7247:
7248: p_encoded => FND_API.G_FALSE,
7249:
7250: p_count => x_msg_count,
7251:
7252: p_data => x_msg_data

Line 7260: WHEN FND_API.G_EXC_ERROR THEN

7256: --DBMS_OUTPUT.PUT_LINE('Exit : find_repository_areas' );
7257:
7258: EXCEPTION
7259:
7260: WHEN FND_API.G_EXC_ERROR THEN
7261:
7262: ROLLBACK TO Find_RepositoryAreas;
7263:
7264: x_return_status := FND_API.G_RET_STS_ERROR;

Line 7264: x_return_status := FND_API.G_RET_STS_ERROR;

7260: WHEN FND_API.G_EXC_ERROR THEN
7261:
7262: ROLLBACK TO Find_RepositoryAreas;
7263:
7264: x_return_status := FND_API.G_RET_STS_ERROR;
7265:
7266: -- Standard call to get message count and if count=1, get the message
7267:
7268: FND_MSG_PUB.Count_And_Get (

Line 7270: p_encoded => FND_API.G_FALSE,

7266: -- Standard call to get message count and if count=1, get the message
7267:
7268: FND_MSG_PUB.Count_And_Get (
7269:
7270: p_encoded => FND_API.G_FALSE,
7271:
7272: p_count => x_msg_count,
7273:
7274: p_data => x_msg_data

Line 7278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7274: p_data => x_msg_data
7275:
7276: );
7277:
7278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7279:
7280: ROLLBACK TO Find_RepositoryAreas;
7281:
7282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7279:
7280: ROLLBACK TO Find_RepositoryAreas;
7281:
7282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7283:
7284: -- Standard call to get message count and if count=1, get the message
7285:
7286: FND_MSG_PUB.Count_And_Get (

Line 7288: p_encoded => FND_API.G_FALSE,

7284: -- Standard call to get message count and if count=1, get the message
7285:
7286: FND_MSG_PUB.Count_And_Get (
7287:
7288: p_encoded => FND_API.G_FALSE,
7289:
7290: p_count => x_msg_count,
7291:
7292: p_data => x_msg_data

Line 7300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7296: WHEN OTHERS THEN
7297:
7298: ROLLBACK TO Find_RepositoryAreas;
7299:
7300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7301:
7302: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7303:
7304: THEN

Line 7314: p_encoded => FND_API.G_FALSE,

7310: -- Standard call to get message count and if count=1, get the message
7311:
7312: FND_MSG_PUB.Count_And_Get (
7313:
7314: p_encoded => FND_API.G_FALSE,
7315:
7316: p_count => x_msg_count,
7317:
7318: p_data => x_msg_data

Line 7556: -- Flag consisting of the values {fnd_api.g_true,

7552: --
7553:
7554: -- return_total_count_flag IN VARCHAR2
7555:
7556: -- Flag consisting of the values {fnd_api.g_true,
7557:
7558: -- fnd_api.g_false} to specify whether
7559:
7560: -- p_request_obj.total_record_count is

Line 7558: -- fnd_api.g_false} to specify whether

7554: -- return_total_count_flag IN VARCHAR2
7555:
7556: -- Flag consisting of the values {fnd_api.g_true,
7557:
7558: -- fnd_api.g_false} to specify whether
7559:
7560: -- p_request_obj.total_record_count is
7561:
7562: -- derived, albeit at a possible cost to resources

Line 7564: -- (Default fnd_api.g_false).

7560: -- p_request_obj.total_record_count is
7561:
7562: -- derived, albeit at a possible cost to resources
7563:
7564: -- (Default fnd_api.g_false).
7565:
7566: --
7567:
7568: -- OUT : x_return_obj OUT OBJ_TYPE

Line 7614: -- to fnd_api.g_true; Otherwise undefined.

7610: -- varray retrieval set only if
7611:
7612: -- p_request_obj.return_total_count is set
7613:
7614: -- to fnd_api.g_true; Otherwise undefined.
7615:
7616: --
7617:
7618: -- : x_searchres_array OUT ARRAY_TYPE

Line 7722: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

7718: PROCEDURE Content_Search
7719:
7720: (p_api_version IN NUMBER,
7721:
7722: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
7723:
7724: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
7725:
7726: x_return_status OUT NOCOPY VARCHAR2,

Line 7724: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

7720: (p_api_version IN NUMBER,
7721:
7722: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
7723:
7724: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
7725:
7726: x_return_status OUT NOCOPY VARCHAR2,
7727:
7728: x_msg_count OUT NOCOPY NUMBER,

Line 7732: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

7728: x_msg_count OUT NOCOPY NUMBER,
7729:
7730: x_msg_data OUT NOCOPY VARCHAR2,
7731:
7732: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
7733:
7734: p_application_id IN NUMBER,
7735:
7736: p_area_array IN amv_char_varray_type,

Line 7742: p_imt_string IN VARCHAR2 := FND_API.G_MISS_CHAR,

7738: p_content_array IN amv_char_varray_type,
7739:
7740: p_param_array IN amv_searchpar_varray_type,
7741:
7742: p_imt_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
7743:
7744: p_days IN NUMBER := FND_API.G_MISS_NUM,
7745:
7746: p_user_id IN NUMBER := FND_API.G_MISS_NUM,

Line 7744: p_days IN NUMBER := FND_API.G_MISS_NUM,

7740: p_param_array IN amv_searchpar_varray_type,
7741:
7742: p_imt_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
7743:
7744: p_days IN NUMBER := FND_API.G_MISS_NUM,
7745:
7746: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
7747:
7748: p_category_id IN amv_number_varray_type,

Line 7746: p_user_id IN NUMBER := FND_API.G_MISS_NUM,

7742: p_imt_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
7743:
7744: p_days IN NUMBER := FND_API.G_MISS_NUM,
7745:
7746: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
7747:
7748: p_category_id IN amv_number_varray_type,
7749:
7750: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,

Line 7750: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,

7746: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
7747:
7748: p_category_id IN amv_number_varray_type,
7749:
7750: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
7751:
7752: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
7753:
7754: p_request_obj IN amv_request_obj_type,

Line 7752: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

7748: p_category_id IN amv_number_varray_type,
7749:
7750: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
7751:
7752: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
7753:
7754: p_request_obj IN amv_request_obj_type,
7755:
7756: x_return_obj OUT NOCOPY amv_return_obj_type,

Line 7814: l_channel_search varchar2(1) := FND_API.G_FALSE;

7810: l_id_insert_status varchar2(1);
7811:
7812: l_user_status varchar2(1);
7813:
7814: l_channel_search varchar2(1) := FND_API.G_FALSE;
7815:
7816: l_category_search varchar2(1) := FND_API.G_FALSE;
7817:
7818: l_search_level varchar2(20);

Line 7816: l_category_search varchar2(1) := FND_API.G_FALSE;

7812: l_user_status varchar2(1);
7813:
7814: l_channel_search varchar2(1) := FND_API.G_FALSE;
7815:
7816: l_category_search varchar2(1) := FND_API.G_FALSE;
7817:
7818: l_search_level varchar2(20);
7819:
7820: l_keywords_search varchar2(1);

Line 7822: l_include_chns varchar2(1) := FND_API.G_TRUE;

7818: l_search_level varchar2(20);
7819:
7820: l_keywords_search varchar2(1);
7821:
7822: l_include_chns varchar2(1) := FND_API.G_TRUE;
7823:
7824: l_excluded_flag varchar2(1);
7825:
7826: l_start_with number := 1;

Line 7848: IF NOT FND_API.Compatible_API_Call (

7844: SAVEPOINT Content_Search;
7845:
7846: -- Standard call to check for call compatibility.
7847:
7848: IF NOT FND_API.Compatible_API_Call (
7849:
7850: l_api_version,
7851:
7852: p_api_version,

Line 7860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7856: G_PKG_NAME)
7857:
7858: THEN
7859:
7860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7861:
7862: END IF;
7863:
7864: -- Debug Message

Line 7878: IF FND_API.To_Boolean (p_init_msg_list) THEN

7874: END IF;
7875:
7876: --Initialize message list if p_init_msg_list is TRUE.
7877:
7878: IF FND_API.To_Boolean (p_init_msg_list) THEN
7879:
7880: FND_MSG_PUB.initialize;
7881:
7882: END IF;

Line 7900: IF (p_check_login_user = FND_API.G_TRUE) THEN

7896: );
7897:
7898: -- check login user
7899:
7900: IF (p_check_login_user = FND_API.G_TRUE) THEN
7901:
7902: -- Check if user is login and has the required privilege.
7903:
7904: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

Line 7904: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN

7900: IF (p_check_login_user = FND_API.G_TRUE) THEN
7901:
7902: -- Check if user is login and has the required privilege.
7903:
7904: IF (l_login_user_id = FND_API.G_MISS_NUM) THEN
7905:
7906: -- User is not login.
7907:
7908: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 7916: RAISE FND_API.G_EXC_ERROR;

7912: FND_MSG_PUB.Add;
7913:
7914: END IF;
7915:
7916: RAISE FND_API.G_EXC_ERROR;
7917:
7918: END IF;
7919:
7920: END IF;

Line 7924: x_return_status := FND_API.G_RET_STS_SUCCESS;

7920: END IF;
7921:
7922: -- Initialize API return status to sucess
7923:
7924: x_return_status := FND_API.G_RET_STS_SUCCESS;
7925:
7926:
7927:
7928: -- set days for last update days

Line 7930: IF p_days = FND_API.G_MISS_NUM OR

7926:
7927:
7928: -- set days for last update days
7929:
7930: IF p_days = FND_API.G_MISS_NUM OR
7931:
7932: p_days is null
7933:
7934: THEN

Line 7960: IF p_imt_string = FND_API.G_MISS_CHAR OR p_imt_string is null THEN

7956: l_keywords_search);
7957:
7958:
7959:
7960: IF p_imt_string = FND_API.G_MISS_CHAR OR p_imt_string is null THEN
7961:
7962: -- build imt search string
7963:
7964: build_imt_string(l_optional_array,

Line 7986: RAISE FND_API.G_EXC_ERROR;

7982: FND_MSG_PUB.Add;
7983:
7984: END IF;
7985:
7986: RAISE FND_API.G_EXC_ERROR;
7987:
7988: END IF;
7989:
7990: ELSE

Line 8006: IF p_user_id = FND_API.G_MISS_NUM OR

8002:
8003:
8004: -- determine for search level
8005:
8006: IF p_user_id = FND_API.G_MISS_NUM OR
8007:
8008: p_user_id is null
8009:
8010: THEN

Line 8018: l_include_chns := FND_API.G_FALSE;

8014: -- uncomment to search for items not associated to categories
8015:
8016: IF p_category_id.count = 0 THEN
8017:
8018: l_include_chns := FND_API.G_FALSE;
8019:
8020: l_category_search := FND_API.G_TRUE;
8021:
8022: ELSE

Line 8020: l_category_search := FND_API.G_TRUE;

8016: IF p_category_id.count = 0 THEN
8017:
8018: l_include_chns := FND_API.G_FALSE;
8019:
8020: l_category_search := FND_API.G_TRUE;
8021:
8022: ELSE
8023:
8024: -- search under the category passed

Line 8040: l_category_search := FND_API.G_TRUE;

8036: IF l_category_array.count > 0 THEN
8037:
8038: -- set flag for category level search
8039:
8040: l_category_search := FND_API.G_TRUE;
8041:
8042: END IF;
8043:
8044:

Line 8050: l_channel_search := FND_API.G_TRUE;

8046: IF l_channel_array.count > 0 THEN
8047:
8048: -- set flag for channel level search
8049:
8050: l_channel_search := FND_API.G_TRUE;
8051:
8052: END IF;
8053:
8054: END IF;

Line 8072: l_category_search := FND_API.G_TRUE;

8068: IF l_category_array.count > 0 THEN
8069:
8070: -- set flag for category level search
8071:
8072: l_category_search := FND_API.G_TRUE;
8073:
8074: END IF;
8075:
8076:

Line 8092: l_channel_search := FND_API.G_TRUE;

8088: IF l_channel_array.count > 0 THEN
8089:
8090: -- set flag for channel level search
8091:
8092: l_channel_search := FND_API.G_TRUE;
8093:
8094: END IF;
8095:
8096:

Line 8114: RAISE FND_API.G_EXC_ERROR;

8110: FND_MSG_PUB.Add;
8111:
8112: END IF;
8113:
8114: RAISE FND_API.G_EXC_ERROR;
8115:
8116: END IF;
8117:
8118: END IF;

Line 8142: IF l_category_search = FND_API.G_TRUE THEN

8138: -- perform search
8139:
8140: -- insert the list of categories to be search and perform search
8141:
8142: IF l_category_search = FND_API.G_TRUE THEN
8143:
8144: insert_temp_numbers(p_id_array => l_category_array,
8145:
8146: x_status => l_id_insert_status);

Line 8196: IF l_channel_search = FND_API.G_TRUE THEN

8192:
8193:
8194: -- insert the list of channels to be search and perform search
8195:
8196: IF l_channel_search = FND_API.G_TRUE THEN
8197:
8198: insert_temp_numbers(p_id_array => l_channel_array,
8199:
8200: x_status => l_id_insert_status);

Line 8306: p_encoded => FND_API.G_FALSE,

8302: --Standard call to get message count and if count=1, get the message
8303:
8304: FND_MSG_PUB.Count_And_Get (
8305:
8306: p_encoded => FND_API.G_FALSE,
8307:
8308: p_count => x_msg_count,
8309:
8310: p_data => x_msg_data

Line 8318: WHEN FND_API.G_EXC_ERROR THEN

8314: --DBMS_OUTPUT.PUT_LINE('Exit : Content_Search' );
8315:
8316: EXCEPTION
8317:
8318: WHEN FND_API.G_EXC_ERROR THEN
8319:
8320: ROLLBACK TO Content_Search;
8321:
8322: x_return_status := FND_API.G_RET_STS_ERROR;

Line 8322: x_return_status := FND_API.G_RET_STS_ERROR;

8318: WHEN FND_API.G_EXC_ERROR THEN
8319:
8320: ROLLBACK TO Content_Search;
8321:
8322: x_return_status := FND_API.G_RET_STS_ERROR;
8323:
8324: -- Standard call to get message count and if count=1, get the message
8325:
8326: FND_MSG_PUB.Count_And_Get (

Line 8328: p_encoded => FND_API.G_FALSE,

8324: -- Standard call to get message count and if count=1, get the message
8325:
8326: FND_MSG_PUB.Count_And_Get (
8327:
8328: p_encoded => FND_API.G_FALSE,
8329:
8330: p_count => x_msg_count,
8331:
8332: p_data => x_msg_data

Line 8336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8332: p_data => x_msg_data
8333:
8334: );
8335:
8336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8337:
8338: ROLLBACK TO Content_Search;
8339:
8340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8337:
8338: ROLLBACK TO Content_Search;
8339:
8340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8341:
8342: -- Standard call to get message count and if count=1, get the message
8343:
8344: FND_MSG_PUB.Count_And_Get (

Line 8346: p_encoded => FND_API.G_FALSE,

8342: -- Standard call to get message count and if count=1, get the message
8343:
8344: FND_MSG_PUB.Count_And_Get (
8345:
8346: p_encoded => FND_API.G_FALSE,
8347:
8348: p_count => x_msg_count,
8349:
8350: p_data => x_msg_data

Line 8358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8354: WHEN OTHERS THEN
8355:
8356: ROLLBACK TO Content_Search;
8357:
8358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8359:
8360: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8361:
8362: THEN

Line 8372: p_encoded => FND_API.G_FALSE,

8368: -- Standard call to get message count and if count=1, get the message
8369:
8370: FND_MSG_PUB.Count_And_Get (
8371:
8372: p_encoded => FND_API.G_FALSE,
8373:
8374: p_count => x_msg_count,
8375:
8376: p_data => x_msg_data