APPS.OE_RELATED_ITEMS_PVT dependencies on QP_ATTR_MAPPING_PUB

Line 1074: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

1070: )IS
1071:
1072: qp_attr_mapping_error exception;
1073: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1074: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1075: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1076:
1077: --
1078: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1075: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

1071:
1072: qp_attr_mapping_error exception;
1073: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1074: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1075: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1076:
1077: --
1078: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1079: --

Line 1125: QP_Attr_Mapping_PUB.Build_Contexts(

1121: AND organization_id = l_org_id;
1122:
1123: End IF;
1124:
1125: QP_Attr_Mapping_PUB.Build_Contexts(
1126: p_request_type_code => 'ONT',
1127: p_pricing_type =>'L',
1128: x_price_contexts_result_tbl => p_pricing_contexts_Tbl,
1129: x_qual_contexts_result_tbl => p_qualifier_Contexts_Tbl

Line 1156: ,p_pricing_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type

1152: PROCEDURE copy_attribs_to_Req(
1153: p_line_index number
1154: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
1155: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1156: ,p_pricing_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
1157: ,p_qualifier_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
1158: ) IS
1159:
1160: i pls_integer := 0;

Line 1157: ,p_qualifier_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type

1153: p_line_index number
1154: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
1155: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1156: ,p_pricing_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
1157: ,p_qualifier_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
1158: ) IS
1159:
1160: i pls_integer := 0;
1161: l_attr_index pls_integer := nvl(px_Req_line_attr_tbl.last,0);

Line 1236: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

1232: )IS
1233:
1234: qp_attr_mapping_error exception;
1235: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1236: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1237: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1238:
1239: --
1240: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1237: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

1233:
1234: qp_attr_mapping_error exception;
1235: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1236: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1237: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1238:
1239: --
1240: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1241: --

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

1244: /*4163551*/
1245: BEGIN
1246:
1247: IF l_debug_level > 0 THEN
1248: oe_debug_pub.add( 'BEFORE QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR HEADER' , 1 ) ;
1249: END IF;
1250:
1251:
1252: IF l_debug_level > 0 THEN

Line 1313: QP_Attr_Mapping_PUB.Build_Contexts(

1309: AND organization_id = l_org_id;
1310:
1311: End If;*/
1312:
1313: QP_Attr_Mapping_PUB.Build_Contexts(
1314: p_request_type_code => 'ONT',
1315: p_pricing_type =>'H',
1316: x_price_contexts_result_tbl => p_pricing_contexts_Tbl,
1317: x_qual_contexts_result_tbl => p_qualifier_Contexts_Tbl

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

1326: ,p_qualifier_contexts_tbl => p_qualifier_Contexts_Tbl
1327: );
1328:
1329: IF l_debug_level > 0 THEN
1330: oe_debug_pub.add( 'EXIT QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR HEADER' , 1 ) ;
1331: END IF;
1332:
1333: EXCEPTION
1334: when no_data_found then