DBA Data[Home] [Help]

APPS.CS_KNOWLEDGE_GRP dependencies on CS_KB_NUMBER_TBL_TYPE

Line 1150: p_rows_requested_tbl IN cs_kb_number_tbl_type,

1146: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
1147: p_category_id IN JTF_NUMBER_TABLE,
1148: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
1149: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
1150: p_rows_requested_tbl IN cs_kb_number_tbl_type,
1151: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
1152: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
1153: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
1154: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,

Line 1151: p_start_row_pos_tbl IN cs_kb_number_tbl_type,

1147: p_category_id IN JTF_NUMBER_TABLE,
1148: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
1149: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
1150: p_rows_requested_tbl IN cs_kb_number_tbl_type,
1151: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
1152: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
1153: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
1154: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
1155: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,

Line 1153: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,

1149: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
1150: p_rows_requested_tbl IN cs_kb_number_tbl_type,
1151: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
1152: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
1153: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
1154: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
1155: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
1156: x_result_array OUT NOCOPY cs_kb_result_varray_type,
1157: p_search_option IN NUMBER := NULL

Line 1154: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,

1150: p_rows_requested_tbl IN cs_kb_number_tbl_type,
1151: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
1152: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
1153: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
1154: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
1155: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
1156: x_result_array OUT NOCOPY cs_kb_result_varray_type,
1157: p_search_option IN NUMBER := NULL
1158:

Line 1155: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,

1151: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
1152: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
1153: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
1154: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
1155: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
1156: x_result_array OUT NOCOPY cs_kb_result_varray_type,
1157: p_search_option IN NUMBER := NULL
1158:
1159: )is

Line 1271: p_rows_requested_tbl IN cs_kb_number_tbl_type,

1267: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
1268: :=AMV_SEARCH_PVT.amv_number_varray_type(),
1269: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
1270: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
1271: p_rows_requested_tbl IN cs_kb_number_tbl_type,
1272: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
1273: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
1274: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
1275: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,

Line 1272: p_start_row_pos_tbl IN cs_kb_number_tbl_type,

1268: :=AMV_SEARCH_PVT.amv_number_varray_type(),
1269: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
1270: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
1271: p_rows_requested_tbl IN cs_kb_number_tbl_type,
1272: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
1273: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
1274: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
1275: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
1276: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,

Line 1274: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,

1270: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
1271: p_rows_requested_tbl IN cs_kb_number_tbl_type,
1272: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
1273: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
1274: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
1275: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
1276: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
1277: x_result_array OUT NOCOPY cs_kb_result_varray_type,
1278: p_search_option IN NUMBER := NULL

Line 1275: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,

1271: p_rows_requested_tbl IN cs_kb_number_tbl_type,
1272: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
1273: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
1274: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
1275: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
1276: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
1277: x_result_array OUT NOCOPY cs_kb_result_varray_type,
1278: p_search_option IN NUMBER := NULL
1279:

Line 1276: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,

1272: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
1273: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
1274: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
1275: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
1276: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
1277: x_result_array OUT NOCOPY cs_kb_result_varray_type,
1278: p_search_option IN NUMBER := NULL
1279:
1280: )is

Line 1340: p_rows_requested_tbl IN cs_kb_number_tbl_type,

1336: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
1337: :=AMV_SEARCH_PVT.amv_number_varray_type(),
1338: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
1339: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
1340: p_rows_requested_tbl IN cs_kb_number_tbl_type,
1341: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
1342: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
1343: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
1344: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,

Line 1341: p_start_row_pos_tbl IN cs_kb_number_tbl_type,

1337: :=AMV_SEARCH_PVT.amv_number_varray_type(),
1338: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
1339: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
1340: p_rows_requested_tbl IN cs_kb_number_tbl_type,
1341: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
1342: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
1343: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
1344: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
1345: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,

Line 1343: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,

1339: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
1340: p_rows_requested_tbl IN cs_kb_number_tbl_type,
1341: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
1342: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
1343: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
1344: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
1345: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
1346: x_result_array OUT NOCOPY cs_kb_result_varray_type,
1347: x_amv_result_array OUT NOCOPY AMV_SEARCH_PVT.amv_searchres_varray_type,

Line 1344: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,

1340: p_rows_requested_tbl IN cs_kb_number_tbl_type,
1341: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
1342: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
1343: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
1344: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
1345: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
1346: x_result_array OUT NOCOPY cs_kb_result_varray_type,
1347: x_amv_result_array OUT NOCOPY AMV_SEARCH_PVT.amv_searchres_varray_type,
1348: p_search_option IN NUMBER := NULL

Line 1345: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,

1341: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
1342: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
1343: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
1344: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
1345: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
1346: x_result_array OUT NOCOPY cs_kb_result_varray_type,
1347: x_amv_result_array OUT NOCOPY AMV_SEARCH_PVT.amv_searchres_varray_type,
1348: p_search_option IN NUMBER := NULL
1349:

Line 1385: x_rows_returned_tbl := cs_kb_number_tbl_type();

1381: -- x_row_return_obj := cs_kb_rowret_obj_type(0, 0, 0);
1382:
1383: -- this same array can be wrtten by both sms and mes search in out.
1384: x_result_array := cs_kb_result_varray_type();
1385: x_rows_returned_tbl := cs_kb_number_tbl_type();
1386: x_next_row_pos_tbl :=cs_kb_number_tbl_type();
1387: x_total_row_cnt_tbl :=cs_kb_number_tbl_type();
1388:
1389:

Line 1386: x_next_row_pos_tbl :=cs_kb_number_tbl_type();

1382:
1383: -- this same array can be wrtten by both sms and mes search in out.
1384: x_result_array := cs_kb_result_varray_type();
1385: x_rows_returned_tbl := cs_kb_number_tbl_type();
1386: x_next_row_pos_tbl :=cs_kb_number_tbl_type();
1387: x_total_row_cnt_tbl :=cs_kb_number_tbl_type();
1388:
1389:
1390: if(p_repository_tbl is null) then

Line 1387: x_total_row_cnt_tbl :=cs_kb_number_tbl_type();

1383: -- this same array can be wrtten by both sms and mes search in out.
1384: x_result_array := cs_kb_result_varray_type();
1385: x_rows_returned_tbl := cs_kb_number_tbl_type();
1386: x_next_row_pos_tbl :=cs_kb_number_tbl_type();
1387: x_total_row_cnt_tbl :=cs_kb_number_tbl_type();
1388:
1389:
1390: if(p_repository_tbl is null) then
1391: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then