[Home] [Help]
60: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
61: l_curLot VARCHAR2(30) := null;
62: l_errMsg VARCHAR2(240);
63: l_returnStatus VARCHAR2(1);
64: l_item system.wip_component_obj_t;
65: l_lotComp c_lotComp%ROWTYPE;
66: l_params wip_logger.param_tbl_t;
67: l_serialComp c_serialComp%ROWTYPE;
68:
216:
217: PROCEDURE setItemRevision
218: (p_parentObjID IN NUMBER,
219: p_orgID IN NUMBER,
220: p_item IN system.wip_component_obj_t,
221: x_compLots IN OUT NOCOPY system.wip_lot_serial_obj_t,
222: x_returnStatus OUT NOCOPY VARCHAR2) IS
223:
224: CURSOR c_revisionComp IS
334: x_returnStatus OUT NOCOPY VARCHAR2) IS
335: l_returnStatus VARCHAR2(1);
336: l_errMsg VARCHAR2(80);
337: l_params wip_logger.param_tbl_t;
338: l_curItem system.wip_component_obj_t;
339: l_txnTypeId NUMBER;
340: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
341: BEGIN
342: IF (l_logLevel <= wip_constants.trace_logging) THEN