[Home] [Help]
53: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
54: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
55: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
56: l_req_adj_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
57: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
58: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
59: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
60: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
61: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
54: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
55: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
56: l_req_adj_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
57: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
58: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
59: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
60: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
61: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
62: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
55: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
56: l_req_adj_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
57: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
58: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
59: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
60: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
61: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
62: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
63: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
56: l_req_adj_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
57: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
58: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
59: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
60: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
61: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
62: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
63: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
64: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
130: p_qte_header_rec => p_qte_header_rec,
131: p_shipment_rec => p_hd_shipment_rec);
132:
133: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
134: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:QP_ATTR_MAPPING_PUB.Build_Contexts Starts',1,'Y');
135: END IF;
136: QP_ATTR_MAPPING_PUB.Build_Contexts (
137: P_REQUEST_TYPE_CODE => l_request_type,
138: P_PRICING_TYPE => 'H',
132:
133: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
134: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:QP_ATTR_MAPPING_PUB.Build_Contexts Starts',1,'Y');
135: END IF;
136: QP_ATTR_MAPPING_PUB.Build_Contexts (
137: P_REQUEST_TYPE_CODE => l_request_type,
138: P_PRICING_TYPE => 'H',
139: X_PRICE_CONTEXTS_RESULT_TBL => l_hd_pricing_contexts_tbl,
140: X_QUAL_CONTEXTS_RESULT_TBL => l_hd_qual_contexts_tbl);
138: P_PRICING_TYPE => 'H',
139: X_PRICE_CONTEXTS_RESULT_TBL => l_hd_pricing_contexts_tbl,
140: X_QUAL_CONTEXTS_RESULT_TBL => l_hd_qual_contexts_tbl);
141: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
142: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:QP_ATTR_MAPPING_PUB.Build_Contexts Ends',1,'Y');
143: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:Copy_Attribs_To_Req Starts',1,'Y');
144: END IF;
145:
146: Copy_Attribs_To_Req (
204: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
205: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:End Setting up the G_LINE_REC', 1, 'Y');
206: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:Begin Setting up the Build_Contexts', 1, 'Y');
207: END IF;
208: QP_ATTR_MAPPING_PUB.Build_Contexts (
209: P_REQUEST_TYPE_CODE => l_request_type,
210: P_PRICING_TYPE => 'L',
211: X_PRICE_CONTEXTS_RESULT_TBL => l_pricing_contexts_tbl,
212: X_QUAL_CONTEXTS_RESULT_TBL => l_qual_contexts_tbl);
473: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
474: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
475: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
476: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
477: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
478: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
479: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
480: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
481: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
474: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
475: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
476: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
477: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
478: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
479: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
480: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
481: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
482: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
475: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
476: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
477: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
478: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
479: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
480: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
481: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
482: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
483: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
476: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
477: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
478: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
479: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
480: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
481: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
482: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
483: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
484: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
625:
626:
627: PROCEDURE Copy_Attribs_To_Req(
628: p_line_index number,
629: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
630: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
631: px_Req_line_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
632: px_Req_qual_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.QUAL_TBL_TYPE)
633: IS
626:
627: PROCEDURE Copy_Attribs_To_Req(
628: p_line_index number,
629: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
630: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
631: px_Req_line_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
632: px_Req_qual_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.QUAL_TBL_TYPE)
633: IS
634: l_attr_index number := nvl(px_Req_line_attr_tbl.last,0);
673: end copy_attribs_to_Req;
674:
675: PROCEDURE Copy_hdr_attr_to_line(
676: p_line_index number,
677: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
678: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
679: px_Req_line_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
680: px_Req_qual_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.QUAL_TBL_TYPE)
681: IS
674:
675: PROCEDURE Copy_hdr_attr_to_line(
676: p_line_index number,
677: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
678: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
679: px_Req_line_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
680: px_Req_qual_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.QUAL_TBL_TYPE)
681: IS
682: l_attr_index number := nvl(px_Req_line_attr_tbl.last,0);