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 1111: l_item system.wip_component_obj_t;

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

Line 1269: l_item system.wip_component_obj_t;

1265: x_treeID IN OUT NOCOPY NUMBER,
1266: x_compLots IN OUT NOCOPY system.wip_lot_serial_obj_t,
1267: x_returnStatus OUT NOCOPY VARCHAR2) is
1268: l_rmnQty NUMBER;
1269: l_item system.wip_component_obj_t;
1270: l_treeID NUMBER;
1271: /* ER 4378835: Increased length of l_lotNumber from 30 to 80 to support OPM Lot-model changes */
1272: l_lotNumber VARCHAR2(80);
1273: l_returnStatus VARCHAR2(1);

Line 1755: l_item system.wip_component_obj_t;

1751: l_TxnTypeID NUMBER;
1752: l_errMsg VARCHAR2(80);
1753: l_params wip_logger.param_tbl_t;
1754: l_returnStatus VARCHAR2(1);
1755: l_item system.wip_component_obj_t;
1756: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1757: begin
1758:
1759: x_returnStatus := fnd_api.g_ret_sts_success;

Line 2350: p_item IN system.wip_component_obj_t,

2346:
2347: PROCEDURE deriveSingleItemFromMOG
2348: (p_parentObjID IN NUMBER,
2349: p_orgID IN NUMBER,
2350: p_item IN system.wip_component_obj_t,
2351: x_compLots IN OUT NOCOPY system.wip_lot_serial_obj_t,
2352: x_returnStatus OUT NOCOPY VARCHAR2) IS
2353:
2354: CURSOR c_lotComp IS

Line 2475: p_item IN system.wip_component_obj_t,

2471:
2472: PROCEDURE setItemRevision
2473: (p_parentObjID IN NUMBER,
2474: p_orgID IN NUMBER,
2475: p_item IN system.wip_component_obj_t,
2476: x_compLots IN OUT NOCOPY system.wip_lot_serial_obj_t,
2477: x_returnStatus OUT NOCOPY VARCHAR2) IS
2478:
2479: CURSOR c_revisionComp IS

Line 2578: l_curItem system.wip_component_obj_t;

2574:
2575: l_returnStatus VARCHAR2(1);
2576: l_errMsg VARCHAR2(80);
2577: l_params wip_logger.param_tbl_t;
2578: l_curItem system.wip_component_obj_t;
2579: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2580: BEGIN
2581: IF (l_logLevel <= wip_constants.trace_logging) THEN
2582: l_params(1).paramName := 'p_orgID';