DBA Data[Home] [Help]

APPS.OE_RESERVE_CONC dependencies on OE_SYS_PARAMETERS

Line 61: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',p_x_rsv_rec.org_id), -- 4759251

57: END IF;
58: inv_decimals_pub.validate_quantity(
59: p_item_id => p_x_rsv_rec.inventory_item_id,
60: p_organization_id =>
61: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',p_x_rsv_rec.org_id), -- 4759251
62: p_input_quantity => p_x_rsv_rec.derived_reserved_qty,
63: p_uom_code => p_x_rsv_rec.ordered_qty_uom,
64: x_output_quantity => l_validated_quantity,
65: x_primary_quantity => l_primary_quantity,

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

135: INTO l_primary_uom
136: FROM mtl_system_items_b
137: WHERE inventory_item_id = p_inventory_item_id
138: AND organization_id = NVL(p_ship_from_org_id,
139: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID',p_org_id)); --4759251
140: EXCEPTION
141: WHEN OTHERS THEN
142: IF l_debug_level > 0 THEN
143: OE_DEBUG_PUB.Add('Error in selecting Primary UOM code',1);

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

1048: INTO l_primary_uom
1049: FROM mtl_system_items_b
1050: WHERE inventory_item_id = p_inventory_item_id
1051: AND organization_id = NVL(p_ship_from_org_id,
1052: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID',p_rsv_tbl(1).org_id)); --4759251
1053: EXCEPTION
1054: WHEN OTHERS THEN
1055: IF l_debug_level > 0 THEN
1056: OE_DEBUG_PUB.Add('Error in selecting Primary UOM code',1);

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

1228: END IF;
1229: inv_decimals_pub.validate_quantity(
1230: p_item_id => p_x_rsv_tbl(I).inventory_item_id,
1231: p_organization_id =>
1232: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',p_x_rsv_tbl(I).org_id), -- 4759251
1233: p_input_quantity => p_x_rsv_tbl(I).derived_reserved_qty,
1234: p_uom_code => p_x_rsv_tbl(I).ordered_qty_uom,
1235: x_output_quantity => l_validated_quantity,
1236: x_primary_quantity => l_primary_quantity,

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

1470: END IF;
1471: inv_decimals_pub.validate_quantity(
1472: p_item_id => p_x_rsv_tbl(I).inventory_item_id,
1473: p_organization_id =>
1474: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',p_x_rsv_tbl(I).org_id), --4759251
1475: p_input_quantity => l_reservation_rec.reservation_quantity,
1476: p_uom_code => l_reservation_rec.reservation_uom_code,
1477: x_output_quantity => l_validated_quantity,
1478: x_primary_quantity => l_primary_quantity,