eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_TP_UTIL_QUERIES dependencies on QP_PREQ_GRP

Line 446: p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

442: )
443: IS
444:
445:
446: p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
447: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
448: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
449: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
450: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

Line 447: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

443: IS
444:
445:
446: p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
447: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
448: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
449: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
450: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
451: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

Line 448: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

444:
445:
446: p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
447: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
448: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
449: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
450: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
451: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
452: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

Line 449: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

445:
446: p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
447: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
448: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
449: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
450: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
451: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
452: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
453: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

Line 450: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

446: p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
447: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
448: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
449: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
450: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
451: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
452: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
453: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
454: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

Line 451: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

447: p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
448: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
449: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
450: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
451: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
452: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
453: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
454: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
455: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;

Line 452: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

448: p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
449: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
450: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
451: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
452: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
453: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
454: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
455: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
456: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

Line 453: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

449: p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
450: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
451: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
452: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
453: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
454: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
455: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
456: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
457: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

Line 454: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

450: p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
451: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
452: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
453: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
454: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
455: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
456: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
457: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
458: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

Line 455: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;

451: p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
452: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
453: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
454: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
455: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
456: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
457: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
458: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
459: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

Line 456: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

452: p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
453: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
454: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
455: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
456: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
457: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
458: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
459: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
460: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

Line 457: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

453: p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
454: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
455: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
456: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
457: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
458: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
459: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
460: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
461: x_return_stat VARCHAR2(240);

Line 458: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

454: x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
455: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
456: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
457: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
458: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
459: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
460: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
461: x_return_stat VARCHAR2(240);
462: x_return_status_text VARCHAR2(240);

Line 459: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

455: x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
456: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
457: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
458: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
459: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
460: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
461: x_return_stat VARCHAR2(240);
462: x_return_status_text VARCHAR2(240);
463: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;

Line 460: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

456: x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
457: x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
458: x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
459: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
460: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
461: x_return_stat VARCHAR2(240);
462: x_return_status_text VARCHAR2(240);
463: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
464: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;

Line 463: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;

459: x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
460: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
461: x_return_stat VARCHAR2(240);
462: x_return_status_text VARCHAR2(240);
463: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
464: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
465: line_rec QP_PREQ_GRP.LINE_REC_TYPE;
466: rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;
467:

Line 464: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;

460: x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
461: x_return_stat VARCHAR2(240);
462: x_return_status_text VARCHAR2(240);
463: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
464: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
465: line_rec QP_PREQ_GRP.LINE_REC_TYPE;
466: rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;
467:
468: l_version VARCHAR2(240);

Line 465: line_rec QP_PREQ_GRP.LINE_REC_TYPE;

461: x_return_stat VARCHAR2(240);
462: x_return_status_text VARCHAR2(240);
463: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
464: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
465: line_rec QP_PREQ_GRP.LINE_REC_TYPE;
466: rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;
467:
468: l_version VARCHAR2(240);
469: l_counter NUMBER;

Line 466: rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;

462: x_return_status_text VARCHAR2(240);
463: qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
464: line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
465: line_rec QP_PREQ_GRP.LINE_REC_TYPE;
466: rltd_rec QP_PREQ_GRP.RELATED_LINES_REC_TYPE;
467:
468: l_version VARCHAR2(240);
469: l_counter NUMBER;
470: I BINARY_INTEGER;

Line 581: QP_PREQ_GRP.PRICE_REQUEST

577: end loop;
578: end if;
579: end if;
580: -- Actual Call to the Pricing Engine
581: QP_PREQ_GRP.PRICE_REQUEST
582: (p_line_tbl,
583: p_qual_tbl,
584: p_line_attr_tbl,
585: p_line_detail_tbl,