DBA Data[Home] [Help]

APPS.OE_ORDER_ADJ_PVT dependencies on QP_ATTR_MAPPING_PUB

Line 4457: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type

4453: end copy_adjs_to_request;
4454:
4455: procedure copy_attribs_to_Req(
4456: p_line_index number
4457: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
4458: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
4459: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
4460: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
4461: )

Line 4458: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type

4454:
4455: procedure copy_attribs_to_Req(
4456: p_line_index number
4457: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
4458: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
4459: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
4460: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
4461: )
4462: is

Line 5646: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

5642: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
5643: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
5644: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
5645: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
5646: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
5647: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
5648: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
5649: lx_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
5650: lx_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

Line 5647: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

5643: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
5644: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
5645: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
5646: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
5647: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
5648: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
5649: lx_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
5650: lx_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
5651: lx_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

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

5976: If l_bypass_pricing = 'Y' Then
5977:
5978: adj_debug('Bypassing the qualifier build',1);
5979: Else
5980: adj_debug('Before QP_Attr_Mapping_PUB.Build_Contexts for line',1);
5981: Begin
5982: QP_Attr_Mapping_PUB.Build_Contexts(
5983: p_request_type_code => 'ONT',
5984: p_pricing_type => 'L',

Line 5982: QP_Attr_Mapping_PUB.Build_Contexts(

5978: adj_debug('Bypassing the qualifier build',1);
5979: Else
5980: adj_debug('Before QP_Attr_Mapping_PUB.Build_Contexts for line',1);
5981: Begin
5982: QP_Attr_Mapping_PUB.Build_Contexts(
5983: p_request_type_code => 'ONT',
5984: p_pricing_type => 'L',
5985: x_price_contexts_result_tbl => l_pricing_contexts_Tbl,
5986: x_qual_contexts_result_tbl => l_qualifier_Contexts_Tbl

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

6093: If l_bypass_pricing = 'Y' Then
6094:
6095: adj_debug('Bypassing the qualifier build',1);
6096: Else
6097: adj_debug('Before QP_Attr_Mapping_PUB.Build_Contexts for Header',1);
6098: Begin
6099: QP_Attr_Mapping_PUB.Build_Contexts(
6100: p_request_type_code => 'ONT',
6101: p_pricing_type => 'H',

Line 6099: QP_Attr_Mapping_PUB.Build_Contexts(

6095: adj_debug('Bypassing the qualifier build',1);
6096: Else
6097: adj_debug('Before QP_Attr_Mapping_PUB.Build_Contexts for Header',1);
6098: Begin
6099: QP_Attr_Mapping_PUB.Build_Contexts(
6100: p_request_type_code => 'ONT',
6101: p_pricing_type => 'H',
6102: x_price_contexts_result_tbl => l_pricing_contexts_Tbl,
6103: x_qual_contexts_result_tbl => l_qualifier_Contexts_Tbl

Line 12678: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

12674: As
12675: l_profile_value Varchar2(1):= Nvl(Fnd_Profile.Value('ONT_MANUAL_LINEGROUP'),'Y');
12676: l_line_tbl oe_Order_Pub.Line_tbl_Type;
12677: l_line_rec oe_order_pub.line_rec_type;
12678: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
12679: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
12680: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
12681: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
12682: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

Line 12679: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

12675: l_profile_value Varchar2(1):= Nvl(Fnd_Profile.Value('ONT_MANUAL_LINEGROUP'),'Y');
12676: l_line_tbl oe_Order_Pub.Line_tbl_Type;
12677: l_line_rec oe_order_pub.line_rec_type;
12678: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
12679: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
12680: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
12681: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
12682: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
12683: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

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

12881: /* will increment the index by 1 initially, un-conditionally and will retain it or decrement it
12882: based on the the o/p for its Build Context.
12883: If -- QP says pass this line we will retain the index else we will decrement it. */
12884:
12885: QP_Attr_Mapping_PUB.Build_Contexts(p_request_type_code => 'ONT',
12886: p_pricing_type_code => 'L',
12887: --p_line_index => line_Tbl_Index, commeneted for BUG#8945171 --l_line_tbl(line_tbl_index).header_id + l_line_tbl(line_tbl_index).line_id,
12888: p_line_index => l_line_index, --added for BUG#8945171 from now on we will use l_line_index instead of line_Tbl_Index to build context for lines as this is the index we use to build the context for header also.
12889: p_check_line_flag => l_check_line_flag, --5598523

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

12889: p_check_line_flag => l_check_line_flag, --5598523
12890: p_pricing_event => l_event,
12891: x_pass_line => l_pass_line);
12892: ELSE
12893: QP_Attr_Mapping_PUB.Build_Contexts(p_request_type_code => 'ONT',
12894: p_pricing_type => 'L',
12895: x_price_contexts_result_tbl => l_pricing_contexts_Tbl,
12896: x_qual_contexts_result_tbl => l_qualifier_Contexts_Tbl);
12897: END IF;

Line 13005: QP_Attr_Mapping_PUB.Build_Contexts(

13001:
13002: Begin
13003: -- bucket man
13004: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' THEN
13005: QP_Attr_Mapping_PUB.Build_Contexts(
13006: p_request_type_code => 'ONT',
13007: p_pricing_type_code => 'H',
13008: p_line_index=> l_line_index + 1 --oe_order_pub.g_hdr.header_id
13009: );

Line 13011: QP_Attr_Mapping_PUB.Build_Contexts(

13007: p_pricing_type_code => 'H',
13008: p_line_index=> l_line_index + 1 --oe_order_pub.g_hdr.header_id
13009: );
13010: ELSE
13011: QP_Attr_Mapping_PUB.Build_Contexts(
13012: p_request_type_code => 'ONT',
13013: p_pricing_type => 'H',
13014: x_price_contexts_result_tbl => l_pricing_contexts_Tbl,
13015: x_qual_contexts_result_tbl => l_qualifier_Contexts_Tbl

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

13350: --DBMS_OUTPUT.PUT_LINE('G_EXC_UNEXPECTED_ERROR is '||l_return_status_Text);
13351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13352: WHEN QP_ATTR_MAPPING_ERRORS Then
13353: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
13354: FND_MESSAGE.SET_TOKEN('ERR_TEXT','Errors return from QP_Attr_Mapping_PUB.Build_Context');
13355: OE_MSG_PUB.Add;
13356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13357: Oe_Debug_Pub.add('G_EXC_UNEXPECTED_ERROR is: QP_Attr_Mapping_PUB.Build_Context'||sqlerrm,1);
13358: Oe_Debug_Pub.add('G_EXC_UNEXPECTED_ERROR is '||l_return_status_Text);

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

13353: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
13354: FND_MESSAGE.SET_TOKEN('ERR_TEXT','Errors return from QP_Attr_Mapping_PUB.Build_Context');
13355: OE_MSG_PUB.Add;
13356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13357: Oe_Debug_Pub.add('G_EXC_UNEXPECTED_ERROR is: QP_Attr_Mapping_PUB.Build_Context'||sqlerrm,1);
13358: Oe_Debug_Pub.add('G_EXC_UNEXPECTED_ERROR is '||l_return_status_Text);
13359: Oe_Debug_Pub.add('QP_ATTR_MAPPING_ERRORS');
13360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13361: WHEN OTHERS THEN