DBA Data[Home] [Help]

APPS.CS_KNOWLEDGE_GRP dependencies on AMV_SEARCH_PVT

Line 571: -- AMV_SEARCH_PVT.amv_char_varray_type Optional

567: -- := FND_API.G_TRUE
568: -- whether or not to check login user's access privilege. For MES.
569: -- p_application_id IN NUMBER Required
570: -- p_area_array IN
571: -- AMV_SEARCH_PVT.amv_char_varray_type Optional
572: -- := AMV_SEARCH_PVT.amv_char_varray_type()
573: -- valid values are ITEM, CATEGORY. For MES
574: -- p_content_array IN
575: -- AMV_SEARCH_PVT.amv_char_varray_type Optional

Line 572: -- := AMV_SEARCH_PVT.amv_char_varray_type()

568: -- whether or not to check login user's access privilege. For MES.
569: -- p_application_id IN NUMBER Required
570: -- p_area_array IN
571: -- AMV_SEARCH_PVT.amv_char_varray_type Optional
572: -- := AMV_SEARCH_PVT.amv_char_varray_type()
573: -- valid values are ITEM, CATEGORY. For MES
574: -- p_content_array IN
575: -- AMV_SEARCH_PVT.amv_char_varray_type Optional
576: -- := AMV_SEARCH_PVT.amv_char_varray_type()

Line 575: -- AMV_SEARCH_PVT.amv_char_varray_type Optional

571: -- AMV_SEARCH_PVT.amv_char_varray_type Optional
572: -- := AMV_SEARCH_PVT.amv_char_varray_type()
573: -- valid values are ITEM, CATEGORY. For MES
574: -- p_content_array IN
575: -- AMV_SEARCH_PVT.amv_char_varray_type Optional
576: -- := AMV_SEARCH_PVT.amv_char_varray_type()
577: -- valid values are KEYWORD, AUTHOR, TITLE_DESC, CONTENT. for MES
578: -- p_param_array IN
579: -- AMV_SEARCH_PVT.amv_searchpar_varray_type Optional

Line 576: -- := AMV_SEARCH_PVT.amv_char_varray_type()

572: -- := AMV_SEARCH_PVT.amv_char_varray_type()
573: -- valid values are ITEM, CATEGORY. For MES
574: -- p_content_array IN
575: -- AMV_SEARCH_PVT.amv_char_varray_type Optional
576: -- := AMV_SEARCH_PVT.amv_char_varray_type()
577: -- valid values are KEYWORD, AUTHOR, TITLE_DESC, CONTENT. for MES
578: -- p_param_array IN
579: -- AMV_SEARCH_PVT.amv_searchpar_varray_type Optional
580: -- := AMV_SEARCH_PVT.amv_searchpar_varray_type()

Line 579: -- AMV_SEARCH_PVT.amv_searchpar_varray_type Optional

575: -- AMV_SEARCH_PVT.amv_char_varray_type Optional
576: -- := AMV_SEARCH_PVT.amv_char_varray_type()
577: -- valid values are KEYWORD, AUTHOR, TITLE_DESC, CONTENT. for MES
578: -- p_param_array IN
579: -- AMV_SEARCH_PVT.amv_searchpar_varray_type Optional
580: -- := AMV_SEARCH_PVT.amv_searchpar_varray_type()
581: -- For MES. Consists of operator and search string
582: -- valid values for operator are
583: -- CAN_CONTAIN, MUST_CONTAIN, MUST_NOT_CONTAIN

Line 580: -- := AMV_SEARCH_PVT.amv_searchpar_varray_type()

576: -- := AMV_SEARCH_PVT.amv_char_varray_type()
577: -- valid values are KEYWORD, AUTHOR, TITLE_DESC, CONTENT. for MES
578: -- p_param_array IN
579: -- AMV_SEARCH_PVT.amv_searchpar_varray_type Optional
580: -- := AMV_SEARCH_PVT.amv_searchpar_varray_type()
581: -- For MES. Consists of operator and search string
582: -- valid values for operator are
583: -- CAN_CONTAIN, MUST_CONTAIN, MUST_NOT_CONTAIN
584: -- Do not use this for interMedia search on content.

Line 590: -- AMV_SEARCH_PVT.amv_number_varray_type Optioanl

586: -- p_user_id IN NUMBER Optional
587: -- := FND_API.G_MISS_NUM
588: -- For MES
589: -- p_category_id IN
590: -- AMV_SEARCH_PVT.amv_number_varray_type Optioanl
591: -- := AMV_SEARCH_PVT.amv_number_varray_type()
592: -- MES category identifier. Empty obj to search all MES categories.
593: -- p_include_subcats IN VARCHAR2 Optional
594: -- := FND_API.G_FALSE

Line 591: -- := AMV_SEARCH_PVT.amv_number_varray_type()

587: -- := FND_API.G_MISS_NUM
588: -- For MES
589: -- p_category_id IN
590: -- AMV_SEARCH_PVT.amv_number_varray_type Optioanl
591: -- := AMV_SEARCH_PVT.amv_number_varray_type()
592: -- MES category identifier. Empty obj to search all MES categories.
593: -- p_include_subcats IN VARCHAR2 Optional
594: -- := FND_API.G_FALSE
595: -- Include sub categories. MES

Line 640: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type

636: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
637: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
638: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
639: p_application_id IN NUMBER,
640: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
641: := AMV_SEARCH_PVT.amv_char_varray_type(),
642: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
643: := AMV_SEARCH_PVT.amv_char_varray_type(),
644: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type

Line 641: := AMV_SEARCH_PVT.amv_char_varray_type(),

637: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
638: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
639: p_application_id IN NUMBER,
640: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
641: := AMV_SEARCH_PVT.amv_char_varray_type(),
642: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
643: := AMV_SEARCH_PVT.amv_char_varray_type(),
644: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
645: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),

Line 642: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type

638: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
639: p_application_id IN NUMBER,
640: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
641: := AMV_SEARCH_PVT.amv_char_varray_type(),
642: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
643: := AMV_SEARCH_PVT.amv_char_varray_type(),
644: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
645: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
646: p_user_id IN NUMBER := FND_API.G_MISS_NUM,

Line 643: := AMV_SEARCH_PVT.amv_char_varray_type(),

639: p_application_id IN NUMBER,
640: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
641: := AMV_SEARCH_PVT.amv_char_varray_type(),
642: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
643: := AMV_SEARCH_PVT.amv_char_varray_type(),
644: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
645: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
646: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
647: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type

Line 644: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type

640: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
641: := AMV_SEARCH_PVT.amv_char_varray_type(),
642: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
643: := AMV_SEARCH_PVT.amv_char_varray_type(),
644: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
645: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
646: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
647: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
648: := AMV_SEARCH_PVT.amv_number_varray_type(),

Line 645: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),

641: := AMV_SEARCH_PVT.amv_char_varray_type(),
642: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
643: := AMV_SEARCH_PVT.amv_char_varray_type(),
644: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
645: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
646: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
647: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
648: := AMV_SEARCH_PVT.amv_number_varray_type(),
649: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,

Line 647: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type

643: := AMV_SEARCH_PVT.amv_char_varray_type(),
644: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
645: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
646: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
647: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
648: := AMV_SEARCH_PVT.amv_number_varray_type(),
649: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
650: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
651: p_rows_requested_tbl IN cs_kb_number_tbl_type,

Line 648: := AMV_SEARCH_PVT.amv_number_varray_type(),

644: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
645: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
646: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
647: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
648: := AMV_SEARCH_PVT.amv_number_varray_type(),
649: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
650: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
651: p_rows_requested_tbl IN cs_kb_number_tbl_type,
652: p_start_row_pos_tbl IN cs_kb_number_tbl_type,

Line 679: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type

675: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
676: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
677: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
678: p_application_id IN NUMBER,
679: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
680: := AMV_SEARCH_PVT.amv_char_varray_type(),
681: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
682: := AMV_SEARCH_PVT.amv_char_varray_type(),
683: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type

Line 680: := AMV_SEARCH_PVT.amv_char_varray_type(),

676: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
677: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
678: p_application_id IN NUMBER,
679: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
680: := AMV_SEARCH_PVT.amv_char_varray_type(),
681: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
682: := AMV_SEARCH_PVT.amv_char_varray_type(),
683: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
684: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),

Line 681: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type

677: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
678: p_application_id IN NUMBER,
679: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
680: := AMV_SEARCH_PVT.amv_char_varray_type(),
681: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
682: := AMV_SEARCH_PVT.amv_char_varray_type(),
683: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
684: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
685: p_user_id IN NUMBER := FND_API.G_MISS_NUM,

Line 682: := AMV_SEARCH_PVT.amv_char_varray_type(),

678: p_application_id IN NUMBER,
679: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
680: := AMV_SEARCH_PVT.amv_char_varray_type(),
681: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
682: := AMV_SEARCH_PVT.amv_char_varray_type(),
683: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
684: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
685: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
686: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type

Line 683: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type

679: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
680: := AMV_SEARCH_PVT.amv_char_varray_type(),
681: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
682: := AMV_SEARCH_PVT.amv_char_varray_type(),
683: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
684: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
685: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
686: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
687: := AMV_SEARCH_PVT.amv_number_varray_type(),

Line 684: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),

680: := AMV_SEARCH_PVT.amv_char_varray_type(),
681: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
682: := AMV_SEARCH_PVT.amv_char_varray_type(),
683: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
684: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
685: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
686: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
687: := AMV_SEARCH_PVT.amv_number_varray_type(),
688: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,

Line 686: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type

682: := AMV_SEARCH_PVT.amv_char_varray_type(),
683: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
684: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
685: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
686: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
687: := AMV_SEARCH_PVT.amv_number_varray_type(),
688: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
689: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
690: p_rows_requested_tbl IN cs_kb_number_tbl_type,

Line 687: := AMV_SEARCH_PVT.amv_number_varray_type(),

683: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
684: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
685: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
686: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
687: := AMV_SEARCH_PVT.amv_number_varray_type(),
688: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
689: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
690: p_rows_requested_tbl IN cs_kb_number_tbl_type,
691: p_start_row_pos_tbl IN cs_kb_number_tbl_type,

Line 697: x_amv_result_array OUT NOCOPY AMV_SEARCH_PVT.amv_searchres_varray_type,

693: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
694: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
695: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
696: x_result_array OUT NOCOPY cs_kb_result_varray_type,
697: x_amv_result_array OUT NOCOPY AMV_SEARCH_PVT.amv_searchres_varray_type,
698: p_search_option IN NUMBER := NULL
699:
700: );
701: