DBA Data[Home] [Help]

APPS.OE_RELATED_ITEMS_PVT dependencies on QP_ATTR_MAPPING_PUB

Line 1041: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

1037: )IS
1038:
1039: qp_attr_mapping_error exception;
1040: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1041: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1042: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1043:
1044: --
1045: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1042: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

1038:
1039: qp_attr_mapping_error exception;
1040: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1041: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1042: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1043:
1044: --
1045: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1046: --

Line 1091: QP_Attr_Mapping_PUB.Build_Contexts(

1087: AND organization_id = l_org_id;
1088:
1089: End IF;
1090:
1091: QP_Attr_Mapping_PUB.Build_Contexts(
1092: p_request_type_code => 'ONT',
1093: p_pricing_type =>'L',
1094: x_price_contexts_result_tbl => p_pricing_contexts_Tbl,
1095: x_qual_contexts_result_tbl => p_qualifier_Contexts_Tbl

Line 1122: ,p_pricing_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type

1118: PROCEDURE copy_attribs_to_Req(
1119: p_line_index number
1120: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
1121: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1122: ,p_pricing_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
1123: ,p_qualifier_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
1124: ) IS
1125:
1126: i pls_integer := 0;

Line 1123: ,p_qualifier_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type

1119: p_line_index number
1120: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
1121: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1122: ,p_pricing_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
1123: ,p_qualifier_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
1124: ) IS
1125:
1126: i pls_integer := 0;
1127: l_attr_index pls_integer := nvl(px_Req_line_attr_tbl.last,0);

Line 1202: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

1198: )IS
1199:
1200: qp_attr_mapping_error exception;
1201: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1202: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1203: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1204:
1205: --
1206: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1203: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

1199:
1200: qp_attr_mapping_error exception;
1201: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1202: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1203: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1204:
1205: --
1206: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1207: --

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

1210: /*4163551*/
1211: BEGIN
1212:
1213: IF l_debug_level > 0 THEN
1214: oe_debug_pub.add( 'BEFORE QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR HEADER' , 1 ) ;
1215: END IF;
1216:
1217:
1218: IF l_debug_level > 0 THEN

Line 1279: QP_Attr_Mapping_PUB.Build_Contexts(

1275: AND organization_id = l_org_id;
1276:
1277: End If;*/
1278:
1279: QP_Attr_Mapping_PUB.Build_Contexts(
1280: p_request_type_code => 'ONT',
1281: p_pricing_type =>'H',
1282: x_price_contexts_result_tbl => p_pricing_contexts_Tbl,
1283: x_qual_contexts_result_tbl => p_qualifier_Contexts_Tbl

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

1292: ,p_qualifier_contexts_tbl => p_qualifier_Contexts_Tbl
1293: );
1294:
1295: IF l_debug_level > 0 THEN
1296: oe_debug_pub.add( 'EXIT QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR HEADER' , 1 ) ;
1297: END IF;
1298:
1299: EXCEPTION
1300: when no_data_found then