DBA Data[Home] [Help]

APPS.OE_OE_PRICING_AVAILABILITY dependencies on QP_ATTR_MAPPING_PUB

Line 2235: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

2231:
2232: qp_attr_mapping_error exception;
2233: l_master_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2234: l_org_id Number;
2235: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
2236: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
2237:
2238: --
2239: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2236: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

2232: qp_attr_mapping_error exception;
2233: l_master_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2234: l_org_id Number;
2235: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
2236: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
2237:
2238: --
2239: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2240: l_pass_line VARCHAR2(1) :='N';

Line 2245: oe_debug_pub.add( 'BEFORE QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR LINE' , 1 ) ;

2241: --
2242: BEGIN
2243:
2244: IF l_debug_level > 0 THEN
2245: oe_debug_pub.add( 'BEFORE QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR LINE' , 1 ) ;
2246: END IF;
2247:
2248: -- added for bug 5645866/5847803
2249: l_org_id := OE_GLOBALS.G_ORG_ID;

Line 2307: QP_Attr_Mapping_PUB.Build_Contexts(

2303: AND organization_id = l_master_org_id; -- bug 5645866/5847803
2304:
2305: End IF;
2306:
2307: QP_Attr_Mapping_PUB.Build_Contexts(
2308: p_request_type_code => 'ONT',
2309: p_line_index =>global_line_index,
2310: p_pricing_type_code =>'L',
2311: p_check_line_flag => 'N',

Line 2321: oe_debug_pub.add( 'EXIT QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR LINE' , 1 ) ;

2317: oe_debug_pub.add('l_PASS_LINE'||l_pass_line);
2318: END IF;
2319:
2320: IF l_debug_level > 0 THEN
2321: oe_debug_pub.add( 'EXIT QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR LINE' , 1 ) ;
2322: END IF;
2323:
2324: EXCEPTION
2325: when no_data_found then

Line 2345: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

2341:
2342: qp_attr_mapping_error exception;
2343: -- l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2344: l_org_id Number;
2345: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
2346: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
2347:
2348: --
2349: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2346: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

2342: qp_attr_mapping_error exception;
2343: -- l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2344: l_org_id Number;
2345: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
2346: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
2347:
2348: --
2349: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2350: --

Line 2354: oe_debug_pub.add( 'BEFORE QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR HEADER' , 1 ) ;

2350: --
2351: BEGIN
2352:
2353: IF l_debug_level > 0 THEN
2354: oe_debug_pub.add( 'BEFORE QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR HEADER' , 1 ) ;
2355: END IF;
2356:
2357: -- bug 5645866/5847803
2358: l_org_id := OE_GLOBALS.G_ORG_ID;

Line 2401: QP_ATTR_Mapping_PUB.Build_Contexts(

2397: --oe_order_pub.g_line.order_quantity_uom := p_uom;
2398:
2399:
2400:
2401: QP_ATTR_Mapping_PUB.Build_Contexts(
2402: p_request_type_code =>'ONT',
2403: p_line_index =>1,
2404: p_pricing_type_code =>'H');
2405:

Line 2409: oe_debug_pub.add( 'EXIT QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR HEADER' , 1 ) ;

2405:
2406:
2407:
2408: IF l_debug_level > 0 THEN
2409: oe_debug_pub.add( 'EXIT QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR HEADER' , 1 ) ;
2410: END IF;
2411:
2412: EXCEPTION
2413: when no_data_found then

Line 5073: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type

5069: PROCEDURE copy_attribs_to_Req(
5070: p_line_index number
5071: ,px_Req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE
5072: ,px_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE
5073: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
5074: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
5075: ) IS
5076:
5077: i pls_integer := 0;

Line 5074: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type

5070: p_line_index number
5071: ,px_Req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE
5072: ,px_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE
5073: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
5074: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
5075: ) IS
5076:
5077: i pls_integer := 0;
5078: l_attr_index pls_integer := nvl(px_Req_line_attr_tbl.last,0);

Line 8448: l_user_attribs_tbl QP_Attr_Mapping_PUB.USER_ATTRIBUTE_TBL_TYPE;

8444: Procedure get_user_item_Pricing_Contexts(
8445: p_request_type_code IN VARCHAR2,
8446: x_user_attribs_tbl OUT NOCOPY USER_ATTRIBUTE_TBL_TYPE) IS
8447:
8448: l_user_attribs_tbl QP_Attr_Mapping_PUB.USER_ATTRIBUTE_TBL_TYPE;
8449:
8450:
8451: Begin
8452:

Line 8453: QP_Attr_Mapping_PUB.get_user_item_Pricing_Contexts(

8449:
8450:
8451: Begin
8452:
8453: QP_Attr_Mapping_PUB.get_user_item_Pricing_Contexts(
8454: p_request_type_code,
8455: p_user_attribs_tbl => l_user_attribs_tbl);
8456:
8457: FOR I IN 1..l_user_attribs_tbl.COUNT LOOP