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.WMS_POSTALLOC_PVT dependencies on WMS_PR_WORKERS

Line 122: -- Fetches and locks the next record in wms_pr_workers table

118: END print_version_info;
119:
120:
121:
122: -- Fetches and locks the next record in wms_pr_workers table
123: -- for a given batch and worker type
124: PROCEDURE fetch_next_wpr_rec
125: ( p_batch_id IN NUMBER
126: , p_mode IN VARCHAR2

Line 127: , x_wpr_rec OUT NOCOPY wms_pr_workers%ROWTYPE

123: -- for a given batch and worker type
124: PROCEDURE fetch_next_wpr_rec
125: ( p_batch_id IN NUMBER
126: , p_mode IN VARCHAR2
127: , x_wpr_rec OUT NOCOPY wms_pr_workers%ROWTYPE
128: , x_return_status OUT NOCOPY VARCHAR2
129: ) IS
130:
131: l_api_name VARCHAR2(30) := 'fetch_next_wpr_rec';

Line 135: l_wpr_rec wms_pr_workers%ROWTYPE;

131: l_api_name VARCHAR2(30) := 'fetch_next_wpr_rec';
132: l_msg_count NUMBER;
133: l_msg_data VARCHAR2(2000);
134:
135: l_wpr_rec wms_pr_workers%ROWTYPE;
136: l_return_status VARCHAR2(1);
137: l_row_id ROWID;
138: done BOOLEAN := FALSE;
139:

Line 162: FROM wms_pr_workers

158: -- If a record is locked successfully, or if no data found,
159: -- or if an unknown exception occurs, then exit the loop.
160: -- If unable to lock one record, try another (continue looping).
161: SELECT rowid INTO l_row_id
162: FROM wms_pr_workers
163: WHERE batch_id = p_batch_id
164: AND worker_mode = p_mode
165: AND processed_flag = 'N'
166: AND rownum < 2

Line 171: UPDATE wms_pr_workers

167: FOR UPDATE NOWAIT;
168:
169: done := TRUE;
170:
171: UPDATE wms_pr_workers
172: SET processed_flag = 'Y'
173: WHERE rowid = l_row_id
174: RETURNING batch_id
175: , worker_mode

Line 379: UPDATE wms_pr_workers

375: SET operation_plan_id = l_op_plan_id
376: WHERE transaction_batch_id = p_transaction_batch_id;
377: END IF; --}
378:
379: UPDATE wms_pr_workers
380: SET worker_mode = 'TTA', processed_flag = 'N'
381: WHERE transaction_batch_id = p_transaction_batch_id;
382:
383: COMMIT;

Line 422: l_wpr_rec wms_pr_workers%ROWTYPE;

418: l_api_name VARCHAR2(30) := 'assign_operation_plans';
419: l_msg_count NUMBER;
420: l_msg_data VARCHAR2(2000);
421:
422: l_wpr_rec wms_pr_workers%ROWTYPE;
423: l_api_return_status VARCHAR2(1);
424:
425: BEGIN
426: x_return_status := fnd_api.g_ret_sts_success;

Line 4989: l_wpr_rec wms_pr_workers%ROWTYPE;

4985: l_msg_data VARCHAR2(2000);
4986:
4987: l_mmtt_temp_id tbl_num;
4988: l_api_return_status VARCHAR2(1);
4989: l_wpr_rec wms_pr_workers%ROWTYPE;
4990:
4991: CURSOR c_split_tasks (p_txn_batch_id NUMBER) IS
4992: SELECT transaction_temp_id
4993: FROM mtl_material_transactions_temp

Line 5229: UPDATE wms_pr_workers

5225: SET standard_operation_id = l_task_type_id
5226: WHERE transaction_batch_id = p_transaction_batch_id;
5227: END IF; --}
5228:
5229: UPDATE wms_pr_workers
5230: SET worker_mode = 'TSPLIT', processed_flag = 'N'
5231: WHERE transaction_batch_id = p_transaction_batch_id;
5232:
5233: COMMIT;

Line 5272: l_wpr_rec wms_pr_workers%ROWTYPE;

5268: l_msg_count NUMBER;
5269: l_msg_data VARCHAR2(2000);
5270:
5271: l_api_return_status VARCHAR2(1);
5272: l_wpr_rec wms_pr_workers%ROWTYPE;
5273: l_tta_done BOOLEAN;
5274:
5275: BEGIN
5276: x_return_status := fnd_api.g_ret_sts_success;

Line 7241: l_wpr_rec wms_pr_workers%ROWTYPE;

7237:
7238: l_api_return_status VARCHAR2(1);
7239: l_lbl_api_status VARCHAR2(1);
7240: l_label_status VARCHAR2(500);
7241: l_wpr_rec wms_pr_workers%ROWTYPE;
7242: t_carton_id inv_label.transaction_id_rec_type;
7243: t_cspk_temp_id inv_label.transaction_id_rec_type;
7244: l_wpr_counter NUMBER;
7245: l_txn_batch_ctr NUMBER;

Line 7290: DELETE wms_pr_workers

7286: , p_transaction_id => t_carton_id
7287: );
7288:
7289: FORALL ii IN t_carton_id.FIRST .. t_carton_id.LAST
7290: DELETE wms_pr_workers
7291: WHERE cartonization_id = t_carton_id(ii);
7292:
7293: IF l_lbl_api_status <> fnd_api.g_ret_sts_success THEN
7294: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL');

Line 7341: DELETE wms_pr_workers

7337: , p_transaction_id => t_carton_id
7338: );
7339:
7340: FORALL jj IN t_carton_id.FIRST .. t_carton_id.LAST
7341: DELETE wms_pr_workers
7342: WHERE cartonization_id = t_carton_id(jj);
7343:
7344: IF l_lbl_api_status <> fnd_api.g_ret_sts_success THEN
7345: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL');

Line 7416: DELETE FROM wms_pr_workers

7412: SET transaction_batch_id = NULL
7413: WHERE transaction_batch_id = t_txn_batch_id(kk);
7414:
7415: FORALL mm IN t_txn_batch_id.FIRST .. t_txn_batch_id.LAST
7416: DELETE FROM wms_pr_workers
7417: WHERE transaction_batch_id = t_txn_batch_id(mm);
7418: END IF;
7419:
7420: COMMIT;

Line 7438: DELETE wms_pr_workers

7434: CLOSE c_lblprnt;
7435: END IF;
7436: IF t_carton_id.COUNT > 0 THEN
7437: FORALL jj IN t_carton_id.FIRST .. t_carton_id.LAST
7438: DELETE wms_pr_workers
7439: WHERE cartonization_id = t_carton_id(jj);
7440: COMMIT;
7441: END IF;
7442: IF t_txn_batch_id.COUNT > 0 THEN

Line 7448: DELETE FROM wms_pr_workers

7444: UPDATE mtl_material_transactions_temp
7445: SET transaction_batch_id = NULL
7446: WHERE transaction_batch_id = t_txn_batch_id(kk);
7447: FORALL mm IN t_txn_batch_id.FIRST .. t_txn_batch_id.LAST
7448: DELETE FROM wms_pr_workers
7449: WHERE transaction_batch_id = t_txn_batch_id(mm);
7450: COMMIT;
7451: END IF;
7452:

Line 7463: DELETE wms_pr_workers

7459: CLOSE c_lblprnt;
7460: END IF;
7461: IF t_carton_id.COUNT > 0 THEN
7462: FORALL jj IN t_carton_id.FIRST .. t_carton_id.LAST
7463: DELETE wms_pr_workers
7464: WHERE cartonization_id = t_carton_id(jj);
7465: COMMIT;
7466: END IF;
7467: IF t_txn_batch_id.COUNT > 0 THEN

Line 7473: DELETE FROM wms_pr_workers

7469: UPDATE mtl_material_transactions_temp
7470: SET transaction_batch_id = NULL
7471: WHERE transaction_batch_id = t_txn_batch_id(kk);
7472: FORALL mm IN t_txn_batch_id.FIRST .. t_txn_batch_id.LAST
7473: DELETE FROM wms_pr_workers
7474: WHERE transaction_batch_id = t_txn_batch_id(mm);
7475: COMMIT;
7476: END IF;
7477: