[Home] [Help]
PACKAGE: APPS.ASO_PRICING_CALLBACK_PVT
Source
1 PACKAGE ASO_PRICING_CALLBACK_PVT AUTHID CURRENT_USER as
2 /* $Header: asovpcls.pls 120.1 2005/06/29 12:43:03 appldev ship $ */
3 -- Start of Comments
4 -- Package name : ASO_PRICING_CALLBACK_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 TYPE Index_Link_Tbl_Type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
11 G_MISS_Link_Tbl Index_Link_Tbl_Type;
12
13 PROCEDURE Config_Callback_Pricing_Order(
14 P_Api_Version_Number IN NUMBER,
15 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
16 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
17 p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
18 p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
19 p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
20 := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
21 p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
22 := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
23 p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
24 p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
25 := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
26 p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
27 := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
28 p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
29 := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
30 p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
31 := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
32 x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
33 x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
34 x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
35 x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
36 x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
37 x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
38 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
39 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
40 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
41
42 PROCEDURE Config_Callback_Pricing_Order (
43 P_Api_Version_Number IN NUMBER,
44 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
45 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
46 p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
47 p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
48 p_qte_header_id IN NUMBER,
49 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
50 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
51 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
52
53
54 PROCEDURE Copy_Attribs_To_Req(
55 p_line_index number,
56 p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
57 p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
58 px_Req_line_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
59 px_Req_qual_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.QUAL_TBL_TYPE);
60
61 PROCEDURE Copy_hdr_attr_to_line(
62 p_line_index number,
63 p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
64 p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
65 px_Req_line_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
66 px_Req_qual_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.QUAL_TBL_TYPE);
67
68 procedure Append_asked_for(
69 p_header_id number := null
70 ,p_Line_id number := null
71 ,p_line_index number
72 ,px_Req_line_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
73 ,px_Req_qual_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.QUAL_TBL_TYPE);
74
75
76 procedure Append_asked_for(
77 p_line_index NUMBER,
78 p_pricing_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
79 px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
80 px_Req_qual_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.QUAL_TBL_TYPE);
81
82 procedure copy_Header_to_request(
83 p_Request_Type VARCHAR2,
84 p_pricing_event VARCHAR2,
85 p_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type,
86 px_req_line_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE);
87
88
89 PROCEDURE Copy_Req_Dtl_To_Price_Adj (
90 p_qte_line_index IN NUMBER,
91 p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
92 p_req_line_dtl_index IN NUMBER,
93 p_req_line_detail_rec IN QP_PREQ_GRP.LINE_DETAIL_REC_TYPE,
94 p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
95 p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
96 px_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
97 px_price_adj_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
98 px_price_adj_prcd IN OUT NOCOPY /* file.sql.39 change */ Index_Link_Tbl_Type);
99
100 PROCEDURE Copy_Req_Dtl_To_Price_Adj (
101 p_qte_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
102 p_req_line_dtl_index IN NUMBER,
103 p_req_line_detail_rec IN QP_PREQ_GRP.LINE_DETAIL_REC_TYPE,
104 p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
105 p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
106 px_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
107 px_price_adj_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
108 px_price_adj_prcd IN OUT NOCOPY /* file.sql.39 change */ Index_Link_Tbl_Type);
109
110 procedure copy_Line_to_request(
111 p_Request_Type VARCHAR2,
112 p_pricing_event VARCHAR2,
113 p_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type,
114 p_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
115 p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
116 px_req_line_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE);
117
118 PROCEDURE Copy_Request_To_Quote(
119 p_req_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,
120 p_req_line_qual IN QP_PREQ_GRP.QUAL_TBL_TYPE,
121 p_req_line_attr_tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
122 p_req_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
123 p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
124 p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
125 p_req_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
126 p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
127 p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
128 p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
129 x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
130 x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
131 x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
132 x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
133 x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
134 x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type);
135
136 -- Bug 2430068. This following procedure was copied from asoiprcb.pls.115.141 version
137 -- This is the right version as per vakapoor.
138 -- Original One was giving no data found.
139
140 PROCEDURE Copy_Request_To_Line(
141 p_req_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,
142 p_req_line_qual IN QP_PREQ_GRP.QUAL_TBL_TYPE,
143 p_req_line_attr_tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
144 p_req_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
145 p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
146 p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
147 p_req_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
148 p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
149 p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
150 x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
151 x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
152 x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
153 x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
154 x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type);
155
156
157 PROCEDURE Update_Quote_Rows(
158 P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
159 := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
160 P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
161 := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_tbl,
162 P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
163 := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
164 P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
165 := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
166 P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
167 := ASO_QUOTE_PUB.G_Miss_Price_Adj_Rltship_Tbl);
168
169
170 End ASO_PRICING_CALLBACK_PVT;