DBA Data[Home] [Help]

APPS.OE_OE_AVAILABILITY dependencies on QP_ATTR_MAPPING_PUB

Line 1559: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

1555: qp_attr_mapping_error exception;
1556: --l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1557: l_org_id Number := to_number( fnd_profile.value('ORG_ID'));
1558: l_master_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1559: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1560: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1561:
1562: --
1563: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1560: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

1556: --l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1557: l_org_id Number := to_number( fnd_profile.value('ORG_ID'));
1558: l_master_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1559: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1560: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1561:
1562: --
1563: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1564: l_pass_line VARCHAR2(1) :='N';

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

1565: --
1566: BEGIN
1567:
1568: IF l_debug_level > 0 THEN
1569: oe_debug_pub.add( 'BEFORE QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR LINE' , 1 ) ;
1570: END IF;
1571:
1572: IF l_debug_level > 0 THEN
1573: oe_debug_pub.add( 'ORG_ID='||L_ORG_ID|| ' PRICING_DATE='||

Line 1623: QP_Attr_Mapping_PUB.Build_Contexts(

1619: AND organization_id = l_master_org_id;
1620:
1621: End IF;
1622:
1623: QP_Attr_Mapping_PUB.Build_Contexts(
1624: p_request_type_code => 'ONT',
1625: p_line_index =>2,
1626: p_pricing_type_code =>'L',
1627: p_check_line_flag => 'N',

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

1643: oe_debug_pub.add('l_PASS_LINE'||l_pass_line);
1644: END IF;
1645:
1646: IF l_debug_level > 0 THEN
1647: oe_debug_pub.add( 'EXIT QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR LINE' , 1 ) ;
1648: END IF;
1649:
1650: EXCEPTION
1651: when no_data_found then

Line 1671: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

1667:
1668: qp_attr_mapping_error exception;
1669: --l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1670: l_org_id Number := to_number( fnd_profile.value('ORG_ID'));
1671: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1672: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1673:
1674: --
1675: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1672: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

1668: qp_attr_mapping_error exception;
1669: --l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1670: l_org_id Number := to_number( fnd_profile.value('ORG_ID'));
1671: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1672: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1673:
1674: --
1675: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1676: --

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

1676: --
1677: BEGIN
1678:
1679: IF l_debug_level > 0 THEN
1680: oe_debug_pub.add( 'BEFORE QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR HEADER' , 1 ) ;
1681: END IF;
1682:
1683:
1684: IF l_debug_level > 0 THEN

Line 1731: QP_Attr_Mapping_PUB.Build_Contexts(

1727:
1728: End If;*/
1729:
1730: /*
1731: QP_Attr_Mapping_PUB.Build_Contexts(
1732: p_request_type_code => 'ONT',
1733: p_pricing_type =>'H',
1734: x_price_contexts_result_tbl => p_pricing_contexts_Tbl,
1735: x_qual_contexts_result_tbl => p_qualifier_Contexts_Tbl

Line 1738: QP_ATTR_Mapping_PUB.Build_Contexts(

1734: x_price_contexts_result_tbl => p_pricing_contexts_Tbl,
1735: x_qual_contexts_result_tbl => p_qualifier_Contexts_Tbl
1736: );*/
1737:
1738: QP_ATTR_Mapping_PUB.Build_Contexts(
1739: p_request_type_code =>'ONT',
1740: p_line_index =>1,
1741: p_pricing_type_code =>'H');
1742:

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

1750: ,p_qualifier_contexts_tbl => p_qualifier_Contexts_Tbl
1751: );*/
1752:
1753: IF l_debug_level > 0 THEN
1754: oe_debug_pub.add( 'EXIT QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR HEADER' , 1 ) ;
1755: END IF;
1756:
1757: EXCEPTION
1758: when no_data_found then

Line 3704: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type

3700: PROCEDURE copy_attribs_to_Req(
3701: p_line_index number
3702: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
3703: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
3704: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
3705: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
3706: ) IS
3707:
3708: i pls_integer := 0;

Line 3705: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type

3701: p_line_index number
3702: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
3703: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
3704: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
3705: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
3706: ) IS
3707:
3708: i pls_integer := 0;
3709: l_attr_index pls_integer := nvl(px_Req_line_attr_tbl.last,0);