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.AHL_VWP_PRICE_PVT dependencies on QP_PREQ_GRP

Line 457: l_p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

453: IS
454:
455: -- Define local variables
456:
457: l_p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
458: l_p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
459: l_p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
460: l_p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
461: l_p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

Line 458: l_p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

454:
455: -- Define local variables
456:
457: l_p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
458: l_p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
459: l_p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
460: l_p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
461: l_p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
462: l_p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

Line 459: l_p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

455: -- Define local variables
456:
457: l_p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
458: l_p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
459: l_p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
460: l_p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
461: l_p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
462: l_p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
463: l_p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

Line 460: l_p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

456:
457: l_p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
458: l_p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
459: l_p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
460: l_p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
461: l_p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
462: l_p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
463: l_p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
464: l_p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

Line 461: l_p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

457: l_p_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
458: l_p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
459: l_p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
460: l_p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
461: l_p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
462: l_p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
463: l_p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
464: l_p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
465: l_x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

Line 462: l_p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

458: l_p_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
459: l_p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
460: l_p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
461: l_p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
462: l_p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
463: l_p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
464: l_p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
465: l_x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
466: l_x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;

Line 463: l_p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

459: l_p_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
460: l_p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
461: l_p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
462: l_p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
463: l_p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
464: l_p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
465: l_x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
466: l_x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
467: l_x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

Line 464: l_p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

460: l_p_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
461: l_p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
462: l_p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
463: l_p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
464: l_p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
465: l_x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
466: l_x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
467: l_x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
468: l_x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

Line 465: l_x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

461: l_p_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
462: l_p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
463: l_p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
464: l_p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
465: l_x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
466: l_x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
467: l_x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
468: l_x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
469: l_x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

Line 466: l_x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;

462: l_p_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
463: l_p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
464: l_p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
465: l_x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
466: l_x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
467: l_x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
468: l_x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
469: l_x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
470: l_x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

Line 467: l_x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

463: l_p_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
464: l_p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
465: l_x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
466: l_x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
467: l_x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
468: l_x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
469: l_x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
470: l_x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
471: l_x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

Line 468: l_x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

464: l_p_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
465: l_x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
466: l_x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
467: l_x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
468: l_x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
469: l_x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
470: l_x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
471: l_x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
472: l_x_return_status VARCHAR2(240);

Line 469: l_x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

465: l_x_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
466: l_x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
467: l_x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
468: l_x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
469: l_x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
470: l_x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
471: l_x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
472: l_x_return_status VARCHAR2(240);
473: l_x_return_status_text VARCHAR2(240);

Line 470: l_x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

466: l_x_line_qual QP_PREQ_GRP.QUAL_TBL_TYPE;
467: l_x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
468: l_x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
469: l_x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
470: l_x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
471: l_x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
472: l_x_return_status VARCHAR2(240);
473: l_x_return_status_text VARCHAR2(240);
474: l_qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;

Line 471: l_x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

467: l_x_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
468: l_x_line_detail_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
469: l_x_line_detail_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
470: l_x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
471: l_x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
472: l_x_return_status VARCHAR2(240);
473: l_x_return_status_text VARCHAR2(240);
474: l_qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
475: l_line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;

Line 474: l_qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;

470: l_x_line_detail_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
471: l_x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
472: l_x_return_status VARCHAR2(240);
473: l_x_return_status_text VARCHAR2(240);
474: l_qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
475: l_line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
476: l_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
477:
478: l_duration NUMBER :=1; -- duration is default to 1

Line 475: l_line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;

471: l_x_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
472: l_x_return_status VARCHAR2(240);
473: l_x_return_status_text VARCHAR2(240);
474: l_qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
475: l_line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
476: l_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
477:
478: l_duration NUMBER :=1; -- duration is default to 1
479: i NUMBER :=0; -- loop index

Line 476: l_line_rec QP_PREQ_GRP.LINE_REC_TYPE;

472: l_x_return_status VARCHAR2(240);
473: l_x_return_status_text VARCHAR2(240);
474: l_qual_rec QP_PREQ_GRP.QUAL_REC_TYPE;
475: l_line_attr_rec QP_PREQ_GRP.LINE_ATTR_REC_TYPE;
476: l_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
477:
478: l_duration NUMBER :=1; -- duration is default to 1
479: i NUMBER :=0; -- loop index
480: l_api_name CONSTANT VARCHAR2(30) := 'Get_Item_Price';