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

Line 412: (p_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,

408: *
409: * @rep:displayname Price Request
410: */
411: PROCEDURE PRICE_REQUEST
412: (p_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,
413: p_qual_tbl IN QP_PREQ_GRP.QUAL_TBL_TYPE,
414: p_line_attr_tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
415: p_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
416: p_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,

Line 413: p_qual_tbl IN QP_PREQ_GRP.QUAL_TBL_TYPE,

409: * @rep:displayname Price Request
410: */
411: PROCEDURE PRICE_REQUEST
412: (p_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,
413: p_qual_tbl IN QP_PREQ_GRP.QUAL_TBL_TYPE,
414: p_line_attr_tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
415: p_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
416: p_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
417: p_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,

Line 414: p_line_attr_tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

410: */
411: PROCEDURE PRICE_REQUEST
412: (p_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,
413: p_qual_tbl IN QP_PREQ_GRP.QUAL_TBL_TYPE,
414: p_line_attr_tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
415: p_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
416: p_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
417: p_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
418: p_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,

Line 415: p_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

411: PROCEDURE PRICE_REQUEST
412: (p_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,
413: p_qual_tbl IN QP_PREQ_GRP.QUAL_TBL_TYPE,
414: p_line_attr_tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
415: p_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
416: p_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
417: p_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
418: p_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
419: p_control_rec IN QP_PREQ_GRP.CONTROL_RECORD_TYPE,

Line 416: p_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,

412: (p_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,
413: p_qual_tbl IN QP_PREQ_GRP.QUAL_TBL_TYPE,
414: p_line_attr_tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
415: p_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
416: p_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
417: p_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
418: p_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
419: p_control_rec IN QP_PREQ_GRP.CONTROL_RECORD_TYPE,
420: x_line_tbl OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

Line 417: p_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,

413: p_qual_tbl IN QP_PREQ_GRP.QUAL_TBL_TYPE,
414: p_line_attr_tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
415: p_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
416: p_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
417: p_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
418: p_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
419: p_control_rec IN QP_PREQ_GRP.CONTROL_RECORD_TYPE,
420: x_line_tbl OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
421: x_line_qual OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,

Line 418: p_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,

414: p_line_attr_tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
415: p_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
416: p_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
417: p_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
418: p_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
419: p_control_rec IN QP_PREQ_GRP.CONTROL_RECORD_TYPE,
420: x_line_tbl OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
421: x_line_qual OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
422: x_line_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

Line 419: p_control_rec IN QP_PREQ_GRP.CONTROL_RECORD_TYPE,

415: p_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
416: p_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
417: p_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
418: p_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
419: p_control_rec IN QP_PREQ_GRP.CONTROL_RECORD_TYPE,
420: x_line_tbl OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
421: x_line_qual OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
422: x_line_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
423: x_line_detail_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

Line 420: x_line_tbl OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

416: p_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
417: p_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
418: p_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
419: p_control_rec IN QP_PREQ_GRP.CONTROL_RECORD_TYPE,
420: x_line_tbl OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
421: x_line_qual OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
422: x_line_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
423: x_line_detail_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
424: x_line_detail_qual_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,

Line 421: x_line_qual OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,

417: p_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
418: p_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
419: p_control_rec IN QP_PREQ_GRP.CONTROL_RECORD_TYPE,
420: x_line_tbl OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
421: x_line_qual OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
422: x_line_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
423: x_line_detail_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
424: x_line_detail_qual_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
425: x_line_detail_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,

Line 422: x_line_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

418: p_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
419: p_control_rec IN QP_PREQ_GRP.CONTROL_RECORD_TYPE,
420: x_line_tbl OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
421: x_line_qual OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
422: x_line_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
423: x_line_detail_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
424: x_line_detail_qual_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
425: x_line_detail_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
426: x_related_lines_tbl OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,

Line 423: x_line_detail_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

419: p_control_rec IN QP_PREQ_GRP.CONTROL_RECORD_TYPE,
420: x_line_tbl OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
421: x_line_qual OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
422: x_line_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
423: x_line_detail_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
424: x_line_detail_qual_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
425: x_line_detail_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
426: x_related_lines_tbl OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
427: x_return_status OUT NOCOPY VARCHAR2,

Line 424: x_line_detail_qual_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,

420: x_line_tbl OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
421: x_line_qual OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
422: x_line_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
423: x_line_detail_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
424: x_line_detail_qual_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
425: x_line_detail_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
426: x_related_lines_tbl OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
427: x_return_status OUT NOCOPY VARCHAR2,
428: x_return_status_text OUT NOCOPY VARCHAR2

Line 425: x_line_detail_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,

421: x_line_qual OUT NOCOPY QP_PREQ_GRP.QUAL_TBL_TYPE,
422: x_line_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
423: x_line_detail_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
424: x_line_detail_qual_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
425: x_line_detail_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
426: x_related_lines_tbl OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
427: x_return_status OUT NOCOPY VARCHAR2,
428: x_return_status_text OUT NOCOPY VARCHAR2
429: );

Line 426: x_related_lines_tbl OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,

422: x_line_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
423: x_line_detail_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
424: x_line_detail_qual_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
425: x_line_detail_attr_tbl OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
426: x_related_lines_tbl OUT NOCOPY QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
427: x_return_status OUT NOCOPY VARCHAR2,
428: x_return_status_text OUT NOCOPY VARCHAR2
429: );
430:

Line 442: (p_control_rec IN QP_PREQ_GRP.CONTROL_RECORD_TYPE,

438: RETURN BOOLEAN;
439:
440: --overloaded for applications who insert into temp tables directly
441: PROCEDURE PRICE_REQUEST
442: (p_control_rec IN QP_PREQ_GRP.CONTROL_RECORD_TYPE,
443: x_return_status OUT NOCOPY VARCHAR2,
444: x_return_status_text OUT NOCOPY VARCHAR2
445: );
446:

Line 502: G_BUYLINE_PRICE_FLAG QP_PREQ_GRP.FLAG_TYPE;

498: G_NOT_VALID CONSTANT VARCHAR2(30) := 'NOT_VALID';
499: G_REQUEST_TYPE_CODE VARCHAR2(30);
500: G_CHECK_CUST_VIEW_FLAG VARCHAR2(30);
501:
502: G_BUYLINE_PRICE_FLAG QP_PREQ_GRP.FLAG_TYPE;
503: G_GET_FREIGHT_FLAG VARCHAR2(1);
504:
505: --2388011
506: G_PBHVOLATTR_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE;

Line 506: G_PBHVOLATTR_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE;

502: G_BUYLINE_PRICE_FLAG QP_PREQ_GRP.FLAG_TYPE;
503: G_GET_FREIGHT_FLAG VARCHAR2(1);
504:
505: --2388011
506: G_PBHVOLATTR_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE;
507:
508: --procedure to return price and status code and text -- needed by PO team
509: PROCEDURE get_price_for_line(p_line_index IN NUMBER,
510: p_line_id IN NUMBER,

Line 523: G_PBH_MOD_LEVEL_CODE QP_PREQ_GRP.varchar_type;

519: G_LINE_INDEXES_FOR_LINE_ID varchar2000_tbl_type; -- bug 3618464
520: G_BUYLINE_INDEXES_FOR_LINE_ID varchar2000_tbl_type; -- bug 3721860
521:
522: --4900095
523: G_PBH_MOD_LEVEL_CODE QP_PREQ_GRP.varchar_type;
524: G_Service_pbh_lg_amt_qty QP_PREQ_GRP.number_type;
525:
526: END QP_PREQ_PUB;

Line 524: G_Service_pbh_lg_amt_qty QP_PREQ_GRP.number_type;

520: G_BUYLINE_INDEXES_FOR_LINE_ID varchar2000_tbl_type; -- bug 3721860
521:
522: --4900095
523: G_PBH_MOD_LEVEL_CODE QP_PREQ_GRP.varchar_type;
524: G_Service_pbh_lg_amt_qty QP_PREQ_GRP.number_type;
525:
526: END QP_PREQ_PUB;