DBA Data[Home] [Help]

APPS.OE_ORDER_ADJ_PVT dependencies on QP_ATTR_MAPPING_PUB

Line 4374: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type

4370: end copy_adjs_to_request;
4371:
4372: procedure copy_attribs_to_Req(
4373: p_line_index number
4374: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
4375: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
4376: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
4377: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
4378: )

Line 4375: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type

4371:
4372: procedure copy_attribs_to_Req(
4373: p_line_index number
4374: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
4375: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
4376: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
4377: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
4378: )
4379: is

Line 5563: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

5559: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
5560: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
5561: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
5562: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
5563: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
5564: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
5565: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
5566: lx_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
5567: lx_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

Line 5564: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

5560: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
5561: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
5562: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
5563: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
5564: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
5565: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
5566: lx_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
5567: lx_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
5568: lx_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

Line 5889: adj_debug('Before QP_Attr_Mapping_PUB.Build_Contexts for line',1);

5885: If l_bypass_pricing = 'Y' Then
5886:
5887: adj_debug('Bypassing the qualifier build',1);
5888: Else
5889: adj_debug('Before QP_Attr_Mapping_PUB.Build_Contexts for line',1);
5890: Begin
5891: QP_Attr_Mapping_PUB.Build_Contexts(
5892: p_request_type_code => 'ONT',
5893: p_pricing_type => 'L',

Line 5891: QP_Attr_Mapping_PUB.Build_Contexts(

5887: adj_debug('Bypassing the qualifier build',1);
5888: Else
5889: adj_debug('Before QP_Attr_Mapping_PUB.Build_Contexts for line',1);
5890: Begin
5891: QP_Attr_Mapping_PUB.Build_Contexts(
5892: p_request_type_code => 'ONT',
5893: p_pricing_type => 'L',
5894: x_price_contexts_result_tbl => l_pricing_contexts_Tbl,
5895: x_qual_contexts_result_tbl => l_qualifier_Contexts_Tbl

Line 6006: adj_debug('Before QP_Attr_Mapping_PUB.Build_Contexts for Header',1);

6002: If l_bypass_pricing = 'Y' Then
6003:
6004: adj_debug('Bypassing the qualifier build',1);
6005: Else
6006: adj_debug('Before QP_Attr_Mapping_PUB.Build_Contexts for Header',1);
6007: Begin
6008: QP_Attr_Mapping_PUB.Build_Contexts(
6009: p_request_type_code => 'ONT',
6010: p_pricing_type => 'H',

Line 6008: QP_Attr_Mapping_PUB.Build_Contexts(

6004: adj_debug('Bypassing the qualifier build',1);
6005: Else
6006: adj_debug('Before QP_Attr_Mapping_PUB.Build_Contexts for Header',1);
6007: Begin
6008: QP_Attr_Mapping_PUB.Build_Contexts(
6009: p_request_type_code => 'ONT',
6010: p_pricing_type => 'H',
6011: x_price_contexts_result_tbl => l_pricing_contexts_Tbl,
6012: x_qual_contexts_result_tbl => l_qualifier_Contexts_Tbl

Line 12523: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

12519: As
12520: l_profile_value Varchar2(1):= Nvl(Fnd_Profile.Value('ONT_MANUAL_LINEGROUP'),'Y');
12521: l_line_tbl oe_Order_Pub.Line_tbl_Type;
12522: l_line_rec oe_order_pub.line_rec_type;
12523: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
12524: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
12525: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
12526: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
12527: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

Line 12524: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

12520: l_profile_value Varchar2(1):= Nvl(Fnd_Profile.Value('ONT_MANUAL_LINEGROUP'),'Y');
12521: l_line_tbl oe_Order_Pub.Line_tbl_Type;
12522: l_line_rec oe_order_pub.line_rec_type;
12523: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
12524: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
12525: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
12526: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
12527: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
12528: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

Line 12715: QP_Attr_Mapping_PUB.Build_Contexts(p_request_type_code => 'ONT',

12711: l_check_line_flag := 'N';
12712: ELSE
12713: l_check_line_flag := 'Y';
12714: END IF;
12715: QP_Attr_Mapping_PUB.Build_Contexts(p_request_type_code => 'ONT',
12716: p_pricing_type_code => 'L',
12717: p_line_index => line_Tbl_Index, --l_line_tbl(line_tbl_index).header_id + l_line_tbl(line_tbl_index).line_id,
12718: p_check_line_flag => l_check_line_flag, --5598523
12719: p_pricing_event => l_event,

Line 12722: QP_Attr_Mapping_PUB.Build_Contexts(p_request_type_code => 'ONT',

12718: p_check_line_flag => l_check_line_flag, --5598523
12719: p_pricing_event => l_event,
12720: x_pass_line => l_pass_line);
12721: ELSE
12722: QP_Attr_Mapping_PUB.Build_Contexts(p_request_type_code => 'ONT',
12723: p_pricing_type => 'L',
12724: x_price_contexts_result_tbl => l_pricing_contexts_Tbl,
12725: x_qual_contexts_result_tbl => l_qualifier_Contexts_Tbl);
12726: END IF;

Line 12831: QP_Attr_Mapping_PUB.Build_Contexts(

12827:
12828: Begin
12829: -- bucket man
12830: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' THEN
12831: QP_Attr_Mapping_PUB.Build_Contexts(
12832: p_request_type_code => 'ONT',
12833: p_pricing_type_code => 'H',
12834: p_line_index=> l_line_index + 1 --oe_order_pub.g_hdr.header_id
12835: );

Line 12837: QP_Attr_Mapping_PUB.Build_Contexts(

12833: p_pricing_type_code => 'H',
12834: p_line_index=> l_line_index + 1 --oe_order_pub.g_hdr.header_id
12835: );
12836: ELSE
12837: QP_Attr_Mapping_PUB.Build_Contexts(
12838: p_request_type_code => 'ONT',
12839: p_pricing_type => 'H',
12840: x_price_contexts_result_tbl => l_pricing_contexts_Tbl,
12841: x_qual_contexts_result_tbl => l_qualifier_Contexts_Tbl

Line 13180: FND_MESSAGE.SET_TOKEN('ERR_TEXT','Errors return from QP_Attr_Mapping_PUB.Build_Context');

13176: --DBMS_OUTPUT.PUT_LINE('G_EXC_UNEXPECTED_ERROR is '||l_return_status_Text);
13177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13178: WHEN QP_ATTR_MAPPING_ERRORS Then
13179: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
13180: FND_MESSAGE.SET_TOKEN('ERR_TEXT','Errors return from QP_Attr_Mapping_PUB.Build_Context');
13181: OE_MSG_PUB.Add;
13182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13183: Oe_Debug_Pub.add('G_EXC_UNEXPECTED_ERROR is: QP_Attr_Mapping_PUB.Build_Context'||sqlerrm,1);
13184: Oe_Debug_Pub.add('G_EXC_UNEXPECTED_ERROR is '||l_return_status_Text);

Line 13183: Oe_Debug_Pub.add('G_EXC_UNEXPECTED_ERROR is: QP_Attr_Mapping_PUB.Build_Context'||sqlerrm,1);

13179: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
13180: FND_MESSAGE.SET_TOKEN('ERR_TEXT','Errors return from QP_Attr_Mapping_PUB.Build_Context');
13181: OE_MSG_PUB.Add;
13182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13183: Oe_Debug_Pub.add('G_EXC_UNEXPECTED_ERROR is: QP_Attr_Mapping_PUB.Build_Context'||sqlerrm,1);
13184: Oe_Debug_Pub.add('G_EXC_UNEXPECTED_ERROR is '||l_return_status_Text);
13185: Oe_Debug_Pub.add('QP_ATTR_MAPPING_ERRORS');
13186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13187: WHEN OTHERS THEN