APPS.WMS_ENGINE_PVT dependencies on WMS_TRANSACTIONS_TEMP_S

Line 36: , serial_number wms_transactions_temp.serial_number%TYPE

32: , to_locator_id wms_transactions_temp.to_locator_id%TYPE
33: , to_cost_group_id wms_transactions_temp.to_cost_group_id%TYPE
34: , lot_number wms_transactions_temp.lot_number%TYPE
35: , lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE
36: , serial_number wms_transactions_temp.serial_number%TYPE
37: , transaction_quantity wms_transactions_temp.transaction_quantity%TYPE
38: , primary_quantity wms_transactions_temp.primary_quantity%TYPE
39: , secondary_quantity wms_transactions_temp.secondary_quantity%TYPE
40: , grade_code wms_transactions_temp.grade_code%TYPE

Line 39: , secondary_quantity wms_transactions_temp.secondary_quantity%TYPE

35: , lot_expiration_date wms_transactions_temp.lot_expiration_date%TYPE
36: , serial_number wms_transactions_temp.serial_number%TYPE
37: , transaction_quantity wms_transactions_temp.transaction_quantity%TYPE
38: , primary_quantity wms_transactions_temp.primary_quantity%TYPE
39: , secondary_quantity wms_transactions_temp.secondary_quantity%TYPE
40: , grade_code wms_transactions_temp.grade_code%TYPE
41: , rule_id wms_transactions_temp.rule_id%TYPE
42: , reservation_id wms_transactions_temp.reservation_id%TYPE
43: , lpn_id wms_transactions_temp.lpn_id%TYPE);

Line 131: SELECT wms_transactions_temp_s.NEXTVAL

127:
128: --
129: /* Bug 5265024
130: CURSOR l_wms_txn_temp_id_csr IS
131: SELECT wms_transactions_temp_s.NEXTVAL
132: FROM DUAL;
133: */
134:
135: l_wms_txn_temp_tbl_size NUMBER;

Line 201: wms_transactions_temp_s.NEXTVAL

197: , to_cost_group_id
198: , lpn_id
199: )
200: VALUES (
201: wms_transactions_temp_s.NEXTVAL
202: -- l_temp_id_tbl(l_counter)
203: , p_wms_txn_temp_tbl(l_counter).transaction_temp_id
204: , p_wms_txn_temp_tbl(l_counter).type_code
205: , p_wms_txn_temp_tbl(l_counter).line_type_code

Line 1800: SELECT wms_transactions_temp_s.NEXTVAL

1796: WHERE organization_id = l_request_line_rec.organization_id;
1797:
1798: /* Bug # 5265024
1799: CURSOR l_wms_txn_temp_id_csr IS
1800: SELECT wms_transactions_temp_s.NEXTVAL
1801: FROM DUAL;
1802: */
1803:
1804: --BUG14517947

Line 2471: VALUES ( wms_transactions_temp_s.NEXTVAL

2467: , transaction_quantity
2468: , primary_quantity
2469: , secondary_quantity
2470: )
2471: VALUES ( wms_transactions_temp_s.NEXTVAL
2472: -- l_pp_transaction_temp_id
2473: , l_request_line_rec.line_id
2474: , 2
2475: , 1