DBA Data[Home] [Help]

APPS.OE_OE_AVAILABILITY dependencies on QP_ATTR_MAPPING_PUB

Line 1562: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

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

Line 1563: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

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

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

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

Line 1626: QP_Attr_Mapping_PUB.Build_Contexts(

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

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

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

Line 1674: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

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

Line 1675: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

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

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

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

Line 1736: QP_Attr_Mapping_PUB.Build_Contexts(

1732:
1733: End If;*/
1734:
1735: /*
1736: QP_Attr_Mapping_PUB.Build_Contexts(
1737: p_request_type_code => 'ONT',
1738: p_pricing_type =>'H',
1739: x_price_contexts_result_tbl => p_pricing_contexts_Tbl,
1740: x_qual_contexts_result_tbl => p_qualifier_Contexts_Tbl

Line 1743: QP_ATTR_Mapping_PUB.Build_Contexts(

1739: x_price_contexts_result_tbl => p_pricing_contexts_Tbl,
1740: x_qual_contexts_result_tbl => p_qualifier_Contexts_Tbl
1741: );*/
1742:
1743: QP_ATTR_Mapping_PUB.Build_Contexts(
1744: p_request_type_code =>'ONT',
1745: p_line_index =>1,
1746: p_pricing_type_code =>'H');
1747:

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

1755: ,p_qualifier_contexts_tbl => p_qualifier_Contexts_Tbl
1756: );*/
1757:
1758: IF l_debug_level > 0 THEN
1759: oe_debug_pub.add( 'EXIT QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR HEADER' , 1 ) ;
1760: END IF;
1761:
1762: EXCEPTION
1763: when no_data_found then

Line 3721: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type

3717: PROCEDURE copy_attribs_to_Req(
3718: p_line_index number
3719: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
3720: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
3721: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
3722: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
3723: ) IS
3724:
3725: i pls_integer := 0;

Line 3722: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type

3718: p_line_index number
3719: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
3720: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
3721: ,p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
3722: ,p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
3723: ) IS
3724:
3725: i pls_integer := 0;
3726: l_attr_index pls_integer := nvl(px_Req_line_attr_tbl.last,0);