eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_LINE_UTIL dependencies on OE_SYS_PARAMETERS

Line 2673: p_organization_id => OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID'),

2669:
2670: Inv_Decimals_PUB.Validate_Quantity
2671: (
2672: p_item_id => p_x_line_rec.inventory_item_id,
2673: p_organization_id => OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID'),
2674: p_input_quantity => l_temp_shipped_quantity,
2675: p_uom_code => p_x_line_rec.order_quantity_uom,
2676: x_output_quantity => l_validated_quantity,
2677: x_primary_quantity => l_primary_quantity,

Line 3540: mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID') )

3536: AND item_type_code = 'INCLUDED'
3537: AND exists (select null from mtl_system_items mtl where
3538: mtl.inventory_item_id = l.inventory_item_id and
3539: mtl.serviceable_product_flag = 'Y' and
3540: mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID') )
3541: AND ROWNUM = 1;
3542:
3543: EXCEPTION
3544: WHEN OTHERS THEN

Line 3612: and mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID')

3608: select distinct 'Y'
3609: into l_serviceable_item
3610: from mtl_system_items mtl
3611: where mtl.inventory_item_id = p_x_line_rec.inventory_item_id
3612: and mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID')
3613: and mtl.serviceable_product_flag='Y';
3614: -- lchen added check for organizations to fix bug 2039304
3615:
3616: EXCEPTION

Line 4069: IF NVL(OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE'), 'N') = 'Y'

4065:
4066: IF l_debug_level > 0 then
4067: oe_debug_pub.add('operation:'||p_x_line_rec.operation||' booked_flag:'||p_x_line_rec.booked_flag||' new contingency_id: '||p_x_line_rec.contingency_id ||' old contingency_id: '||p_old_line_rec.contingency_id);
4068: END IF;
4069: IF NVL(OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE'), 'N') = 'Y'
4070: AND (NVL( p_x_line_rec.booked_flag, 'N') = 'N' OR
4071: p_x_line_rec.operation=OE_GLOBALS.G_OPR_CREATE)
4072: AND l_def_contingency_attributes = FND_API.G_TRUE
4073: AND p_x_line_rec.inventory_item_id IS NOT NULL

Line 12881: l_organization_id NUMBER := OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');

12877: ) RETURN OE_Order_PUB.Line_Val_Rec_Type
12878: IS
12879: l_customer_number VARCHAR2(30);
12880: l_line_val_rec OE_Order_PUB.Line_Val_Rec_Type;
12881: l_organization_id NUMBER := OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
12882:
12883: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
12884: BEGIN
12885:

Line 15582: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',NULL);

15578: */
15579:
15580: oe_debug_pub.add( ' p_line_rec.org_id = '|| p_line_rec.org_id, 5 ) ;
15581: IF p_line_rec.org_id = FND_API.G_MISS_NUM THEN ---no need to handle null, automatically handled
15582: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',NULL);
15583: ELSE
15584: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',p_line_rec.org_id);
15585: END IF;
15586: oe_debug_pub.add( ' l_overship_invoice_basis = '|| l_overship_invoice_basis , 5 ) ;

Line 15584: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',p_line_rec.org_id);

15580: oe_debug_pub.add( ' p_line_rec.org_id = '|| p_line_rec.org_id, 5 ) ;
15581: IF p_line_rec.org_id = FND_API.G_MISS_NUM THEN ---no need to handle null, automatically handled
15582: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',NULL);
15583: ELSE
15584: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',p_line_rec.org_id);
15585: END IF;
15586: oe_debug_pub.add( ' l_overship_invoice_basis = '|| l_overship_invoice_basis , 5 ) ;
15587: oe_debug_pub.add( ' p_line_rec.reference_line_id = '|| p_line_rec.reference_line_id , 5) ;
15588:

Line 15692: , Z_Organization_Id => nvl(p_x_line_rec.ship_from_org_id, OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID'))

15688: INV_CUSTOMER_ITEM_GRP.CI_Attribute_Value(
15689: Z_Customer_Item_Id => p_x_line_rec.ordered_item_id
15690: , Z_Customer_Id => p_x_line_rec.sold_to_org_id
15691: , Z_Address_Id => l_address_id
15692: , Z_Organization_Id => nvl(p_x_line_rec.ship_from_org_id, OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID'))
15693: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
15694: , Z_Inventory_Item_Id => p_x_line_rec.inventory_item_id
15695: , Attribute_Name => 'INVENTORY_ITEM_ID'
15696: , Error_Code => l_error_code

Line 16119: IF NVL(OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE'), 'N') = 'Y'

16115: END IF;
16116: /*sdatti*/
16117:
16118: --Customer Acceptance
16119: IF NVL(OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE'), 'N') = 'Y'
16120: AND p_x_line_rec.item_type_code= 'SERVICE' and p_x_line_rec.accepted_quantity is NULL THEN
16121: /*Default Parent acceptance details*/
16122: OE_ACCEPTANCE_UTIL.Default_Parent_Accept_Details(p_x_line_rec);
16123: END IF;

Line 16912: l_promise_date_flag := OE_SYS_PARAMETERS.value('PROMISE_DATE_FLAG');

16908: -- Promise Date setup with Request date
16909: -- 'FR' - With First Request date
16910: -- 'R' -- For all change in Request date
16911: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
16912: l_promise_date_flag := OE_SYS_PARAMETERS.value('PROMISE_DATE_FLAG');
16913:
16914: IF l_promise_date_flag = 'FR'
16915: AND (p_old_line_rec.request_date = FND_API.G_MISS_DATE
16916: OR p_old_line_rec.request_date IS NULL) THEN

Line 16953: l_audit_trail_enabled VARCHAR2(1) := OE_SYS_PARAMETERS.VALUE('AUDIT_TRAIL_ENABLE_FLAG');

16949: IS
16950:
16951: l_ind NUMBER;
16952: l_code_level varchar2(6) := OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL;
16953: l_audit_trail_enabled VARCHAR2(1) := OE_SYS_PARAMETERS.VALUE('AUDIT_TRAIL_ENABLE_FLAG');
16954:
16955: l_return_status VARCHAR2(30);
16956: l_reason_code VARCHAR2(30);
16957: l_reason_comments VARCHAR2(2000);