APPS.WSH_PICKING_BATCHES_PKG dependencies on MTL_TXN_REQUEST_HEADERS

Line 109: -- bug 5117876, use sequence mtl_txn_request_headers_s

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

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

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

Line 125: SELECT header_id FROM MTL_TXN_REQUEST_HEADERS

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