eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_AUTOLOTPROC_PRIV dependencies on WIP_COMPONENT_OBJ_T

Line 126: l_curItem system.wip_component_obj_t;

122: l_returnStatus VARCHAR2(1);
123: l_msgCount NUMBER;
124: l_msgData VARCHAR2(240);
125: l_numLotsDerived NUMBER;
126: l_curItem system.wip_component_obj_t;
127: l_treeID NUMBER;
128: l_prevItem NUMBER := -1;
129: l_lotTbl system.wip_txn_lot_tbl_t;
130: l_params wip_logger.param_tbl_t;

Line 261: l_item system.wip_component_obj_t;

257: x_returnStatus OUT NOCOPY VARCHAR2) is
258: l_itemRec itemInfo_rec_t;
259: l_index NUMBER := 1;
260: l_compObj system.wip_lot_serial_obj_t;
261: l_item system.wip_component_obj_t;
262: l_lot system.wip_txn_lot_obj_t;
263: l_lotReturnStatus VARCHAR2(1);
264: l_serialReturnStatus VARCHAR2(1);
265: l_tempReturnStatus VARCHAR2(1);

Line 626: l_item system.wip_component_obj_t;

622: x_returnStatus OUT NOCOPY VARCHAR2) is
623: l_itemRec itemInfo_rec_t;
624: l_index NUMBER := 1;
625: l_compObj system.wip_lot_serial_obj_t;
626: l_item system.wip_component_obj_t;
627: l_lot system.wip_txn_lot_obj_t;
628: l_lotReturnStatus VARCHAR2(1);
629: l_serialReturnStatus VARCHAR2(1);
630: l_tempReturnStatus VARCHAR2(1);

Line 1105: l_item system.wip_component_obj_t;

1101: order by max(sign(round(tln.primary_quantity, wip_constants.max_displayed_precision))), --give priority to lots that have ret txns
1102: max(tln.transaction_date) desc, --then sort by most recent txn date
1103: tln.lot_number desc; --finally sort by lot number, descending b/c issues are ascending
1104:
1105: l_item system.wip_component_obj_t;
1106: l_rmnQty NUMBER;
1107: /* ER 4378835: Increased length of l_lotNumber from 30 to 80 to support OPM Lot-model changes */
1108: l_lotNumber VARCHAR2(80);
1109: l_expDate DATE;

Line 1263: l_item system.wip_component_obj_t;

1259: x_treeID IN OUT NOCOPY NUMBER,
1260: x_compLots IN OUT NOCOPY system.wip_lot_serial_obj_t,
1261: x_returnStatus OUT NOCOPY VARCHAR2) is
1262: l_rmnQty NUMBER;
1263: l_item system.wip_component_obj_t;
1264: l_treeID NUMBER;
1265: /* ER 4378835: Increased length of l_lotNumber from 30 to 80 to support OPM Lot-model changes */
1266: l_lotNumber VARCHAR2(80);
1267: l_returnStatus VARCHAR2(1);

Line 1691: l_item system.wip_component_obj_t;

1687: l_serialControlCode NUMBER;
1688: l_errMsg VARCHAR2(80);
1689: l_params wip_logger.param_tbl_t;
1690: l_returnStatus VARCHAR2(1);
1691: l_item system.wip_component_obj_t;
1692: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1693: begin
1694:
1695: x_returnStatus := fnd_api.g_ret_sts_success;

Line 2279: p_item IN system.wip_component_obj_t,

2275:
2276: PROCEDURE deriveSingleItemFromMOG
2277: (p_parentObjID IN NUMBER,
2278: p_orgID IN NUMBER,
2279: p_item IN system.wip_component_obj_t,
2280: x_compLots IN OUT NOCOPY system.wip_lot_serial_obj_t,
2281: x_returnStatus OUT NOCOPY VARCHAR2) IS
2282:
2283: CURSOR c_lotComp IS

Line 2404: p_item IN system.wip_component_obj_t,

2400:
2401: PROCEDURE setItemRevision
2402: (p_parentObjID IN NUMBER,
2403: p_orgID IN NUMBER,
2404: p_item IN system.wip_component_obj_t,
2405: x_compLots IN OUT NOCOPY system.wip_lot_serial_obj_t,
2406: x_returnStatus OUT NOCOPY VARCHAR2) IS
2407:
2408: CURSOR c_revisionComp IS

Line 2507: l_curItem system.wip_component_obj_t;

2503:
2504: l_returnStatus VARCHAR2(1);
2505: l_errMsg VARCHAR2(80);
2506: l_params wip_logger.param_tbl_t;
2507: l_curItem system.wip_component_obj_t;
2508: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2509: BEGIN
2510: IF (l_logLevel <= wip_constants.trace_logging) THEN
2511: l_params(1).paramName := 'p_orgID';