DBA Data[Home] [Help]

APPS.OE_OE_PRICING_AVAILABILITY dependencies on QP_ATTR_MAPPING_PUB

Line 2245: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

2241:
2242: qp_attr_mapping_error exception;
2243: l_master_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2244: l_org_id Number;
2245: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
2246: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
2247:
2248: --
2249: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2246: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

2242: qp_attr_mapping_error exception;
2243: l_master_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2244: l_org_id Number;
2245: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
2246: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
2247:
2248: --
2249: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2250: l_pass_line VARCHAR2(1) :='N';

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

2251: --
2252: BEGIN
2253:
2254: IF l_debug_level > 0 THEN
2255: oe_debug_pub.add( 'BEFORE QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR LINE' , 1 ) ;
2256: END IF;
2257:
2258: -- added for bug 5645866/5847803
2259: l_org_id := OE_GLOBALS.G_ORG_ID;

Line 2332: QP_Attr_Mapping_PUB.Build_Contexts(

2328: AND organization_id = l_master_org_id; -- bug 5645866/5847803
2329:
2330: End IF;
2331:
2332: QP_Attr_Mapping_PUB.Build_Contexts(
2333: p_request_type_code => 'ONT',
2334: p_line_index =>global_line_index,
2335: p_pricing_type_code =>'L',
2336: p_check_line_flag => 'N',

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

2342: oe_debug_pub.add('l_PASS_LINE'||l_pass_line);
2343: END IF;
2344:
2345: IF l_debug_level > 0 THEN
2346: oe_debug_pub.add( 'EXIT QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR LINE' , 1 ) ;
2347: END IF;
2348:
2349: EXCEPTION
2350: when no_data_found then

Line 2370: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

2366:
2367: qp_attr_mapping_error exception;
2368: -- l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2369: l_org_id Number;
2370: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
2371: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
2372:
2373: --
2374: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2371: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

2367: qp_attr_mapping_error exception;
2368: -- l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2369: l_org_id Number;
2370: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
2371: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
2372:
2373: --
2374: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2375: --

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

2375: --
2376: BEGIN
2377:
2378: IF l_debug_level > 0 THEN
2379: oe_debug_pub.add( 'BEFORE QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR HEADER' , 1 ) ;
2380: END IF;
2381:
2382: -- bug 5645866/5847803
2383: l_org_id := OE_GLOBALS.G_ORG_ID;

Line 2426: QP_ATTR_Mapping_PUB.Build_Contexts(

2422: --oe_order_pub.g_line.order_quantity_uom := p_uom;
2423:
2424:
2425:
2426: QP_ATTR_Mapping_PUB.Build_Contexts(
2427: p_request_type_code =>'ONT',
2428: p_line_index =>1,
2429: p_pricing_type_code =>'H');
2430:

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

2430:
2431:
2432:
2433: IF l_debug_level > 0 THEN
2434: oe_debug_pub.add( 'EXIT QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR HEADER' , 1 ) ;
2435: END IF;
2436:
2437: EXCEPTION
2438: when no_data_found then

Line 5098: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type

5094: PROCEDURE copy_attribs_to_Req(
5095: p_line_index number
5096: ,px_Req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE
5097: ,px_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE
5098: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
5099: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
5100: ) IS
5101:
5102: i pls_integer := 0;

Line 5099: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type

5095: p_line_index number
5096: ,px_Req_line_attr_tbl in out nocopy oe_oe_pricing_availability.QP_LINE_ATTR_TBL_TYPE
5097: ,px_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE
5098: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
5099: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
5100: ) IS
5101:
5102: i pls_integer := 0;
5103: l_attr_index pls_integer := nvl(px_Req_line_attr_tbl.last,0);

Line 8473: l_user_attribs_tbl QP_Attr_Mapping_PUB.USER_ATTRIBUTE_TBL_TYPE;

8469: Procedure get_user_item_Pricing_Contexts(
8470: p_request_type_code IN VARCHAR2,
8471: x_user_attribs_tbl OUT NOCOPY USER_ATTRIBUTE_TBL_TYPE) IS
8472:
8473: l_user_attribs_tbl QP_Attr_Mapping_PUB.USER_ATTRIBUTE_TBL_TYPE;
8474:
8475:
8476: Begin
8477:

Line 8478: QP_Attr_Mapping_PUB.get_user_item_Pricing_Contexts(

8474:
8475:
8476: Begin
8477:
8478: QP_Attr_Mapping_PUB.get_user_item_Pricing_Contexts(
8479: p_request_type_code,
8480: p_user_attribs_tbl => l_user_attribs_tbl);
8481:
8482: FOR I IN 1..l_user_attribs_tbl.COUNT LOOP