DBA Data[Home] [Help]

APPS.CS_KNOWLEDGE_GRP dependencies on CS_KB_NUMBER_TBL_TYPE

Line 534: p_rows_requested_tbl IN cs_kb_number_tbl_type,

530: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
531: p_category_id IN JTF_NUMBER_TABLE,
532: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
533: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
534: p_rows_requested_tbl IN cs_kb_number_tbl_type,
535: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
536: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
537: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
538: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,

Line 535: p_start_row_pos_tbl IN cs_kb_number_tbl_type,

531: p_category_id IN JTF_NUMBER_TABLE,
532: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
533: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
534: p_rows_requested_tbl IN cs_kb_number_tbl_type,
535: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
536: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
537: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
538: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
539: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,

Line 537: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,

533: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
534: p_rows_requested_tbl IN cs_kb_number_tbl_type,
535: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
536: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
537: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
538: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
539: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
540: x_result_array OUT NOCOPY cs_kb_result_varray_type,
541: p_search_option IN NUMBER := NULL

Line 538: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,

534: p_rows_requested_tbl IN cs_kb_number_tbl_type,
535: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
536: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
537: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
538: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
539: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
540: x_result_array OUT NOCOPY cs_kb_result_varray_type,
541: p_search_option IN NUMBER := NULL
542:

Line 539: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,

535: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
536: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
537: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
538: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
539: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
540: x_result_array OUT NOCOPY cs_kb_result_varray_type,
541: p_search_option IN NUMBER := NULL
542:
543: );

Line 599: -- p_rows_requested_tbl IN cs_kb_number_tbl_type Required

595: -- Include sub categories. MES
596: -- p_external_contents IN VARCHAR2 Optional
597: -- := FND_API.G_FALSE
598: -- Include external contents. MES
599: -- p_rows_requested_tbl IN cs_kb_number_tbl_type Required
600: -- Number of rows requested
601: -- p_start_row_pos_tbl IN cs_kb_number_tbl_type Required
602: -- Start row position
603: -- p_get_total_cnt_flag IN VARCHAR2 Optional

Line 601: -- p_start_row_pos_tbl IN cs_kb_number_tbl_type Required

597: -- := FND_API.G_FALSE
598: -- Include external contents. MES
599: -- p_rows_requested_tbl IN cs_kb_number_tbl_type Required
600: -- Number of rows requested
601: -- p_start_row_pos_tbl IN cs_kb_number_tbl_type Required
602: -- Start row position
603: -- p_get_total_cnt_flag IN VARCHAR2 Optional
604: -- := fnd_api.g_true
605: -- Whether to get total count

Line 612: -- x_rows_returned_tbl OUT cs_kb_number_tbl_type,

608: -- OUT :
609: -- x_return_status OUT VARCHAR2(1)
610: -- x_msg_count OUT NUMBER
611: -- x_msg_data OUT VARCHAR2(2000)
612: -- x_rows_returned_tbl OUT cs_kb_number_tbl_type,
613: -- Number of rows returned
614: -- x_next_row_pos_tbl OUT cs_kb_number_tbl_type,
615: -- Next row position
616: -- x_total_row_cnt_tbl OUT cs_kb_number_tbl_type,

Line 614: -- x_next_row_pos_tbl OUT cs_kb_number_tbl_type,

610: -- x_msg_count OUT NUMBER
611: -- x_msg_data OUT VARCHAR2(2000)
612: -- x_rows_returned_tbl OUT cs_kb_number_tbl_type,
613: -- Number of rows returned
614: -- x_next_row_pos_tbl OUT cs_kb_number_tbl_type,
615: -- Next row position
616: -- x_total_row_cnt_tbl OUT cs_kb_number_tbl_type,
617: -- Total row count
618: -- x_result_array OUT cs_kb_result_varray_type

Line 616: -- x_total_row_cnt_tbl OUT cs_kb_number_tbl_type,

612: -- x_rows_returned_tbl OUT cs_kb_number_tbl_type,
613: -- Number of rows returned
614: -- x_next_row_pos_tbl OUT cs_kb_number_tbl_type,
615: -- Next row position
616: -- x_total_row_cnt_tbl OUT cs_kb_number_tbl_type,
617: -- Total row count
618: -- x_result_array OUT cs_kb_result_varray_type
619: --
620: -- Version : Initial Version 1.0

Line 651: p_rows_requested_tbl IN cs_kb_number_tbl_type,

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,
653: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
654: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
655: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,

Line 652: p_start_row_pos_tbl IN cs_kb_number_tbl_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,
653: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
654: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
655: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
656: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,

Line 654: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,

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,
653: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
654: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
655: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
656: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
657: x_result_array OUT NOCOPY cs_kb_result_varray_type,
658: p_search_option IN NUMBER := NULL

Line 655: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,

651: p_rows_requested_tbl IN cs_kb_number_tbl_type,
652: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
653: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
654: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
655: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
656: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
657: x_result_array OUT NOCOPY cs_kb_result_varray_type,
658: p_search_option IN NUMBER := NULL
659:

Line 656: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,

652: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
653: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
654: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
655: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
656: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
657: x_result_array OUT NOCOPY cs_kb_result_varray_type,
658: p_search_option IN NUMBER := NULL
659:
660: );

Line 690: p_rows_requested_tbl IN cs_kb_number_tbl_type,

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,
692: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
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,

Line 691: p_start_row_pos_tbl IN cs_kb_number_tbl_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,
692: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
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,

Line 693: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,

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,
692: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
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,

Line 694: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,

690: p_rows_requested_tbl IN cs_kb_number_tbl_type,
691: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
692: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
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

Line 695: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,

691: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
692: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
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: