[Home] [Help]
533: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
534: AND MSC_ATP_GLOBAL.GET_APS_VERSION = 10 THEN
535: in_atp_rec.Included_item_flag(I) := 1; -- This has to be 1 since OM explodes included items before calling ATP.
536: -- in_atp_rec.top_model_line_id(I) := p_line_rec.top_model_line_id;
537: in_atp_rec.validation_org(I) := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
538: END IF;
539:
540: -- Call ATP
541: -- Added to display upgraded item information
1605: END IF;
1606:
1607: BEGIN
1608: IF p_org_id is null THEN
1609: l_org_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1610: END IF;
1611:
1612: SELECT msi.lot_control_code
1613: INTO l_lot_control_code
2229: p_line_index in number
2230: )IS
2231:
2232: qp_attr_mapping_error exception;
2233: l_master_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2234: l_org_id Number;
2235: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
2236: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
2237:
2339: p_Req_qual_tbl in out nocopy oe_oe_pricing_availability.QP_QUAL_TBL_TYPE
2340: )IS
2341:
2342: qp_attr_mapping_error exception;
2343: -- l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2344: l_org_id Number;
2345: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
2346: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
2347:
5161:
5162: ) IS
5163:
5164: l_price_list varchar2(200);
5165: l_allow_negative_price varchar2(10):= nvl(OE_Sys_Parameters.VALUE('ONT_NEGATIVE_PRICING'),'N');
5166: --Bug 7409782
5167: --l_gsa_violation_action Varchar2(30) :=fnd_profile.value('ONT_GSA_VIOLATION_ACTION');
5168: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5169:
5164: l_price_list varchar2(200);
5165: l_allow_negative_price varchar2(10):= nvl(OE_Sys_Parameters.VALUE('ONT_NEGATIVE_PRICING'),'N');
5166: --Bug 7409782
5167: --l_gsa_violation_action Varchar2(30) :=fnd_profile.value('ONT_GSA_VIOLATION_ACTION');
5168: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5169:
5170: --Bug 7409782
5171: l_GSA_Enabled_Flag Varchar2(30) := FND_PROFILE.VALUE('QP_VERIFY_GSA');
5172: l_gsa_violation_action Varchar2(30) := nvl(oe_sys_parameters.value('ONT_GSA_VIOLATION_ACTION'),'WARNING');
5168: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5169:
5170: --Bug 7409782
5171: l_GSA_Enabled_Flag Varchar2(30) := FND_PROFILE.VALUE('QP_VERIFY_GSA');
5172: l_gsa_violation_action Varchar2(30) := nvl(oe_sys_parameters.value('ONT_GSA_VIOLATION_ACTION'),'WARNING');
5173: Cursor get_gsa_list_lines is
5174: Select/*+ ordered use_nl(qpq qppa qpll qplh) */ min(qpll.operand)
5175: From
5176: qp_qualifiers qpq
5518: PROCEDURE get_item_name(l_inv_item_id in number,
5519: out_inv_item_name out nocopy varchar2
5520: )
5521: IS
5522: l_org_id number := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5523: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5524: BEGIN
5525: SELECT concatenated_segments
5526: INTO out_inv_item_name
5573: out_inv_desc out nocopy varchar2,
5574: out_inv_item_type out nocopy varchar2
5575: )
5576: IS
5577: l_org_id number := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5578: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5579: BEGIN
5580: SELECT concatenated_segments,description,item_type
5581: INTO out_inv_item_name,out_inv_desc,out_inv_item_type