[Home] [Help]
2616: x_line_val_rec.x_ordered_item_id := l_x_line_rec.ordered_item_id;
2617:
2618: IF OE_GLOBALS.G_DEFER_PRICING='N' THEN
2619: -- lkxu, commitment enhancement.
2620: IF UPPER(Nvl(Fnd_Profile.Value('OE_COMMITMENT_SEQUENCING'),'N')) = 'Y' THEN
2621: x_line_val_rec.x_commitment_applied_amount := OE_COMMITMENT_PVT.get_commitment_applied_amount
2622: (p_header_id => l_x_line_rec.header_id ,
2623: p_line_id => l_x_line_rec.line_id ,
2624: p_commitment_id => l_x_line_rec.commitment_id);
3350: and lookup_type='SHIPMENT_PRIORITY')
3351: or (lookup_code=freight_terms_code
3352: and lookup_type='FREIGHT_TERMS'))
3353: and SECURITY_GROUP_ID =fnd_global.Lookup_Security_Group(lv.lookup_type,lv.view_application_id);
3354: /*l_organization_id Number:=fnd_profile.value('OE_ORGANIZATION_ID');*/
3355: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
3356: l_organization_id Number;
3357: /* Need to Change Exception Handling- Not Sure whether we should continue
3358: to process other attribute when one of the attribute raises exception.
4806: SELECT unit_of_measure
4807: INTO l_charge_periodicity
4808: FROM MTL_UNITS_OF_MEASURE_VL
4809: WHERE uom_code = p_line_rec.charge_periodicity_code;
4810: --AND uom_class = FND_PROFILE.Value('ONT_UOM_CLASS_CHARGE_PERIODICITY');
4811:
4812: x_line_val_rec.charge_periodicity := l_charge_periodicity;
4813:
4814: IF l_debug_level > 0 THEN
5060: ,p_ordered_item IN VARCHAR2
5061: ,p_sold_to_org_id IN NUMBER
5062: ,p_description IN VARCHAR2
5063: ) RETURN VARCHAR2 IS
5064: /*l_organization_id NUMBER := fnd_profile.value('OE_ORGANIZATION_ID');*/
5065: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
5066: l_organization_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5067: l_count NUMBER := 0;
5068: --