DBA Data[Home] [Help]

APPS.OE_RESERVE_CONC dependencies on OE_SYS_PARAMETERS

Line 63: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID',p_org_id)); --4759251

59: INTO l_primary_uom
60: FROM mtl_system_items_b
61: WHERE inventory_item_id = p_inventory_item_id
62: AND organization_id = NVL(p_ship_from_org_id,
63: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID',p_org_id)); --4759251
64: EXCEPTION
65: WHEN OTHERS THEN
66: IF l_debug_level > 0 THEN
67: OE_DEBUG_PUB.Add('Error in selecting Primary UOM code',1);

Line 1007: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID',p_rsv_tbl(1).org_id)); --4759251

1003: INTO l_primary_uom
1004: FROM mtl_system_items_b
1005: WHERE inventory_item_id = p_inventory_item_id
1006: AND organization_id = NVL(p_ship_from_org_id,
1007: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID',p_rsv_tbl(1).org_id)); --4759251
1008: EXCEPTION
1009: WHEN OTHERS THEN
1010: IF l_debug_level > 0 THEN
1011: OE_DEBUG_PUB.Add('Error in selecting Primary UOM code',1);

Line 1189: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',p_x_rsv_tbl(I).org_id), -- 4759251

1185: END IF;
1186: inv_decimals_pub.validate_quantity(
1187: p_item_id => p_x_rsv_tbl(I).inventory_item_id,
1188: p_organization_id =>
1189: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',p_x_rsv_tbl(I).org_id), -- 4759251
1190: p_input_quantity => p_x_rsv_tbl(I).derived_reserved_qty,
1191: p_uom_code => p_x_rsv_tbl(I).ordered_qty_uom,
1192: x_output_quantity => l_validated_quantity,
1193: x_primary_quantity => l_primary_quantity,

Line 1422: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',p_x_rsv_tbl(I).org_id), --4759251

1418: END IF;
1419: inv_decimals_pub.validate_quantity(
1420: p_item_id => p_x_rsv_tbl(I).inventory_item_id,
1421: p_organization_id =>
1422: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',p_x_rsv_tbl(I).org_id), --4759251
1423: p_input_quantity => l_reservation_rec.reservation_quantity,
1424: p_uom_code => l_reservation_rec.reservation_uom_code,
1425: x_output_quantity => l_validated_quantity,
1426: x_primary_quantity => l_primary_quantity,