DBA Data[Home] [Help]

APPS.QP_PRICE_LIST_PUB dependencies on QP_QUALIFIER_RULES_PUB

Line 13: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

9:
10: PROCEDURE Id_To_Value
11: ( p_PRICE_LIST_rec IN Price_List_Rec_Type
12: , p_PRICE_LIST_LINE_tbl IN Price_List_Line_Tbl_Type
13: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
14: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type
15: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Val_Rec_Type
16: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ Price_List_Line_Val_Tbl_Type
17: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type

Line 17: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type

13: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
14: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type
15: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Val_Rec_Type
16: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ Price_List_Line_Val_Tbl_Type
17: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
18: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Val_Tbl_Type
19: );
20:
21: -- Forward declaration of procedure Value_To_Id

Line 29: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

25: , p_PRICE_LIST_rec IN Price_List_Rec_Type
26: , p_PRICE_LIST_val_rec IN Price_List_Val_Rec_Type
27: , p_PRICE_LIST_LINE_tbl IN Price_List_Line_Tbl_Type
28: , p_PRICE_LIST_LINE_val_tbl IN Price_List_Line_Val_Tbl_Type
29: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
30: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
31: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type
32: , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type
33: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Rec_Type

Line 30: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type

26: , p_PRICE_LIST_val_rec IN Price_List_Val_Rec_Type
27: , p_PRICE_LIST_LINE_tbl IN Price_List_Line_Tbl_Type
28: , p_PRICE_LIST_LINE_val_tbl IN Price_List_Line_Val_Tbl_Type
29: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
30: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
31: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type
32: , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type
33: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Rec_Type
34: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ Price_List_Line_Tbl_Type

Line 35: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

31: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type
32: , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type
33: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Rec_Type
34: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ Price_List_Line_Tbl_Type
35: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
36: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Tbl_Type
37: );
38:
39: -- Start of Comments

Line 71: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=

67: , p_PRICE_LIST_LINE_tbl IN Price_List_Line_Tbl_Type :=
68: G_MISS_PRICE_LIST_LINE_TBL
69: , p_PRICE_LIST_LINE_val_tbl IN Price_List_Line_Val_Tbl_Type :=
70: G_MISS_PRICE_LIST_LINE_VAL_TBL
71: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
72: G_MISS_QUALIFIERS_TBL
73: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
74: G_MISS_QUALIFIERS_VAL_TBL
75: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type :=

Line 73: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=

69: , p_PRICE_LIST_LINE_val_tbl IN Price_List_Line_Val_Tbl_Type :=
70: G_MISS_PRICE_LIST_LINE_VAL_TBL
71: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
72: G_MISS_QUALIFIERS_TBL
73: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
74: G_MISS_QUALIFIERS_VAL_TBL
75: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type :=
76: G_MISS_PRICING_ATTR_TBL
77: , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type :=

Line 83: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

79: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Rec_Type
80: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Val_Rec_Type
81: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ Price_List_Line_Tbl_Type
82: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ Price_List_Line_Val_Tbl_Type
83: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
84: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
85: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Tbl_Type
86: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Val_Tbl_Type
87: , p_check_duplicate_lines IN VARCHAR2 DEFAULT NULL --5018856, 5024801, 5024919

Line 84: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type

80: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Val_Rec_Type
81: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ Price_List_Line_Tbl_Type
82: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ Price_List_Line_Val_Tbl_Type
83: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
84: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
85: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Tbl_Type
86: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Val_Tbl_Type
87: , p_check_duplicate_lines IN VARCHAR2 DEFAULT NULL --5018856, 5024801, 5024919
88: )

Line 96: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

92: l_control_rec QP_GLOBALS.Control_Rec_Type;
93: l_return_status VARCHAR2(1);
94: l_PRICE_LIST_rec Price_List_Rec_Type;
95: l_PRICE_LIST_LINE_tbl Price_List_Line_Tbl_Type;
96: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
97: l_PRICING_ATTR_tbl Pricing_Attr_Tbl_Type;
98: l_installed_status VARCHAR2(1);
99: l_request_type_code VARCHAR2(3);
100: l_list_source_code VARCHAR2(10); -- bug#3599792

Line 104: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type; --[prarasto]

100: l_list_source_code VARCHAR2(10); -- bug#3599792
101:
102: l_p_PRICE_LIST_rec Price_List_Rec_Type; --[prarasto]
103: l_p_PRICE_LIST_LINE_tbl Price_List_Line_Tbl_Type; --[prarasto]
104: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type; --[prarasto]
105: l_p_PRICING_ATTR_tbl Pricing_Attr_Tbl_Type; --[prarasto]
106:
107: BEGIN
108:

Line 404: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=

400: , p_PRICE_LIST_LINE_tbl IN Price_List_Line_Tbl_Type :=
401: G_MISS_PRICE_LIST_LINE_TBL
402: , p_PRICE_LIST_LINE_val_tbl IN Price_List_Line_Val_Tbl_Type :=
403: G_MISS_PRICE_LIST_LINE_VAL_TBL
404: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
405: G_MISS_QUALIFIERS_TBL
406: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
407: G_MISS_QUALIFIERS_VAL_TBL
408: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type :=

Line 406: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=

402: , p_PRICE_LIST_LINE_val_tbl IN Price_List_Line_Val_Tbl_Type :=
403: G_MISS_PRICE_LIST_LINE_VAL_TBL
404: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
405: G_MISS_QUALIFIERS_TBL
406: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
407: G_MISS_QUALIFIERS_VAL_TBL
408: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type :=
409: G_MISS_PRICING_ATTR_TBL
410: , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type :=

Line 416: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

412: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Rec_Type
413: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Val_Rec_Type
414: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ Price_List_Line_Tbl_Type
415: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ Price_List_Line_Val_Tbl_Type
416: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
417: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
418: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Tbl_Type
419: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Val_Tbl_Type
420: )

Line 417: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type

413: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Val_Rec_Type
414: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ Price_List_Line_Tbl_Type
415: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ Price_List_Line_Val_Tbl_Type
416: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
417: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
418: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Tbl_Type
419: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Val_Tbl_Type
420: )
421: IS

Line 427: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

423: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Price_List';
424: l_return_status VARCHAR2(1);
425: l_PRICE_LIST_rec Price_List_Rec_Type;
426: l_PRICE_LIST_LINE_tbl Price_List_Line_Tbl_Type;
427: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
428: l_PRICING_ATTR_tbl Pricing_Attr_Tbl_Type;
429:
430: l_p_PRICE_LIST_rec Price_List_Rec_Type; --[prarasto]
431: l_p_PRICE_LIST_LINE_tbl Price_List_Line_Tbl_Type; --[prarasto]

Line 432: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type; --[prarasto]

428: l_PRICING_ATTR_tbl Pricing_Attr_Tbl_Type;
429:
430: l_p_PRICE_LIST_rec Price_List_Rec_Type; --[prarasto]
431: l_p_PRICE_LIST_LINE_tbl Price_List_Line_Tbl_Type; --[prarasto]
432: l_p_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type; --[prarasto]
433: l_p_PRICING_ATTR_tbl Pricing_Attr_Tbl_Type; --[prarasto]
434:
435: BEGIN
436:

Line 607: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

603: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Rec_Type
604: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Val_Rec_Type
605: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ Price_List_Line_Tbl_Type
606: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ Price_List_Line_Val_Tbl_Type
607: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
608: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
609: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Tbl_Type
610: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Val_Tbl_Type
611: )

Line 608: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type

604: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Val_Rec_Type
605: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ Price_List_Line_Tbl_Type
606: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ Price_List_Line_Val_Tbl_Type
607: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
608: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
609: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Tbl_Type
610: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Val_Tbl_Type
611: )
612: IS

Line 618: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;

614: l_api_name CONSTANT VARCHAR2(30):= 'Get_Price_List';
615: l_list_header_id NUMBER := p_list_header_id;
616: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type;
617: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
618: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
619: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
620: BEGIN
621:
622: -- Standard call to check for call compatibility

Line 789: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

785:
786: PROCEDURE Id_To_Value
787: ( p_PRICE_LIST_rec IN Price_List_Rec_Type
788: , p_PRICE_LIST_LINE_tbl IN Price_List_Line_Tbl_Type
789: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
790: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type
791: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Val_Rec_Type
792: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ Price_List_Line_Val_Tbl_Type
793: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type

Line 793: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type

789: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
790: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type
791: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Val_Rec_Type
792: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ Price_List_Line_Val_Tbl_Type
793: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
794: , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Val_Tbl_Type
795: )
796: IS
797: BEGIN

Line 849: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

845: , p_PRICE_LIST_rec IN Price_List_Rec_Type
846: , p_PRICE_LIST_val_rec IN Price_List_Val_Rec_Type
847: , p_PRICE_LIST_LINE_tbl IN Price_List_Line_Tbl_Type
848: , p_PRICE_LIST_LINE_val_tbl IN Price_List_Line_Val_Tbl_Type
849: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
850: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
851: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type
852: , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type
853: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Rec_Type

Line 850: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type

846: , p_PRICE_LIST_val_rec IN Price_List_Val_Rec_Type
847: , p_PRICE_LIST_LINE_tbl IN Price_List_Line_Tbl_Type
848: , p_PRICE_LIST_LINE_val_tbl IN Price_List_Line_Val_Tbl_Type
849: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
850: , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
851: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type
852: , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type
853: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Rec_Type
854: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ Price_List_Line_Tbl_Type

Line 855: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

851: , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type
852: , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type
853: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Rec_Type
854: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ Price_List_Line_Tbl_Type
855: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
856: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Tbl_Type
857: )
858: IS
859: l_PRICE_LIST_rec Price_List_Rec_Type;

Line 861: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;

857: )
858: IS
859: l_PRICE_LIST_rec Price_List_Rec_Type;
860: l_PRICE_LIST_LINE_rec Price_List_Line_Rec_Type;
861: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
862: l_PRICING_ATTR_rec Pricing_Attr_Rec_Type;
863: l_index BINARY_INTEGER;
864: BEGIN
865: