APPS.OE_ORDER_IMPORT_SPECIFIC_PVT dependencies on OE_SYS_PARAMETERS

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

2675:
2676: /*myerrams, Customer Acceptance, Populating the Action_request table with Header id if Customer Acceptance is enabled.*/
2677: 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
2678: l_org_id := mo_global.get_current_org_id;
2679: IF (OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE',l_org_id) = 'Y') THEN
2680: p_x_action_request_tbl(b).param5 := p_x_header_rec.header_id;
2681: END IF;
2682: END IF;
2683: /*myerrams, Customer Acceptance, end*/

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

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

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

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

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

4599: Z_Customer_Item_Id => l_ordered_item_id
4600: , Z_Customer_Id => p_x_header_rec.sold_to_org_id
4601: , Z_Customer_Item_Number => p_x_line_tbl(I).Ordered_Item
4602: , Z_Address_Id => l_address_id
4603: , Z_Organization_Id => nvl(l_ship_from_org_id, OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID',l_org_id))
4604: , Z_Inventory_Item_Id => l_inventory_id
4605: , Attribute_Name => 'INVENTORY_ITEM_ID'
4606: , Error_Code => l_error_code
4607: , Error_Flag => l_error_flag

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

4626: Z_Customer_Item_Id => l_ordered_item_id
4627: , Z_Customer_Id => p_x_header_rec.sold_to_org_id
4628: , Z_Customer_Item_Number => p_x_line_tbl(I).Ordered_Item
4629: , Z_Address_Id => l_address_id
4630: , Z_Organization_Id => nvl(l_ship_from_org_id , OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID',l_org_id))
4631: , Z_Inventory_Item_Id => NULL
4632: , Attribute_Name => 'CUSTOMER_ITEM_ID'
4633: , Error_Code => l_error_code
4634: , Error_Flag => l_error_flag

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

4702: INTO l_inventory_item_id_gen
4703: FROM mtl_cross_references
4704: WHERE cross_reference_type = p_x_line_tbl(I).item_identifier_type
4705: AND (organization_id =
4706: OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID',l_org_id)
4707: OR organization_id IS NULL)
4708: AND cross_reference = p_x_line_tbl(I).ordered_item
4709: And (inventory_item_id = l_inventory_item_id_int
4710: OR l_inventory_item_id_int IS NULL);

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

5005: AND p_x_action_request_tbl(b).entity_index = l_line_count THEN
5006: p_x_action_request_tbl(b).entity_id := p_x_line_tbl(I).line_id;
5007: /*myerrams, Customer Acceptance, Populating the Action_request table with Header id if Customer Acceptance is enabled.*/
5008: 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
5009: IF (OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE',l_org_id) = 'Y') THEN
5010: p_x_action_request_tbl(b).param5 := p_x_line_tbl(I).header_id;
5011: END IF;
5012: END IF;
5013: /*myerrams, Customer Acceptance, end*/