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_TRANSACTIONS_PKG dependencies on WIP_SERIAL_NUMBER_CLEANUP

Line 22: sn_recs wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_REC;

18: alloc_recs wip_move_alloc_cleanup.WIP_MOVE_TXN_ALLOCATIONS_REC;
19: mtl_temp_recs wip_mtl_txns_temp_cleanup.MTL_TRANSACTIONS_TEMP_REC;
20: sn_temp_recs wip_serial_temp_cleanup.MTL_SERIAL_NUMBERS_TEMP_REC;
21: lt_temp_recs wip_lot_temp_cleanup.MTL_TRANSACTION_LOTS_TEMP_REC;
22: sn_recs wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_REC;
23: sn_marks wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_MARK_REC;
24:
25: cursor overcpl_move_id is
26: select wmti1.transaction_id

Line 23: sn_marks wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_MARK_REC;

19: mtl_temp_recs wip_mtl_txns_temp_cleanup.MTL_TRANSACTIONS_TEMP_REC;
20: sn_temp_recs wip_serial_temp_cleanup.MTL_SERIAL_NUMBERS_TEMP_REC;
21: lt_temp_recs wip_lot_temp_cleanup.MTL_TRANSACTION_LOTS_TEMP_REC;
22: sn_recs wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_REC;
23: sn_marks wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_MARK_REC;
24:
25: cursor overcpl_move_id is
26: select wmti1.transaction_id
27: from wip_move_txn_interface wmti,

Line 119: if (x_retcode <> wip_serial_number_cleanup.SUCCESS) then

115: p_retcode => x_retcode,
116: p_app => x_app,
117: p_msg => x_msg);
118:
119: if (x_retcode <> wip_serial_number_cleanup.SUCCESS) then
120: rollback;
121: err_code := FAILURE;
122: err_app := x_app;
123: err_msg := x_msg;

Line 149: mtl_dyn_sn_recs wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_REC;

145: err_msg out NOCOPY varchar2) is
146: mtl_tmp_recs wip_mtl_txns_temp_cleanup.MTL_TRANSACTIONS_TEMP_REC;
147: mtl_sn_tmp_recs wip_serial_temp_cleanup.MTL_SERIAL_NUMBERS_TEMP_REC;
148: mtl_lt_tmp_recs wip_lot_temp_cleanup.MTL_TRANSACTION_LOTS_TEMP_REC;
149: mtl_dyn_sn_recs wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_REC;
150: mtl_sn_mrks wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_MARK_REC;
151:
152: x_retcode number;
153: x_app varchar2(3);

Line 150: mtl_sn_mrks wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_MARK_REC;

146: mtl_tmp_recs wip_mtl_txns_temp_cleanup.MTL_TRANSACTIONS_TEMP_REC;
147: mtl_sn_tmp_recs wip_serial_temp_cleanup.MTL_SERIAL_NUMBERS_TEMP_REC;
148: mtl_lt_tmp_recs wip_lot_temp_cleanup.MTL_TRANSACTION_LOTS_TEMP_REC;
149: mtl_dyn_sn_recs wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_REC;
150: mtl_sn_mrks wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_MARK_REC;
151:
152: x_retcode number;
153: x_app varchar2(3);
154: x_msg varchar2(30);

Line 181: if (x_retcode <> wip_serial_number_cleanup.SUCCESS) then

177: p_retcode => x_retcode,
178: p_app => x_app,
179: p_msg => x_msg);
180:
181: if (x_retcode <> wip_serial_number_cleanup.SUCCESS) then
182: rollback;
183: err_code := FAILURE;
184: err_app := x_app;
185: err_msg := x_msg;

Line 212: cmp_dyn_sn_recs wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_REC;

208:
209: cmp_mtl_tmp_recs wip_mtl_txns_temp_cleanup.MTL_TRANSACTIONS_TEMP_REC;
210: cmp_sn_tmp_recs wip_serial_temp_cleanup.MTL_SERIAL_NUMBERS_TEMP_REC;
211: cmp_lt_tmp_recs wip_lot_temp_cleanup.MTL_TRANSACTION_LOTS_TEMP_REC;
212: cmp_dyn_sn_recs wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_REC;
213: cmp_sn_mrks wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_MARK_REC;
214:
215: bf_mtl_tmp_recs wip_mtl_txns_temp_cleanup.MTL_TRANSACTIONS_TEMP_REC;
216: bf_sn_tmp_recs wip_serial_temp_cleanup.MTL_SERIAL_NUMBERS_TEMP_REC;

Line 213: cmp_sn_mrks wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_MARK_REC;

209: cmp_mtl_tmp_recs wip_mtl_txns_temp_cleanup.MTL_TRANSACTIONS_TEMP_REC;
210: cmp_sn_tmp_recs wip_serial_temp_cleanup.MTL_SERIAL_NUMBERS_TEMP_REC;
211: cmp_lt_tmp_recs wip_lot_temp_cleanup.MTL_TRANSACTION_LOTS_TEMP_REC;
212: cmp_dyn_sn_recs wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_REC;
213: cmp_sn_mrks wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_MARK_REC;
214:
215: bf_mtl_tmp_recs wip_mtl_txns_temp_cleanup.MTL_TRANSACTIONS_TEMP_REC;
216: bf_sn_tmp_recs wip_serial_temp_cleanup.MTL_SERIAL_NUMBERS_TEMP_REC;
217: bf_lt_tmp_recs wip_lot_temp_cleanup.MTL_TRANSACTION_LOTS_TEMP_REC;

Line 218: bf_dyn_sn_recs wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_REC;

214:
215: bf_mtl_tmp_recs wip_mtl_txns_temp_cleanup.MTL_TRANSACTIONS_TEMP_REC;
216: bf_sn_tmp_recs wip_serial_temp_cleanup.MTL_SERIAL_NUMBERS_TEMP_REC;
217: bf_lt_tmp_recs wip_lot_temp_cleanup.MTL_TRANSACTION_LOTS_TEMP_REC;
218: bf_dyn_sn_recs wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_REC;
219: bf_sn_mrks wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_MARK_REC;
220:
221: -- Overcompletion
222: oc_move_recs wip_move_txn_interface_cleanup.WIP_MOVE_TXN_INTERFACE_REC;

Line 219: bf_sn_mrks wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_MARK_REC;

215: bf_mtl_tmp_recs wip_mtl_txns_temp_cleanup.MTL_TRANSACTIONS_TEMP_REC;
216: bf_sn_tmp_recs wip_serial_temp_cleanup.MTL_SERIAL_NUMBERS_TEMP_REC;
217: bf_lt_tmp_recs wip_lot_temp_cleanup.MTL_TRANSACTION_LOTS_TEMP_REC;
218: bf_dyn_sn_recs wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_REC;
219: bf_sn_mrks wip_serial_number_cleanup.MTL_SERIAL_NUMBERS_MARK_REC;
220:
221: -- Overcompletion
222: oc_move_recs wip_move_txn_interface_cleanup.WIP_MOVE_TXN_INTERFACE_REC;
223: oc_alloc_recs wip_move_alloc_cleanup.WIP_MOVE_TXN_ALLOCATIONS_REC;

Line 286: wip_serial_number_cleanup.insert_rows(p_serials => cmp_dyn_sn_recs);

282:
283: -- post lot and serial records
284: wip_lot_temp_cleanup.insert_rows(p_lots => cmp_lt_tmp_recs);
285: wip_serial_temp_cleanup.insert_rows(p_serials => cmp_sn_tmp_recs);
286: wip_serial_number_cleanup.insert_rows(p_serials => cmp_dyn_sn_recs);
287: wip_serial_number_cleanup.mark(
288: p_serials => cmp_sn_mrks,
289: p_retcode => x_retcode);
290: if (x_retcode <> wip_serial_number_cleanup.SUCCESS) then

Line 287: wip_serial_number_cleanup.mark(

283: -- post lot and serial records
284: wip_lot_temp_cleanup.insert_rows(p_lots => cmp_lt_tmp_recs);
285: wip_serial_temp_cleanup.insert_rows(p_serials => cmp_sn_tmp_recs);
286: wip_serial_number_cleanup.insert_rows(p_serials => cmp_dyn_sn_recs);
287: wip_serial_number_cleanup.mark(
288: p_serials => cmp_sn_mrks,
289: p_retcode => x_retcode);
290: if (x_retcode <> wip_serial_number_cleanup.SUCCESS) then
291: rollback;

Line 290: if (x_retcode <> wip_serial_number_cleanup.SUCCESS) then

286: wip_serial_number_cleanup.insert_rows(p_serials => cmp_dyn_sn_recs);
287: wip_serial_number_cleanup.mark(
288: p_serials => cmp_sn_mrks,
289: p_retcode => x_retcode);
290: if (x_retcode <> wip_serial_number_cleanup.SUCCESS) then
291: rollback;
292: err_code := x_retcode;
293: err_app := 'INV';
294: err_msg := 'INV_RPC_CLEANUP_ERROR';

Line 321: if (x_retcode <> wip_serial_number_cleanup.SUCCESS) then

317: p_ser_marks => bf_sn_mrks,
318: p_retcode => x_retcode,
319: p_app => x_app,
320: p_msg => x_msg);
321: if (x_retcode <> wip_serial_number_cleanup.SUCCESS) then
322: rollback;
323: err_code := FAILURE;
324: err_app := x_app;
325: err_msg := x_msg;