28: -- 2 Specific item
29: -- 5 category
30: --
31:
32: p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
33: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
34: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
35: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
36: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
29: -- 5 category
30: --
31:
32: p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
33: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
34: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
35: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
36: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
37: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
30: --
31:
32: p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
33: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
34: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
35: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
36: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
37: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
38: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
31:
32: p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
33: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
34: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
35: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
36: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
37: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
38: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
39: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
32: p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
33: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
34: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
35: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
36: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
37: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
38: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
39: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
40: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
33: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
34: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
35: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
36: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
37: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
38: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
39: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
40: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
41: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
34: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
35: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
36: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
37: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
38: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
39: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
40: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
41: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
42: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
35: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
36: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
37: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
38: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
39: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
40: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
41: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
42: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
43: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
36: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
37: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
38: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
39: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
40: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
41: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
42: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
43: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
44: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
37: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
38: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
39: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
40: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
41: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
42: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
43: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
44: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
45: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
38: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
39: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
40: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
41: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
42: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
43: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
44: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
45: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
46: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
39: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
40: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
41: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
42: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
43: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
44: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
45: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
46: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
47: x_return_status VARCHAR2(240);
40: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
41: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
42: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
43: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
44: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
45: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
46: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
47: x_return_status VARCHAR2(240);
48: x_return_status_text VARCHAR2(240);
41: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
42: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
43: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
44: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
45: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
46: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
47: x_return_status VARCHAR2(240);
48: x_return_status_text VARCHAR2(240);
49: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
42: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
43: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
44: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
45: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
46: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
47: x_return_status VARCHAR2(240);
48: x_return_status_text VARCHAR2(240);
49: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
50: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
45: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
46: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
47: x_return_status VARCHAR2(240);
48: x_return_status_text VARCHAR2(240);
49: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
50: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
51: line_rec QP_PREQ_GRP.LINE_REC_TYPE;
52: rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;
53:
46: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
47: x_return_status VARCHAR2(240);
48: x_return_status_text VARCHAR2(240);
49: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
50: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
51: line_rec QP_PREQ_GRP.LINE_REC_TYPE;
52: rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;
53:
54: I BINARY_INTEGER;
47: x_return_status VARCHAR2(240);
48: x_return_status_text VARCHAR2(240);
49: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
50: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
51: line_rec QP_PREQ_GRP.LINE_REC_TYPE;
52: rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;
53:
54: I BINARY_INTEGER;
55: J BINARY_INTEGER;
48: x_return_status_text VARCHAR2(240);
49: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
50: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
51: line_rec QP_PREQ_GRP.LINE_REC_TYPE;
52: rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;
53:
54: I BINARY_INTEGER;
55: J BINARY_INTEGER;
56: l_version VARCHAR2(240);
392: FND_FILE.put_line(fnd_file.log,'No matching items found for specified parameters') ;
393: RETURN;
394: End if ;
395:
396: l_version := QP_PREQ_GRP.GET_VERSION;
397: FND_FILE.put_line( fnd_file.log , 'Testing version '|| l_version);
398:
399: l_stmt_num := 60 ;
400: QP_PREQ_GRP.PRICE_REQUEST
396: l_version := QP_PREQ_GRP.GET_VERSION;
397: FND_FILE.put_line( fnd_file.log , 'Testing version '|| l_version);
398:
399: l_stmt_num := 60 ;
400: QP_PREQ_GRP.PRICE_REQUEST
401: (p_line_tbl,
402: p_qual_tbl,
403: p_line_attr_tbl,
404: p_line_detail_tbl,