DBA Data[Home] [Help]

APPS.OZF_FORECAST_UTIL_PVT dependencies on QP_PREQ_GRP

Line 7780: p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

7776: )
7777: IS
7778:
7779:
7780: p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
7781: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
7782: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
7783: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
7784: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

Line 7781: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

7777: IS
7778:
7779:
7780: p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
7781: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
7782: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
7783: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
7784: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
7785: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

Line 7782: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

7778:
7779:
7780: p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
7781: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
7782: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
7783: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
7784: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
7785: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
7786: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

Line 7783: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

7779:
7780: p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
7781: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
7782: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
7783: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
7784: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
7785: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
7786: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
7787: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

Line 7784: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

7780: p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
7781: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
7782: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
7783: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
7784: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
7785: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
7786: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
7787: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
7788: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

Line 7785: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

7781: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
7782: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
7783: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
7784: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
7785: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
7786: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
7787: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
7788: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
7789: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;

Line 7786: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

7782: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
7783: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
7784: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
7785: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
7786: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
7787: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
7788: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
7789: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
7790: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

Line 7787: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

7783: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
7784: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
7785: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
7786: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
7787: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
7788: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
7789: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
7790: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
7791: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

Line 7788: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

7784: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
7785: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
7786: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
7787: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
7788: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
7789: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
7790: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
7791: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
7792: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

Line 7789: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;

7785: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
7786: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
7787: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
7788: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
7789: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
7790: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
7791: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
7792: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
7793: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

Line 7790: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

7786: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
7787: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
7788: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
7789: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
7790: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
7791: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
7792: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
7793: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
7794: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

Line 7791: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

7787: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
7788: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
7789: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
7790: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
7791: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
7792: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
7793: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
7794: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
7795: x_return_stat VARCHAR2(240);

Line 7792: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

7788: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
7789: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
7790: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
7791: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
7792: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
7793: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
7794: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
7795: x_return_stat VARCHAR2(240);
7796: x_return_status_text VARCHAR2(240);

Line 7793: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

7789: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
7790: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
7791: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
7792: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
7793: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
7794: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
7795: x_return_stat VARCHAR2(240);
7796: x_return_status_text VARCHAR2(240);
7797: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;

Line 7794: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

7790: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
7791: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
7792: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
7793: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
7794: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
7795: x_return_stat VARCHAR2(240);
7796: x_return_status_text VARCHAR2(240);
7797: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
7798: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;

Line 7797: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;

7793: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
7794: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
7795: x_return_stat VARCHAR2(240);
7796: x_return_status_text VARCHAR2(240);
7797: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
7798: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
7799: line_rec QP_PREQ_GRP.LINE_REC_TYPE;
7800: rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;
7801:

Line 7798: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;

7794: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
7795: x_return_stat VARCHAR2(240);
7796: x_return_status_text VARCHAR2(240);
7797: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
7798: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
7799: line_rec QP_PREQ_GRP.LINE_REC_TYPE;
7800: rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;
7801:
7802: l_version VARCHAR2(240);

Line 7799: line_rec QP_PREQ_GRP.LINE_REC_TYPE;

7795: x_return_stat VARCHAR2(240);
7796: x_return_status_text VARCHAR2(240);
7797: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
7798: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
7799: line_rec QP_PREQ_GRP.LINE_REC_TYPE;
7800: rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;
7801:
7802: l_version VARCHAR2(240);
7803: l_counter NUMBER;

Line 7800: rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;

7796: x_return_status_text VARCHAR2(240);
7797: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
7798: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
7799: line_rec QP_PREQ_GRP.LINE_REC_TYPE;
7800: rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;
7801:
7802: l_version VARCHAR2(240);
7803: l_counter NUMBER;
7804: I BINARY_INTEGER;

Line 7936: QP_PREQ_GRP.PRICE_REQUEST

7932:
7933: END IF;
7934:
7935: -- Actual Call to the Pricing Engine
7936: QP_PREQ_GRP.PRICE_REQUEST
7937: (p_line_tbl,
7938: p_qual_tbl,
7939: p_line_attr_tbl,
7940: p_line_detail_tbl,