DBA Data[Home] [Help]

APPS.WIP_WS_UTIL dependencies on WIP_CONSTANTS

Line 255: if ( l_lot_control_code = WIP_CONSTANTS.LOT ) then

251: from mtl_system_items_b msi
252: where msi.organization_id = p_org_id
253: and msi.inventory_item_id = p_component_id;
254:
255: if ( l_lot_control_code = WIP_CONSTANTS.LOT ) then
256: l_is_lot_control := true;
257: else
258: l_is_lot_control := false;
259: end if;

Line 261: if( l_revision_control_code = WIP_CONSTANTS.REV ) then

257: else
258: l_is_lot_control := false;
259: end if;
260:
261: if( l_revision_control_code = WIP_CONSTANTS.REV ) then
262: l_is_revision_control := true;
263: else
264: l_is_revision_control := false;
265: end if;

Line 267: if( l_serial_control_code in (WIP_CONSTANTS.FULL_SN, WIP_CONSTANTS.DYN_RCV_SN) ) then

263: else
264: l_is_revision_control := false;
265: end if;
266:
267: if( l_serial_control_code in (WIP_CONSTANTS.FULL_SN, WIP_CONSTANTS.DYN_RCV_SN) ) then
268: l_is_serial_control := true;
269: else
270: l_is_serial_control := false;
271: end if;

Line 876: wip_constants.yes, nvl(bdr.utilization, 1), 1),

872: if( l_remaining_usage is not null ) then
873:
874: select least(wor.assigned_units, bdr.capacity_units),
875: decode(wp.include_resource_utilization,
876: wip_constants.yes, nvl(bdr.utilization, 1), 1),
877: decode(wp.include_resource_efficiency,
878: wip_constants.yes, nvl(bdr.efficiency, 1), 1)
879: into l_units, l_utilization, l_efficiency
880: from wip_operation_resources wor,

Line 878: wip_constants.yes, nvl(bdr.efficiency, 1), 1)

874: select least(wor.assigned_units, bdr.capacity_units),
875: decode(wp.include_resource_utilization,
876: wip_constants.yes, nvl(bdr.utilization, 1), 1),
877: decode(wp.include_resource_efficiency,
878: wip_constants.yes, nvl(bdr.efficiency, 1), 1)
879: into l_units, l_utilization, l_efficiency
880: from wip_operation_resources wor,
881: bom_department_resources bdr,
882: wip_parameters wp

Line 1228: if (g_logLevel <= wip_constants.trace_logging) then

1224: procedure log_time(p_msg IN VARCHAR2, p_date IN DATE DEFAULT SYSDATE) IS
1225: l_returnStatus varchar2(1);
1226: BEGIN
1227:
1228: if (g_logLevel <= wip_constants.trace_logging) then
1229: wip_logger.log((to_char(p_date,'hh:mi:ss') || '-' || p_msg),l_returnStatus);
1230: end if;
1231: END log_time;
1232:

Line 1338: if (g_logLevel <= wip_constants.trace_logging) then

1334: PROCEDURE trace_log(p_msg IN VARCHAR2) IS
1335: l_returnStatus varchar2(1);
1336: BEGIN
1337: fnd_file.put_line(fnd_file.log,p_msg);
1338: if (g_logLevel <= wip_constants.trace_logging) then
1339: wip_logger.log(p_msg,l_returnStatus);
1340: end if;
1341: END trace_log;
1342: