5367: x_return_status OUT NOCOPY VARCHAR2,
5368: x_msg_count OUT NOCOPY NUMBER,
5369: x_msg_data OUT NOCOPY VARCHAR2)
5370: IS
5371: p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
5372: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
5373: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
5374: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
5375: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
5368: x_msg_count OUT NOCOPY NUMBER,
5369: x_msg_data OUT NOCOPY VARCHAR2)
5370: IS
5371: p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
5372: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
5373: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
5374: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
5375: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
5376: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
5369: x_msg_data OUT NOCOPY VARCHAR2)
5370: IS
5371: p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
5372: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
5373: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
5374: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
5375: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
5376: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
5377: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
5370: IS
5371: p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
5372: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
5373: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
5374: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
5375: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
5376: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
5377: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
5378: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
5371: p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
5372: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
5373: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
5374: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
5375: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
5376: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
5377: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
5378: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
5379: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
5372: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
5373: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
5374: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
5375: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
5376: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
5377: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
5378: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
5379: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
5380: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
5373: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
5374: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
5375: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
5376: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
5377: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
5378: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
5379: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
5380: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
5381: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
5374: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
5375: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
5376: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
5377: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
5378: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
5379: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
5380: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
5381: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
5382: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
5375: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
5376: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
5377: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
5378: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
5379: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
5380: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
5381: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
5382: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
5383: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
5376: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
5377: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
5378: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
5379: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
5380: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
5381: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
5382: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
5383: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
5384: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
5377: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
5378: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
5379: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
5380: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
5381: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
5382: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
5383: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
5384: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
5385: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
5378: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
5379: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
5380: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
5381: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
5382: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
5383: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
5384: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
5385: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
5386: -- x_return_status VARCHAR2(240);
5379: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
5380: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
5381: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
5382: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
5383: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
5384: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
5385: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
5386: -- x_return_status VARCHAR2(240);
5387: x_return_status_text VARCHAR2(240);
5380: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
5381: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
5382: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
5383: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
5384: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
5385: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
5386: -- x_return_status VARCHAR2(240);
5387: x_return_status_text VARCHAR2(240);
5388: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
5381: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
5382: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
5383: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
5384: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
5385: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
5386: -- x_return_status VARCHAR2(240);
5387: x_return_status_text VARCHAR2(240);
5388: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
5389: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
5384: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
5385: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
5386: -- x_return_status VARCHAR2(240);
5387: x_return_status_text VARCHAR2(240);
5388: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
5389: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
5390: line_rec QP_PREQ_GRP.LINE_REC_TYPE;
5391: rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;
5392:
5385: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
5386: -- x_return_status VARCHAR2(240);
5387: x_return_status_text VARCHAR2(240);
5388: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
5389: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
5390: line_rec QP_PREQ_GRP.LINE_REC_TYPE;
5391: rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;
5392:
5393:
5386: -- x_return_status VARCHAR2(240);
5387: x_return_status_text VARCHAR2(240);
5388: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
5389: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
5390: line_rec QP_PREQ_GRP.LINE_REC_TYPE;
5391: rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;
5392:
5393:
5394: I BINARY_INTEGER;
5387: x_return_status_text VARCHAR2(240);
5388: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
5389: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
5390: line_rec QP_PREQ_GRP.LINE_REC_TYPE;
5391: rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;
5392:
5393:
5394: I BINARY_INTEGER;
5395: l_version VARCHAR2(240);
5592: p_qual_tbl(1+1):= qual_rec;
5593:
5594:
5595: -- This statement prints out the version of the QP_PREQ_PUB API(QPXPPREB.pls).Information only
5596: l_version := QP_PREQ_GRP.GET_VERSION;
5597: --DBMS_OUTPUT.PUT_LINE('Testing version '||l_version);
5598:
5599:
5600: -- Actual Call to the Pricing Engine