APPS.WSH_PICKING_BATCHES_PKG dependencies on MTL_TXN_REQUEST_HEADERS

Line 108: -- bug 5117876, use sequence mtl_txn_request_headers_s

104: --
105: CURSOR C IS SELECT rowid FROM WSH_PICKING_BATCHES
106: WHERE batch_id = X_Batch_Id;
107:
108: -- bug 5117876, use sequence mtl_txn_request_headers_s
109: -- CURSOR NEXTID IS SELECT wsh_picking_batches_s.nextval FROM sys.dual;
110: CURSOR NEXTID IS SELECT mtl_txn_request_headers_s.nextval FROM sys.dual;
111:
112: -- bug 5117876, add one more parameter batchid

Line 110: CURSOR NEXTID IS SELECT mtl_txn_request_headers_s.nextval FROM sys.dual;

106: WHERE batch_id = X_Batch_Id;
107:
108: -- bug 5117876, use sequence mtl_txn_request_headers_s
109: -- CURSOR NEXTID IS SELECT wsh_picking_batches_s.nextval FROM sys.dual;
110: CURSOR NEXTID IS SELECT mtl_txn_request_headers_s.nextval FROM sys.dual;
111:
112: -- bug 5117876, add one more parameter batchid
113: /*
114: CURSOR Batch (batch_name VARCHAR2) IS

Line 124: SELECT header_id FROM MTL_TXN_REQUEST_HEADERS

120: Where NAME = batch_name OR batch_id = batchid;
121:
122: --
123: CURSOR Move_Order (batch_name VARCHAR2) IS
124: SELECT header_id FROM MTL_TXN_REQUEST_HEADERS
125: WHERE request_number = batch_name;
126: --
127: userid NUMBER;
128: loginid NUMBER;