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 917: wip_constants.yes, nvl(bdr.utilization, 1), 1),

913: if( l_remaining_usage is not null ) then
914:
915: select least(wor.assigned_units, bdr.capacity_units),
916: decode(wp.include_resource_utilization,
917: wip_constants.yes, nvl(bdr.utilization, 1), 1),
918: decode(wp.include_resource_efficiency,
919: wip_constants.yes, nvl(bdr.efficiency, 1), 1)
920: into l_units, l_utilization, l_efficiency
921: from wip_operation_resources wor,

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

915: select least(wor.assigned_units, bdr.capacity_units),
916: decode(wp.include_resource_utilization,
917: wip_constants.yes, nvl(bdr.utilization, 1), 1),
918: decode(wp.include_resource_efficiency,
919: wip_constants.yes, nvl(bdr.efficiency, 1), 1)
920: into l_units, l_utilization, l_efficiency
921: from wip_operation_resources wor,
922: bom_department_resources bdr,
923: wip_parameters wp

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

1265: procedure log_time(p_msg IN VARCHAR2, p_date IN DATE DEFAULT SYSDATE) IS
1266: l_returnStatus varchar2(1);
1267: BEGIN
1268:
1269: if (g_logLevel <= wip_constants.trace_logging) then
1270: wip_logger.log((to_char(p_date,'hh:mi:ss') || '-' || p_msg),l_returnStatus);
1271: end if;
1272: END log_time;
1273:

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

1375: PROCEDURE trace_log(p_msg IN VARCHAR2) IS
1376: l_returnStatus varchar2(1);
1377: BEGIN
1378: fnd_file.put_line(fnd_file.log,p_msg);
1379: if (g_logLevel <= wip_constants.trace_logging) then
1380: wip_logger.log(p_msg,l_returnStatus);
1381: end if;
1382: END trace_log;
1383:

Line 1733: select to_char(l_shift_date, WIP_CONSTANTS.DATETIME_FMT)

1729: else
1730: l_c_shift_date := l_shift_date;
1731: end if;
1732:
1733: select to_char(l_shift_date, WIP_CONSTANTS.DATETIME_FMT)
1734: into l_result
1735: from dual;
1736: else
1737: l_result := null;

Line 1791: select to_char(l_c_clock_date, WIP_CONSTANTS.DATETIME_FMT)

1787: from wip_entities we
1788: where we.wip_entity_id = l_wip_entity_id
1789: and we.organization_id = p_org_id;
1790:
1791: select to_char(l_c_clock_date, WIP_CONSTANTS.DATETIME_FMT)
1792: into l_clock_desc
1793: from dual;
1794:
1795: select wip_ws_util.get_jobop_name(l_job_name, l_op_seq)

Line 1834: if inv_cache.get_serial_tagged(p_org_id,p_comp_item_id,WIP_CONSTANTS.ISSCOMP_TYPE) = WIP_CONSTANTS.SER_TAGGED then

1830: l_control_code := 2;
1831: elsif l_serial_control in (2,5) then
1832: l_control_code := 3;
1833: else
1834: if inv_cache.get_serial_tagged(p_org_id,p_comp_item_id,WIP_CONSTANTS.ISSCOMP_TYPE) = WIP_CONSTANTS.SER_TAGGED then
1835: l_control_code := 3;
1836: else
1837: l_control_code := 1;
1838: end if;