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 1786: SELECT wms_transactions_temp_s.NEXTVAL

1782: WHERE organization_id = l_request_line_rec.organization_id;
1783:
1784: /* Bug # 5265024
1785: CURSOR l_wms_txn_temp_id_csr IS
1786: SELECT wms_transactions_temp_s.NEXTVAL
1787: FROM DUAL;
1788: */
1789:
1790: BEGIN

Line 2261: VALUES ( wms_transactions_temp_s.NEXTVAL

2257: , transaction_quantity
2258: , primary_quantity
2259: , secondary_quantity
2260: )
2261: VALUES ( wms_transactions_temp_s.NEXTVAL
2262: -- l_pp_transaction_temp_id
2263: , l_request_line_rec.line_id
2264: , 2
2265: , 1