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_ORDER_IMPORT_SPECIFIC_PVT dependencies on OE_SYS_PARAMETERS

Line 2682: IF (OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE',l_org_id) = 'Y') THEN

2678:
2679: /*myerrams, Customer Acceptance, Populating the Action_request table with Header id if Customer Acceptance is enabled.*/
2680: IF p_x_action_request_tbl(b).request_type = OE_Globals.G_ACCEPT_FULFILLMENT OR p_x_action_request_tbl(b).request_type = OE_Globals.G_REJECT_FULFILLMENT THEN
2681: l_org_id := mo_global.get_current_org_id;
2682: IF (OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE',l_org_id) = 'Y') THEN
2683: p_x_action_request_tbl(b).param5 := p_x_header_rec.header_id;
2684: END IF;
2685: END IF;
2686: /*myerrams, Customer Acceptance, end*/

Line 4360: oe_sys_parameters.Value('MASTER_ORGANIZATION_ID',l_org_id);

4356: WHERE concatenated_segments = p_x_line_val_tbl(I).inventory_item
4357: AND customer_order_enabled_flag = 'Y'
4358: AND bom_item_type in (1,2,4)
4359: AND organization_id =
4360: oe_sys_parameters.Value('MASTER_ORGANIZATION_ID',l_org_id);
4361:
4362: p_x_line_tbl(I).inventory_item_id := l_inventory_item_id_int;
4363:
4364: EXCEPTION

Line 4413: oe_sys_parameters.Value('MASTER_ORGANIZATION_ID',l_org_id);

4409: WHERE concatenated_segments = p_x_line_tbl(I).ordered_item
4410: AND customer_order_enabled_flag = 'Y'
4411: AND bom_item_type in (1,2,4)
4412: AND organization_id =
4413: oe_sys_parameters.Value('MASTER_ORGANIZATION_ID',l_org_id);
4414:
4415: EXCEPTION
4416: WHEN NO_DATA_FOUND THEN
4417: IF l_debug_level > 0 THEN

Line 4617: , Z_Organization_Id => nvl(l_ship_from_org_id, OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID',l_org_id))

4613: Z_Customer_Item_Id => l_ordered_item_id
4614: , Z_Customer_Id => p_x_header_rec.sold_to_org_id
4615: , Z_Customer_Item_Number => p_x_line_tbl(I).Ordered_Item
4616: , Z_Address_Id => l_address_id
4617: , Z_Organization_Id => nvl(l_ship_from_org_id, OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID',l_org_id))
4618: , Z_Inventory_Item_Id => l_inventory_id
4619: , Attribute_Name => 'INVENTORY_ITEM_ID'
4620: , Error_Code => l_error_code
4621: , Error_Flag => l_error_flag

Line 4633: , Z_Organization_Id => nvl(l_ship_from_org_id, OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID',l_org_id))

4629: Z_Customer_Item_Id => l_ordered_item_id
4630: , Z_Customer_Id => p_x_header_rec.sold_to_org_id
4631: , Z_Customer_Item_Number => p_x_line_tbl(I).Ordered_Item
4632: , Z_Address_Id => l_address_id
4633: , Z_Organization_Id => nvl(l_ship_from_org_id, OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID',l_org_id))
4634: , Z_Inventory_Item_Id => l_inventory_id
4635: , Attribute_Name => 'INVENTORY_ITEM_ID'
4636: , Error_Code => l_error_code
4637: , Error_Flag => l_error_flag

Line 4678: , Z_Organization_Id => nvl(l_ship_from_org_id , OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID',l_org_id))

4674: Z_Customer_Item_Id => l_ordered_item_id
4675: , Z_Customer_Id => p_x_header_rec.sold_to_org_id
4676: , Z_Customer_Item_Number => p_x_line_tbl(I).Ordered_Item
4677: , Z_Address_Id => l_address_id
4678: , Z_Organization_Id => nvl(l_ship_from_org_id , OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID',l_org_id))
4679: , Z_Inventory_Item_Id => NULL
4680: , Attribute_Name => 'CUSTOMER_ITEM_ID'
4681: , Error_Code => l_error_code
4682: , Error_Flag => l_error_flag

Line 4694: , Z_Organization_Id => nvl(l_ship_from_org_id , OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID',l_org_id))

4690: Z_Customer_Item_Id => l_ordered_item_id
4691: , Z_Customer_Id => p_x_header_rec.sold_to_org_id
4692: , Z_Customer_Item_Number => p_x_line_tbl(I).Ordered_Item
4693: , Z_Address_Id => l_address_id
4694: , Z_Organization_Id => nvl(l_ship_from_org_id , OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID',l_org_id))
4695: , Z_Inventory_Item_Id => NULL
4696: , Attribute_Name => 'CUSTOMER_ITEM_ID'
4697: , Error_Code => l_error_code
4698: , Error_Flag => l_error_flag

Line 4772: OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID',l_org_id)

4768: INTO l_inventory_item_id_gen
4769: FROM mtl_cross_references
4770: WHERE cross_reference_type = p_x_line_tbl(I).item_identifier_type
4771: AND (organization_id =
4772: OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID',l_org_id)
4773: OR organization_id IS NULL)
4774: AND cross_reference = p_x_line_tbl(I).ordered_item
4775: And (inventory_item_id = l_inventory_item_id_int
4776: OR l_inventory_item_id_int IS NULL);

Line 5076: IF (OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE',l_org_id) = 'Y') THEN

5072: AND p_x_action_request_tbl(b).entity_index = l_line_count THEN
5073: p_x_action_request_tbl(b).entity_id := p_x_line_tbl(I).line_id;
5074: /*myerrams, Customer Acceptance, Populating the Action_request table with Header id if Customer Acceptance is enabled.*/
5075: IF p_x_action_request_tbl(b).request_type = OE_Globals.G_ACCEPT_FULFILLMENT OR p_x_action_request_tbl(b).request_type = OE_Globals.G_REJECT_FULFILLMENT THEN
5076: IF (OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE',l_org_id) = 'Y') THEN
5077: p_x_action_request_tbl(b).param5 := p_x_line_tbl(I).header_id;
5078: END IF;
5079: END IF;
5080: /*myerrams, Customer Acceptance, end*/