[Home] [Help]
537: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
538: AND MSC_ATP_GLOBAL.GET_APS_VERSION = 10 THEN
539: in_atp_rec.Included_item_flag(I) := 1; -- This has to be 1 since OM explodes included items before calling ATP.
540: -- in_atp_rec.top_model_line_id(I) := p_line_rec.top_model_line_id;
541: in_atp_rec.validation_org(I) := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
542: END IF;
543:
544: -- Call ATP
545: -- Added to display upgraded item information
1615: END IF;
1616:
1617: BEGIN
1618: IF p_org_id is null THEN
1619: l_org_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1620: END IF;
1621:
1622: SELECT msi.lot_control_code
1623: INTO l_lot_control_code
2239: p_line_index in number
2240: )IS
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:
2364: p_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE
2365: )IS
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:
5186:
5187: ) IS
5188:
5189: l_price_list varchar2(200);
5190: l_allow_negative_price varchar2(10):= nvl(OE_Sys_Parameters.VALUE('ONT_NEGATIVE_PRICING'),'N');
5191: --Bug 7409782
5192: --l_gsa_violation_action Varchar2(30) :=fnd_profile.value('ONT_GSA_VIOLATION_ACTION');
5193: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5194:
5189: l_price_list varchar2(200);
5190: l_allow_negative_price varchar2(10):= nvl(OE_Sys_Parameters.VALUE('ONT_NEGATIVE_PRICING'),'N');
5191: --Bug 7409782
5192: --l_gsa_violation_action Varchar2(30) :=fnd_profile.value('ONT_GSA_VIOLATION_ACTION');
5193: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5194:
5195: --Bug 7409782
5196: l_GSA_Enabled_Flag Varchar2(30) := FND_PROFILE.VALUE('QP_VERIFY_GSA');
5197: l_gsa_violation_action Varchar2(30) := nvl(oe_sys_parameters.value('ONT_GSA_VIOLATION_ACTION'),'WARNING');
5193: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5194:
5195: --Bug 7409782
5196: l_GSA_Enabled_Flag Varchar2(30) := FND_PROFILE.VALUE('QP_VERIFY_GSA');
5197: l_gsa_violation_action Varchar2(30) := nvl(oe_sys_parameters.value('ONT_GSA_VIOLATION_ACTION'),'WARNING');
5198: Cursor get_gsa_list_lines is
5199: Select/*+ ordered use_nl(qpq qppa qpll qplh) */ min(qpll.operand)
5200: From
5201: qp_qualifiers qpq
5543: PROCEDURE get_item_name(l_inv_item_id in number,
5544: out_inv_item_name out nocopy varchar2
5545: )
5546: IS
5547: l_org_id number := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5548: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5549: BEGIN
5550: SELECT concatenated_segments
5551: INTO out_inv_item_name
5598: out_inv_desc out nocopy varchar2,
5599: out_inv_item_type out nocopy varchar2
5600: )
5601: IS
5602: l_org_id number := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5603: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5604: BEGIN
5605: SELECT concatenated_segments,description,item_type
5606: INTO out_inv_item_name,out_inv_desc,out_inv_item_type