APPS.OE_PRICING_CONT_PUB dependencies on QP_PRICE_LIST_PUB

Line 408: G_MISS_PRICE_LIST_REC QP_Price_List_PUB.Price_List_Rec_Type;

404: G_MISS_AGREEMENT_REC Agreement_Rec_Type;
405: G_MISS_AGREEMENT_VAL_REC Agreement_Val_Rec_Type;
406: G_MISS_AGREEMENT_TBL Agreement_Tbl_Type;
407: G_MISS_AGREEMENT_VAL_TBL Agreement_Val_Tbl_Type;
408: G_MISS_PRICE_LIST_REC QP_Price_List_PUB.Price_List_Rec_Type;
409: G_MISS_PRICE_LIST_VAL_REC QP_Price_List_PUB.Price_List_Val_Rec_Type;
410: G_MISS_PRICE_LIST_TBL QP_Price_List_PUB.Price_List_Tbl_Type;
411: G_MISS_PRICE_LIST_VAL_TBL QP_Price_List_PUB.Price_List_Val_Tbl_Type;
412: G_MISS_PRICE_LIST_LINE_REC QP_Price_List_PUB.Price_List_Line_Rec_Type;

Line 409: G_MISS_PRICE_LIST_VAL_REC QP_Price_List_PUB.Price_List_Val_Rec_Type;

405: G_MISS_AGREEMENT_VAL_REC Agreement_Val_Rec_Type;
406: G_MISS_AGREEMENT_TBL Agreement_Tbl_Type;
407: G_MISS_AGREEMENT_VAL_TBL Agreement_Val_Tbl_Type;
408: G_MISS_PRICE_LIST_REC QP_Price_List_PUB.Price_List_Rec_Type;
409: G_MISS_PRICE_LIST_VAL_REC QP_Price_List_PUB.Price_List_Val_Rec_Type;
410: G_MISS_PRICE_LIST_TBL QP_Price_List_PUB.Price_List_Tbl_Type;
411: G_MISS_PRICE_LIST_VAL_TBL QP_Price_List_PUB.Price_List_Val_Tbl_Type;
412: G_MISS_PRICE_LIST_LINE_REC QP_Price_List_PUB.Price_List_Line_Rec_Type;
413: G_MISS_PRICE_LIST_LINE_VAL_REC QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;

Line 410: G_MISS_PRICE_LIST_TBL QP_Price_List_PUB.Price_List_Tbl_Type;

406: G_MISS_AGREEMENT_TBL Agreement_Tbl_Type;
407: G_MISS_AGREEMENT_VAL_TBL Agreement_Val_Tbl_Type;
408: G_MISS_PRICE_LIST_REC QP_Price_List_PUB.Price_List_Rec_Type;
409: G_MISS_PRICE_LIST_VAL_REC QP_Price_List_PUB.Price_List_Val_Rec_Type;
410: G_MISS_PRICE_LIST_TBL QP_Price_List_PUB.Price_List_Tbl_Type;
411: G_MISS_PRICE_LIST_VAL_TBL QP_Price_List_PUB.Price_List_Val_Tbl_Type;
412: G_MISS_PRICE_LIST_LINE_REC QP_Price_List_PUB.Price_List_Line_Rec_Type;
413: G_MISS_PRICE_LIST_LINE_VAL_REC QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;
414: G_MISS_PRICE_LIST_LINE_TBL QP_Price_List_PUB.Price_List_Line_Tbl_Type;

Line 411: G_MISS_PRICE_LIST_VAL_TBL QP_Price_List_PUB.Price_List_Val_Tbl_Type;

407: G_MISS_AGREEMENT_VAL_TBL Agreement_Val_Tbl_Type;
408: G_MISS_PRICE_LIST_REC QP_Price_List_PUB.Price_List_Rec_Type;
409: G_MISS_PRICE_LIST_VAL_REC QP_Price_List_PUB.Price_List_Val_Rec_Type;
410: G_MISS_PRICE_LIST_TBL QP_Price_List_PUB.Price_List_Tbl_Type;
411: G_MISS_PRICE_LIST_VAL_TBL QP_Price_List_PUB.Price_List_Val_Tbl_Type;
412: G_MISS_PRICE_LIST_LINE_REC QP_Price_List_PUB.Price_List_Line_Rec_Type;
413: G_MISS_PRICE_LIST_LINE_VAL_REC QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;
414: G_MISS_PRICE_LIST_LINE_TBL QP_Price_List_PUB.Price_List_Line_Tbl_Type;
415: G_MISS_PRICE_LIST_LINE_VAL_TBL QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type;

Line 412: G_MISS_PRICE_LIST_LINE_REC QP_Price_List_PUB.Price_List_Line_Rec_Type;

408: G_MISS_PRICE_LIST_REC QP_Price_List_PUB.Price_List_Rec_Type;
409: G_MISS_PRICE_LIST_VAL_REC QP_Price_List_PUB.Price_List_Val_Rec_Type;
410: G_MISS_PRICE_LIST_TBL QP_Price_List_PUB.Price_List_Tbl_Type;
411: G_MISS_PRICE_LIST_VAL_TBL QP_Price_List_PUB.Price_List_Val_Tbl_Type;
412: G_MISS_PRICE_LIST_LINE_REC QP_Price_List_PUB.Price_List_Line_Rec_Type;
413: G_MISS_PRICE_LIST_LINE_VAL_REC QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;
414: G_MISS_PRICE_LIST_LINE_TBL QP_Price_List_PUB.Price_List_Line_Tbl_Type;
415: G_MISS_PRICE_LIST_LINE_VAL_TBL QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type;
416: G_MISS_QUALIFIERS_REC QP_Qualifier_Rules_Pub.Qualifiers_Rec_Type;

Line 413: G_MISS_PRICE_LIST_LINE_VAL_REC QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;

409: G_MISS_PRICE_LIST_VAL_REC QP_Price_List_PUB.Price_List_Val_Rec_Type;
410: G_MISS_PRICE_LIST_TBL QP_Price_List_PUB.Price_List_Tbl_Type;
411: G_MISS_PRICE_LIST_VAL_TBL QP_Price_List_PUB.Price_List_Val_Tbl_Type;
412: G_MISS_PRICE_LIST_LINE_REC QP_Price_List_PUB.Price_List_Line_Rec_Type;
413: G_MISS_PRICE_LIST_LINE_VAL_REC QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;
414: G_MISS_PRICE_LIST_LINE_TBL QP_Price_List_PUB.Price_List_Line_Tbl_Type;
415: G_MISS_PRICE_LIST_LINE_VAL_TBL QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type;
416: G_MISS_QUALIFIERS_REC QP_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
417: G_MISS_QUALIFIERS_VAL_REC QP_Qualifier_Rules_Pub.Qualifiers_Val_Rec_Type;

Line 414: G_MISS_PRICE_LIST_LINE_TBL QP_Price_List_PUB.Price_List_Line_Tbl_Type;

410: G_MISS_PRICE_LIST_TBL QP_Price_List_PUB.Price_List_Tbl_Type;
411: G_MISS_PRICE_LIST_VAL_TBL QP_Price_List_PUB.Price_List_Val_Tbl_Type;
412: G_MISS_PRICE_LIST_LINE_REC QP_Price_List_PUB.Price_List_Line_Rec_Type;
413: G_MISS_PRICE_LIST_LINE_VAL_REC QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;
414: G_MISS_PRICE_LIST_LINE_TBL QP_Price_List_PUB.Price_List_Line_Tbl_Type;
415: G_MISS_PRICE_LIST_LINE_VAL_TBL QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type;
416: G_MISS_QUALIFIERS_REC QP_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
417: G_MISS_QUALIFIERS_VAL_REC QP_Qualifier_Rules_Pub.Qualifiers_Val_Rec_Type;
418: G_MISS_QUALIFIERS_TBL QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

Line 415: G_MISS_PRICE_LIST_LINE_VAL_TBL QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type;

411: G_MISS_PRICE_LIST_VAL_TBL QP_Price_List_PUB.Price_List_Val_Tbl_Type;
412: G_MISS_PRICE_LIST_LINE_REC QP_Price_List_PUB.Price_List_Line_Rec_Type;
413: G_MISS_PRICE_LIST_LINE_VAL_REC QP_Price_List_PUB.Price_List_Line_Val_Rec_Type;
414: G_MISS_PRICE_LIST_LINE_TBL QP_Price_List_PUB.Price_List_Line_Tbl_Type;
415: G_MISS_PRICE_LIST_LINE_VAL_TBL QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type;
416: G_MISS_QUALIFIERS_REC QP_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
417: G_MISS_QUALIFIERS_VAL_REC QP_Qualifier_Rules_Pub.Qualifiers_Val_Rec_Type;
418: G_MISS_QUALIFIERS_TBL QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
419: G_MISS_QUALIFIERS_VAL_TBL QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;

Line 420: G_MISS_PRICING_ATTR_REC QP_Price_List_PUB.Pricing_Attr_Rec_Type;

416: G_MISS_QUALIFIERS_REC QP_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
417: G_MISS_QUALIFIERS_VAL_REC QP_Qualifier_Rules_Pub.Qualifiers_Val_Rec_Type;
418: G_MISS_QUALIFIERS_TBL QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
419: G_MISS_QUALIFIERS_VAL_TBL QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
420: G_MISS_PRICING_ATTR_REC QP_Price_List_PUB.Pricing_Attr_Rec_Type;
421: G_MISS_PRICING_ATTR_VAL_REC QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type;
422: G_MISS_PRICING_ATTR_TBL QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
423: G_MISS_PRICING_ATTR_VAL_TBL QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type;
424:

Line 421: G_MISS_PRICING_ATTR_VAL_REC QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type;

417: G_MISS_QUALIFIERS_VAL_REC QP_Qualifier_Rules_Pub.Qualifiers_Val_Rec_Type;
418: G_MISS_QUALIFIERS_TBL QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
419: G_MISS_QUALIFIERS_VAL_TBL QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
420: G_MISS_PRICING_ATTR_REC QP_Price_List_PUB.Pricing_Attr_Rec_Type;
421: G_MISS_PRICING_ATTR_VAL_REC QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type;
422: G_MISS_PRICING_ATTR_TBL QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
423: G_MISS_PRICING_ATTR_VAL_TBL QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type;
424:
425:

Line 422: G_MISS_PRICING_ATTR_TBL QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

418: G_MISS_QUALIFIERS_TBL QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
419: G_MISS_QUALIFIERS_VAL_TBL QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
420: G_MISS_PRICING_ATTR_REC QP_Price_List_PUB.Pricing_Attr_Rec_Type;
421: G_MISS_PRICING_ATTR_VAL_REC QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type;
422: G_MISS_PRICING_ATTR_TBL QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
423: G_MISS_PRICING_ATTR_VAL_TBL QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type;
424:
425:
426: G_MISS_CONTRACT_REC Contract_Rec_Type;

Line 423: G_MISS_PRICING_ATTR_VAL_TBL QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type;

419: G_MISS_QUALIFIERS_VAL_TBL QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
420: G_MISS_PRICING_ATTR_REC QP_Price_List_PUB.Pricing_Attr_Rec_Type;
421: G_MISS_PRICING_ATTR_VAL_REC QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type;
422: G_MISS_PRICING_ATTR_TBL QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
423: G_MISS_PRICING_ATTR_VAL_TBL QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type;
424:
425:
426: G_MISS_CONTRACT_REC Contract_Rec_Type;
427: G_MISS_CONTRACT_VAL_REC Contract_Val_Rec_Type;

Line 478: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=

474: , p_Agreement_rec IN Agreement_Rec_Type :=
475: G_MISS_AGREEMENT_REC
476: , p_Agreement_val_rec IN Agreement_Val_Rec_Type :=
477: G_MISS_AGREEMENT_VAL_REC
478: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
479: G_MISS_PRICE_LIST_REC
480: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
481: G_MISS_PRICE_LIST_VAL_REC
482: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=

Line 480: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=

476: , p_Agreement_val_rec IN Agreement_Val_Rec_Type :=
477: G_MISS_AGREEMENT_VAL_REC
478: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
479: G_MISS_PRICE_LIST_REC
480: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
481: G_MISS_PRICE_LIST_VAL_REC
482: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
483: G_MISS_PRICE_LIST_LINE_TBL
484: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=

Line 482: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=

478: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
479: G_MISS_PRICE_LIST_REC
480: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
481: G_MISS_PRICE_LIST_VAL_REC
482: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
483: G_MISS_PRICE_LIST_LINE_TBL
484: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
485: G_MISS_PRICE_LIST_LINE_VAL_TBL
486: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=

Line 484: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=

480: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
481: G_MISS_PRICE_LIST_VAL_REC
482: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
483: G_MISS_PRICE_LIST_LINE_TBL
484: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
485: G_MISS_PRICE_LIST_LINE_VAL_TBL
486: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
487: G_MISS_PRICING_ATTR_TBL
488: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=

Line 486: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=

482: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
483: G_MISS_PRICE_LIST_LINE_TBL
484: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
485: G_MISS_PRICE_LIST_LINE_VAL_TBL
486: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
487: G_MISS_PRICING_ATTR_TBL
488: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
489: G_MISS_PRICING_ATTR_VAL_TBL
490: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type

Line 488: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=

484: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
485: G_MISS_PRICE_LIST_LINE_VAL_TBL
486: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
487: G_MISS_PRICING_ATTR_TBL
488: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
489: G_MISS_PRICING_ATTR_VAL_TBL
490: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
491: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
492: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

Line 492: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

488: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
489: G_MISS_PRICING_ATTR_VAL_TBL
490: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
491: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
492: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
493: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
494: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
495: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
496: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

Line 493: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type

489: G_MISS_PRICING_ATTR_VAL_TBL
490: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
491: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
492: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
493: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
494: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
495: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
496: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
497: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

Line 494: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type

490: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
491: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
492: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
493: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
494: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
495: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
496: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
497: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
498: , p_check_duplicate_lines IN VARCHAR2 DEFAULT NULL --5018856, 5024801, 5024919

Line 495: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type

491: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
492: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
493: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
494: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
495: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
496: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
497: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
498: , p_check_duplicate_lines IN VARCHAR2 DEFAULT NULL --5018856, 5024801, 5024919
499: );

Line 496: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

492: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
493: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
494: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
495: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
496: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
497: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
498: , p_check_duplicate_lines IN VARCHAR2 DEFAULT NULL --5018856, 5024801, 5024919
499: );
500:

Line 497: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

493: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
494: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
495: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
496: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
497: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
498: , p_check_duplicate_lines IN VARCHAR2 DEFAULT NULL --5018856, 5024801, 5024919
499: );
500:
501: -- Start of Comments

Line 528: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=

524: , p_Agreement_rec IN Agreement_Rec_Type :=
525: G_MISS_AGREEMENT_REC
526: , p_Agreement_val_rec IN Agreement_Val_Rec_Type :=
527: G_MISS_AGREEMENT_VAL_REC
528: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
529: G_MISS_PRICE_LIST_REC
530: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
531: G_MISS_PRICE_LIST_VAL_REC
532: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=

Line 530: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=

526: , p_Agreement_val_rec IN Agreement_Val_Rec_Type :=
527: G_MISS_AGREEMENT_VAL_REC
528: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
529: G_MISS_PRICE_LIST_REC
530: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
531: G_MISS_PRICE_LIST_VAL_REC
532: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
533: G_MISS_PRICE_LIST_LINE_TBL
534: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=

Line 532: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=

528: , p_Price_LHeader_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
529: G_MISS_PRICE_LIST_REC
530: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
531: G_MISS_PRICE_LIST_VAL_REC
532: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
533: G_MISS_PRICE_LIST_LINE_TBL
534: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
535: G_MISS_PRICE_LIST_LINE_VAL_TBL
536: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=

Line 534: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=

530: , p_Price_LHeader_val_rec IN QP_Price_List_PUB.Price_List_Val_Rec_Type :=
531: G_MISS_PRICE_LIST_VAL_REC
532: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
533: G_MISS_PRICE_LIST_LINE_TBL
534: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
535: G_MISS_PRICE_LIST_LINE_VAL_TBL
536: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
537: G_MISS_PRICING_ATTR_TBL
538: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=

Line 536: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=

532: , p_Price_LLine_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type :=
533: G_MISS_PRICE_LIST_LINE_TBL
534: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
535: G_MISS_PRICE_LIST_LINE_VAL_TBL
536: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
537: G_MISS_PRICING_ATTR_TBL
538: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
539: G_MISS_PRICING_ATTR_VAL_TBL
540: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type

Line 538: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=

534: , p_Price_LLine_val_tbl IN QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type :=
535: G_MISS_PRICE_LIST_LINE_VAL_TBL
536: , p_Pricing_Attr_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type :=
537: G_MISS_PRICING_ATTR_TBL
538: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
539: G_MISS_PRICING_ATTR_VAL_TBL
540: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
541: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
542: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

Line 542: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

538: , p_Pricing_Attr_val_tbl IN QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type :=
539: G_MISS_PRICING_ATTR_VAL_TBL
540: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
541: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
542: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
543: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
544: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
545: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
546: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

Line 543: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type

539: G_MISS_PRICING_ATTR_VAL_TBL
540: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
541: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
542: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
543: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
544: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
545: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
546: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
547: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

Line 544: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type

540: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
541: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
542: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
543: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
544: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
545: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
546: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
547: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
548: );

Line 545: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type

541: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
542: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
543: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
544: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
545: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
546: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
547: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
548: );
549:

Line 546: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

542: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
543: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
544: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
545: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
546: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
547: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
548: );
549:
550: -- Start of Comments

Line 547: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

543: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
544: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
545: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
546: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
547: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
548: );
549:
550: -- Start of Comments
551: -- API name Get_Agreement

Line 578: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

574: /*, p_agreement IN VARCHAR2 := FND_API.G_MISS_CHAR
575: , p_revision IN VARCHAR2 := FND_API.G_MISS_CHAR */
576: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
577: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
578: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
579: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
580: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
581: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
582: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

Line 579: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type

575: , p_revision IN VARCHAR2 := FND_API.G_MISS_CHAR */
576: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
577: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
578: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
579: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
580: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
581: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
582: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
583: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

Line 580: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type

576: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
577: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
578: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
579: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
580: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
581: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
582: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
583: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
584: );

Line 581: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type

577: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
578: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
579: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
580: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
581: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
582: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
583: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
584: );
585:

Line 582: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

578: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
579: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
580: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
581: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
582: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
583: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
584: );
585:
586: END OE_Pricing_Cont_PUB;

Line 583: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type

579: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
580: , x_Price_LLine_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
581: , x_Price_LLine_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type
582: , x_Pricing_Attr_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
583: , x_Pricing_Attr_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Val_Tbl_Type
584: );
585:
586: END OE_Pricing_Cont_PUB;